Loading
  1. SELECT FIELDS.field_id, FIELDS.farm_id, FIELDS.field_name, FIELDS.field_area, FIELDS.visible, FIELDS.`date`, FIELDS.true_area, FIELDS.true_boundary, FIELDS.gk_id, FIELDS.gk_farm_id, FIELDS.no_boundary, FIELDS.isgreenlightfield, FIELDS.greenLightId, FIELDS.date_time_added, FIELDS.parentfieldid, FIELDS.area_harvested
  2. FROM FIELDS
  3. INNER JOIN farms ON FIELDS.farm_id = farms.id_farm INNER JOIN trading_name ON farms.trading_id = trading_name.id_trading_name INNER JOIN access_trading ON trading_name.id_trading_name = access_trading.trading_id
  4. WHERE (farms.deleted = 0 OR farms.deleted IS NULL) AND (access_trading.access_id = 4) AND (FIELDS.deleted = 0) AND (trading_name.deleted = 0)

Comments

Returns just over 20,000 rows and takes approx 140 seconds to run

Rich • 21 Mar 2016, 14:10:15 UTC