25 389 16
SELECT p.ID id
FROM yadata_posts p
JOIN yadata_postmeta meta0 ON p.ID = meta0.post_id AND meta0.meta_key = 'is_active'
JOIN yadata_postmeta meta_order ON p.ID = meta_order.post_id AND meta_order.meta_key = 'associate_details_last_name'
WHERE
p.post_status = 'publish'
AND meta0.meta_value = '1'
AND p.post_type = 'associates' order by p.post_title asc