select i.id, i.name, count(*) as count from band_idols as bi, idols as i where i.id = bi.idol_id and i.country_id = '71' group by i.id order by count desc limit 5 [nativecode=1146 ** Table 'mikseri2_DB.band_idols' doesn't exist]