string(858) "SELECT
c.id,
c.lang_key,
c.meta_title,
c.meta_description,
COUNT(CASE WHEN u.user_id IS NOT NULL AND u.admin = '3' THEN b.id END) as blog_count
FROM Wo_cities c
LEFT JOIN Wo_Blog_Escort b ON c.id = b.cities
LEFT JOIN Wo_Users u ON b.user_id = u.user_id
GROUP BY c.id, c.lang_key, c.meta_title, c.meta_description
ORDER BY blog_count DESC, c.id ASC"
Huỳnh Đạt Đỗ | followers
