(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 = 11 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 imagen 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= 11 order by RAND() limit 8)
Seguridad de carga y personas