Помогите оптимизировать запрос
-
Добрый день. Сделал запрос
SELECT wp_posts.ID, wp_postmeta_1.meta_value AS make_id, wp_postmeta_2.meta_value AS model_id, wp_postmeta_3.meta_value AS DEPN, wp_postmeta_4.meta_value AS discount, wp_postmeta_5.meta_value AS listpris, wp_postmeta_6.meta_value AS insurance, wp_postmeta_7.meta_value AS transmission, wp_postmeta_8.meta_value AS fueltype, wp_postmeta_9.meta_value AS version_engine, wp_postmeta_10.meta_value AS version_options, wp_postmeta_11.meta_value AS rv_extra_color FROM make, model, wp_postmeta INNER JOIN wp_posts ON wp_postmeta.post_id = wp_posts.ID INNER JOIN wp_postmeta wp_postmeta_1 ON wp_postmeta_1.post_id = wp_posts.ID AND wp_postmeta_1.meta_key = 'car_make' INNER JOIN wp_postmeta wp_postmeta_2 ON wp_postmeta_2.post_id = wp_posts.ID AND wp_postmeta_2.meta_key = 'car_model' INNER JOIN wp_postmeta wp_postmeta_3 ON wp_postmeta_3.post_id = wp_posts.ID AND wp_postmeta_3.meta_key = 'car_DEPN' INNER JOIN wp_postmeta wp_postmeta_4 ON wp_postmeta_4.post_id = wp_posts.ID AND wp_postmeta_4.meta_key = 'car_discount' INNER JOIN wp_postmeta wp_postmeta_5 ON wp_postmeta_5.post_id = wp_posts.ID AND wp_postmeta_5.meta_key = 'car_listpris' INNER JOIN wp_postmeta wp_postmeta_6 ON wp_postmeta_6.post_id = wp_posts.ID AND wp_postmeta_6.meta_key = 'car_insurance' INNER JOIN wp_postmeta wp_postmeta_7 ON wp_postmeta_7.post_id = wp_posts.ID AND wp_postmeta_7.meta_key = 'car_transmission' INNER JOIN wp_postmeta wp_postmeta_8 ON wp_postmeta_8.post_id = wp_posts.ID AND wp_postmeta_8.meta_key = 'car_fueltype' INNER JOIN wp_postmeta wp_postmeta_9 ON wp_postmeta_9.post_id = wp_posts.ID AND wp_postmeta_9.meta_key = 'car_version_engine' INNER JOIN wp_postmeta wp_postmeta_10 ON wp_postmeta_10.post_id = wp_posts.ID AND wp_postmeta_10.meta_key = 'car_version_options' INNER JOIN wp_postmeta wp_postmeta_11 ON wp_postmeta_11.post_id = wp_posts.ID AND wp_postmeta_11.meta_key = 'car_rv_extra_color' WHERE wp_posts.post_type = 'cars' AND wp_postmeta.meta_key = 'car_model' AND wp_postmeta_2.meta_value = '143' GROUP BY wp_posts.ID
Выполняю его через $wpdb->get_results
Можно ли его выполнить через get_posts( $args )?
- Тема «Помогите оптимизировать запрос» закрыта для новых ответов.