join

I’m trying to create a query to get all data (for the general, obtain the ten first values, using limit and offset). The problem shows up, when the front request wants to show the data at the first time, and these always don’t need a filter. The query is the next select f.farm_name, l.lot_name, c.crop_name, …