SELECT i.*, AS c_name,c.alias AS c_alias, as c_id, as r_name, as r_id FROM #__gbl_proveedores as z, #__djcf_items i LEFT JOIN #__djcf_categories c ON i.cat_id = LEFT JOIN #__djcf_regions r ON i.region_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

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