Поддержка Проблемы и решения Помогите оптимизировать запрос

  • Добрый день. Сделал запрос

    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 )?

  • Тема «Помогите оптимизировать запрос» закрыта для новых ответов.