1. SQL / Говнокод #22343

    −14

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    28. 28
    29. 29
    30. 30
    31. 31
    SELECT main.id, main.post_title AS title,
        t1.meta_value  AS description,
        t2.meta_value  AS after_course,
        t3.meta_value  AS program,
        t4.meta_value  AS claims,
        t5.meta_value  AS num_times,
        t6.meta_value  AS duration,
        t7.meta_value  AS bg_color,
        t8.meta_value  AS cost,
        t9.meta_value  AS discount,
        t10.meta_value AS date1,
        t11.meta_value AS date2,
        t12.meta_value AS date3,
        t13.meta_value AS date4
FROM wp_posts AS main
LEFT  JOIN wp_postmeta AS t1  ON t1.post_id  = main.id AND t1.meta_key  = 'Описание'
LEFT  JOIN wp_postmeta AS t2  ON t2.post_id  = main.id AND t2.meta_key  = 'После курса'
LEFT  JOIN wp_postmeta AS t3  ON t3.post_id  = main.id AND t3.meta_key  = 'Программа'
LEFT  JOIN wp_postmeta AS t4  ON t4.post_id  = main.id AND t4.meta_key  = 'Требования'
LEFT  JOIN wp_postmeta AS t5  ON t5.post_id  = main.id AND t5.meta_key  = 'time'
LEFT  JOIN wp_postmeta AS t6  ON t6.post_id  = main.id AND t6.meta_key  = 'long'
LEFT  JOIN wp_postmeta AS t7  ON t7.post_id  = main.id AND t7.meta_key  = 'HEX'
LEFT  JOIN wp_postmeta AS t8  ON t8.post_id  = main.id AND t8.meta_key  = 'cost'
LEFT  JOIN wp_postmeta AS t9  ON t9.post_id  = main.id AND t9.meta_key  = 'discont'
LEFT  JOIN wp_postmeta AS t10 ON t10.post_id = main.id AND t10.meta_key = 'date1'
LEFT  JOIN wp_postmeta AS t11 ON t11.post_id = main.id AND t11.meta_key = 'date2'
LEFT  JOIN wp_postmeta AS t12 ON t12.post_id = main.id AND t12.meta_key = 'date3'
LEFT  JOIN wp_postmeta AS t13 ON t13.post_id = main.id AND t13.meta_key = 'date4'
INNER JOIN wp_term_relationships ON main.id = wp_term_relationships.object_id
WHERE wp_term_relationships.term_taxonomy_id = :term_taxonomy_id AND main.post_status = 'publish'
ORDER BY main.menu_order DESC

    нашел на проекте такой кусочек.

    Запостил: serek, 16 Февраля 2017

    Комментарии (5) RSS

    Добавить комментарий