SELECT * FROM promoter_performer_data ppd LEFT JOIN performers p ON ppd.PRPD_perf_id=p.PERF_id WHERE PRPD_archive=0 AND PERF_archive=0 AND PRPD_promoter_id='1' AND PRPD_image!='' GROUP BY PRPD_image ORDER BY p.PERF_name