string(1468) "SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS pm_filter
ON (wp_posts.ID = pm_filter.post_id AND pm_filter.meta_key = '_total_comments')
LEFT JOIN wp_postmeta AS pm_doc
ON (wp_posts.ID = pm_doc.post_id
AND pm_doc.meta_key = 'attached_doctor'
AND pm_doc.meta_value IS NOT NULL
AND pm_doc.meta_value != '')
LEFT JOIN wp_postmeta AS pm_comments
ON (wp_posts.ID = pm_comments.post_id AND pm_comments.meta_key = '_total_comments')
LEFT JOIN wp_postmeta AS pm_rating
ON (wp_posts.ID = pm_rating.post_id AND pm_rating.meta_key = 'all_rating')
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (5)
AND
tt1.term_taxonomy_id IN (2605)
AND
tt2.term_taxonomy_id IN (3662)
) AND (
( wp_postmeta.meta_key = 'clinick_id' AND wp_postmeta.meta_value = '18095' )
) AND ((wp_posts.post_type = 'doctors' AND (wp_posts.post_status = 'publish')))
GROUP BY wp_posts.ID
ORDER BY
(pm_doc.post_id IS NOT NULL) DESC,
CAST(COALESCE(pm_rating.meta_value, 0) AS DECIMAL(3,1)) DESC,
CAST(COALESCE(pm_comments.meta_value, 0) AS SIGNED) DESC
LIMIT 0, 9"
Семейный психолог Софіївська Борщагівка: відгуки, ціни | ПроЛікарів
