[ + ] [ + ] [ + ] [ + ] : SELECT *, l.id AS id, l.id AS lid, c.id AS cid FROM em_campaign_list c, em_list l WHERE c.listid = l.id AND c.campaignid = '755' GROUP BY l.id [ + ] [ + ]