SELECT A.id,
A.time,
A.title,
A.body,
A.image,
'' video,
'article' type,
if(type = 3, 'afp', 'local') source
FROM articles A
WHERE A.lang = 'sv'
AND A.time > '1714295460'
AND uid IS null
UNION
SELECT F.id,
F.time,
'' title,
IF(F.body IS NOT null, F.body, F.txt) body,
I.file_name image,
F.video,
'flash' type,
'local' source
FROM flashs F
LEFT JOIN images_bank I on I.id = F.image1
WHERE F.time > '1714295460'
ORDER BY `time` DESC
LIMIT 50
whatshot
Actualités les plus lues
access_time
Les dernières
Matches and results
söndag 12 maj
måndag 13 maj
torsdag 1 januari
Performance of the day
Lights on
d. Ochi - 2/6, 6/3, 6/3
Today's birthdays