$qry = SELECT DISTINCT(t1.pid), t2.name FROM adcell_direct as t1, adcell_program as t2 WHERE t1.pid<>6 AND t1.uid_get=1 AND t1.status>=0 AND NOT (t2.cat & 8388608) AND t2.id=t1.pid AND t2.active=1 AND t2.catname<>"" ORDER BY t2.name ASC