(select exhibitor_id,(select archivo from tlw_directorio_logos where exhibitor_id = `tlw_directorio_videos`.`exhibitor_id`) as archivo_logo,(select name_es from `tlw_directorio` where `tlw_directorio`.`exhibitor_id` = `tlw_directorio_videos`.`exhibitor_id`)as proveedor, url, Description as description, tittle as title, (select pregunta from Lut_Categorias where Lut_Categorias.`Id` = `tlw_directorio_videos`.`idCategory`) as categoria, 'video' as tipo from tlw_directorio_videos where idCategory = 2 and institucional = 0 order by RAND() limit 8)
UNION
(SELECT exhibitor_id, (select archivo from tlw_directorio_logos where exhibitor_id = `tlw_directorio_prod_desc`.`exhibitor_id`) as archivo_logo,(select name_es from `tlw_directorio` where `tlw_directorio`.`exhibitor_id` = tlw_directorio_prod_desc.`exhibitor_id`)as proveedor,(select archivo from tlw_directorio_productos where `tlw_directorio_productos`.`id_prod` = `tlw_directorio_prod_desc`.id limit 1) as url,description,title, (select Pregunta from Lut_Categorias where tlw_directorio_prod_desc.`idCategory` = Lut_Categorias.`Id`) as categoria, 'producto' as tipo
FROM tlw_directorio_prod_desc
where idCategory= 2 order by RAND() limit 8)
Asociaciones, cámaras y entidades empresariales
Los productos/servicios se muestran en forma aleatoria, dale refresh a tu página para ver mas resultados