| 1 | SELECT `Fpfile`.`id`, `Fpfile`.`filename`, `Fpfile`.`caption`, `Fpfile`.`tp`, `Fpfile`.`flag`, `Fpfile`.`created`, `Image`.`twidth`, `Image`.`theight`, `Image`.`width`, `Image`.`height`, `Image`.`has_tags`, `Image`.`has_people`, `Descr`.`txt`, `AlbumsFile`.`id`, `AlbumsFile`.`ord` FROM `novafotopa`.`files` AS `Fpfile` JOIN albums_files AS AlbumsFile ON (AlbumsFile.file_id = Fpfile.id) LEFT JOIN images AS Image ON (Image.file_id = Fpfile.id) LEFT JOIN files__descr AS Descr ON (Descr.file_id = Fpfile.id) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 26255 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Fpfile`.`tp` = 0 AND `Album`.`user_id` = 12098 AND `Album`.`access` = 0 ORDER BY `AlbumsFile`.`ord` asc, `AlbumsFile`.`file_id` desc LIMIT 20 | | 20 | 20 | 4 |
