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