1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
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