SELECT SQL_CALC_FOUND_ROWS u.s_phone_land as s_phone_land, (SELECT count(*) FROM oc_fr_fr_t_item_resource where fk_i_item_id = oc_fr_fr_t_item.pk_i_id) as resource_count, meta.s_value as s_ad_type, meta_price.s_value as s_price_type, d.s_title as s_title, d.s_description as s_description, loc.*, city.s_slug as s_city_slug, region.s_slug as s_region_slug, cat.s_name as s_category_name, cat.s_slug as s_category_slug, cat.fk_i_category_id, oc_fr_fr_t_item.*, oc_fr_fr_t_item.s_contact_name as s_user_name FROM ( SELECT * FROM (oc_fr_fr_t_item) JOIN oc_fr_fr_t_item_location ON oc_fr_fr_t_item_location.fk_i_item_id = oc_fr_fr_t_item.pk_i_id WHERE oc_fr_fr_t_item.b_deleted = 0 AND oc_fr_fr_t_item.b_enabled = 1 AND oc_fr_fr_t_item.b_active = 1 AND oc_fr_fr_t_item.b_spam = 0 AND (oc_fr_fr_t_item.b_premium = 1 || oc_fr_fr_t_item.dt_expiration >= '2020-04-01 10:52:36') AND oc_fr_fr_t_item.fk_i_category_id IN (1207) AND ( oc_fr_fr_t_item_location.fk_i_region_id = 33 ) AND oc_fr_fr_t_item.pk_i_id IN (SELECT fk_i_item_id FROM oc_fr_fr_t_item_meta WHERE oc_fr_fr_t_item_meta.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND oc_fr_fr_t_item_meta.fk_i_field_id = 1 AND oc_fr_fr_t_item_meta.s_value = 'service') ORDER BY COALESCE(oc_fr_fr_t_item.dt_order_date, oc_fr_fr_t_item.dt_pub_date) desc LIMIT 0, 1000) oc_fr_fr_t_item LEFT JOIN oc_fr_fr_t_user u ON oc_fr_fr_t_item.fk_i_user_id = u.pk_i_id JOIN oc_fr_fr_t_item_meta meta ON meta.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND meta.fk_i_field_id = 1 LEFT JOIN oc_fr_fr_t_item_meta meta_price ON meta_price.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND meta_price.fk_i_field_id = 12 JOIN oc_fr_fr_t_item_description d ON d.fk_i_item_id = oc_fr_fr_t_item.pk_i_id AND d.fk_c_locale_code = 'fr_FR' JOIN oc_fr_fr_t_item_location loc ON loc.fk_i_item_id = oc_fr_fr_t_item.pk_i_id JOIN oc_fr_fr_t_city city ON city.pk_i_id = loc.fk_i_city_id JOIN oc_fr_fr_t_region region ON region.pk_i_id = loc.fk_i_region_id JOIN oc_fr_fr_t_category_description cat ON cat.fk_i_category_id = oc_fr_fr_t_item.fk_i_category_id AND cat.fk_c_locale_code = 'fr_FR' JOIN oc_fr_fr_t_item_location ON oc_fr_fr_t_item_location.fk_i_item_id = oc_fr_fr_t_item.pk_i_id ORDER BY COALESCE(oc_fr_fr_t_item.dt_order_date, oc_fr_fr_t_item.dt_pub_date) desc LIMIT 0, 15