SELECT
op_media.status,
op_media.type,
op_media.key as mediakey,
op_media.date_submitted,
op_media.event_id,
op_media.album_id,
op_media.device,
op_media.title,
op_media.size,
op_media.event_id,
op_media.album_id,
op_event.key as eventkey,
op_event.name as eventname,
op_album.key as albumkey,
op_album.name as albumname,
CONCAT_WS (' ', op_user.name, op_user.surname) as author
FROM
op_media, op_event, op_album, op_user
WHERE
(
(op_event.event_id = op_media.event_id AND op_album.album_id = op_media.album_id)
OR
op_event.event_id IS NULL
)
AND
op_media.user_id = '12118' AND
op_media.uploader_user_id = op_user.user_id
AND op_media.status in ('PENDING', 'REPORTED') AND op_media.type = 'IMAGE'
ORDER BY date_submitted DESC
LIMIT 0, 26