SELECT n.news_id as id, n.news_name as title, n.news_logo as logo, 1 as type FROM six_news n, six_news_language nl
WHERE n.news_home_type = 1 AND n.news_id=nl.snl_news_id AND nl.snl_language_id=1
union
SELECT v.video_id as id, v.video_name as title, v.video_logo as logo, 2 as type FROM six_videos v
WHERE video_home_type = 1 AND video_language_id = 1
union
SELECT t.trailer_id as id, t.trailer_name as title, t.trailer_logo as logo, 3 as type FROM six_trailer t
WHERE trailer_home_type = 1 AND trailer_language_id = 1
union
SELECT f.cel_film_id as id, f.cel_film_name as title, f.cel_film_logo as logo, 5 as type FROM six_celebrity_film f
WHERE cel_film_home_type = 1
union
SELECT p.photo_id as id, p.photo_name as title, i.spi_image as logo, 4 as type FROM six_photo p, six_photo_images i WHERE p.photo_language_id=1 AND p.photo_status=1 AND p.photo_id=i.spi_photo_id AND p.photo_home_type=1 GROUP BY p.photo_id
LIMIT 0, 8
