SELECT DISTINCT(t2.producator) AS filtru, t3.nume FROM (produse_231 t1 INNER JOIN produse t2 ON t2.id=t1.id) INNER JOIN producatori t3 ON t3.id=t2.producator WHERE t2.vizibil=1 AND t2.producator!="" ORDER BY t3.nume ASCTable 'clickbox_shop.produse_231' doesn't exist