SELECT 
						v.ID,
						v.ObjectID,
						v.type,
						v.publishDate,
						v.timesPlayed,
						v.featured,
						vm.title,
						vm.description,
						CONCAT("videos/video/",v.ID) as address
					FROM bn_videos v
					LEFT JOIN bn_videos_meta vm
					ON vm.VideoID = v.ID
					WHERE v.enabled = 1
					AND v.publishDate <= NOW()
					AND vm.language_id = 1
					ORDER BY v.featured DESC, v.publishDate DESC
					LIMIT 246,6