venuspub
SELECT prud.* FROM teach,prud,prucm WHERE ( prud.pruname LIKE '%%' or prud.codpru LIKE '%%' ) and prud.oks='1' and prucm.cm_id IN (8) and prucm.pru_id =prud.pru_id GROUP BY prud.pru_id ORDER BY prud.pru_id DESC Limit 0, 24