SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, r.name as r_name, r.id as r_id FROM #__gbl_proveedores as z, #__djcf_items i LEFT JOIN #__djcf_categories c ON i.cat_id = c.id LEFT JOIN #__djcf_regions r ON i.region_id = r.id WHERE i.date_exp > NOW() AND i.published=1 AND z.id_users=i.user_id AND i.cat_id IN (69) GROUP BY i.user_id ORDER BY z.plan DESC, i.display ASC
DirectorioCarpas

Actualmente no hay anuncios en esta categoría, pero estamos trabajando para tenerlos pronto