["SELECT   t1.ID,  t1.post_title,  t1.name,  t1.slug,  t1.model_name,  t8.meta_value AS search_first,  t3.meta_value AS search_price,  t4.meta_value AS search_mileage,  t5.meta_value AS search_color,  t6.meta_value AS search_thumbnail,  t7.meta_value AS search_ourcarnumber,  t12.meta_value AS search_car_price,  t9.meta_value AS search_expenses_price,  t10.meta_value AS search_check,  t11.meta_value AS search_assurance,  t1.post_date FROM  (   SELECT w_p.ID,w_p.post_title,w_p.post_date,w_t2.name,w_t2.slug,w_t.name AS model_name   FROM wpbmw_terms AS w_t   LEFT JOIN wpbmw_term_taxonomy AS w_t_t   ON w_t.term_id = w_t_t.term_id   LEFT JOIN wpbmw_term_relationships AS w_t_r   ON w_t_t.term_taxonomy_id = w_t_r.term_taxonomy_id   LEFT JOIN wpbmw_posts AS w_p   ON w_t_r.object_id = w_p.ID   LEFT JOIN wpbmw_term_relationships AS w_t_r2   ON w_p.ID = w_t_r2.object_id   LEFT JOIN wpbmw_term_taxonomy AS w_t_t2   ON w_t_r2.term_taxonomy_id = w_t_t2.term_taxonomy_id   LEFT JOIN wpbmw_terms AS w_t2   ON w_t_t2.term_id = w_t2.term_id   WHERE w_t.slug = :model AND w_t_t.taxonomy = :model_category AND w_t_t2.taxonomy = :category AND w_p.post_type = :post_type AND w_p.post_status = :post_status  ) t1 LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_first'  ) t8 ON t1.ID = t8.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_price'  ) t3 ON t1.ID = t3.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_mileage'  ) t4 ON t1.ID = t4.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_color'  ) t5 ON t1.ID = t5.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_thumbnail'  ) t6 ON t1.ID = t6.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_ourcarnumber'  ) t7 ON t1.ID = t7.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_car_price'  ) t12 ON t1.ID = t12.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_expenses_price'  ) t9 ON t1.ID = t9.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_check'  ) t10 ON t1.ID = t10.post_id LEFT JOIN  (  SELECT *  FROM wpbmw_postmeta  WHERE meta_key = 'search_assurance'  ) t11 ON t1.ID = t11.post_id ORDER BY CAST(ID AS DECIMAL) DESC",0,"",null]