select distinct a.alert_id, a.topic_id, a.atype,a.mem_id, a.clb_id, a.description,a.addl_descr, day(a.created) as date, hour(a.created) as hour, minute(a.created) as minute, substring(monthname(a.created),1,3) as month, c.name as network, c.folder as club_folder, c.country, c.state, c.city,c.network_cat, c.clb_id,c.count_recommends from network_alert a, clubs c where a.clb_id = c.clb_id and a.active = '1' AND a.private='0' and a.clb_id = '122279' ORDER BY a.alert_id DESC LIMIT 0,10:Table 'nualerts_prd.network_alert' doesn't exist