SELECT *
FROM `photo`
LEFT OUTER JOIN `photo_description` ON `photo`.`photo_id`=`photo_description`.`photo_description_id`
LEFT OUTER JOIN `users` ON `photo`.`photo_avtor_id` = `users`.`user_id`
LEFT OUTER JOIN `avtori` ON `users`.`user_id` = `avtori`.`avtori_pid`
WHERE `photo_moder` = '1'
ORDER BY `photo_id`
DESC
LIMIT 30
Ошибка в PHPMyadmin такая
#1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay