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
Montajes y eventos
PROVEEDOR
CERTIFICADO
Bogotá
Ranking
Categoria:
Servicios
Alquiler de Carpas, Pisos, Tarima, Calentadores, Sillas, Mesas
VENTO
PROVEEDOR
STANDARD
Bogotá
Ranking
Categoria:
Servicios
Somos una empresa de alquiler de carpas para eventos de cualquier tipo.