SELECT `artists`.`id`, `artists`.`title`, `artist_details`.`slug`, `artist_details`.`tags`, `artist_details`.`facebook`, (SELECT COUNT(*) FROM events LEFT JOIN clubs ON clubs.id = events.club_id LEFT JOIN club_details ON club_details.club_id = clubs.id WHERE club_details.location IN (SELECT id FROM cities) AND events.artist_id = artists.id AND events.start_time > NOW()) AS `count`
FROM `artists`
LEFT JOIN `artist_details` ON `artists`.`id` = `artist_details`.`artist_id`
WHERE `artists`.`deleted_at` IS NULL
ORDER BY `count` DESC, `artists`.`title` ASC
 LIMIT 16
Lista de artisti consacrati acum pe LiveOut
location_on
Calendar
date_range

Artisti