1 | DESCRIBE `photos` | | 8 | 8 | 1 |
2 | DESCRIBE `users` | | 7 | 7 | 1 |
3 | DESCRIBE `artists` | | 8 | 8 | 1 |
4 | DESCRIBE `presents` | | 10 | 10 | 1 |
5 | DESCRIBE `tour_dates` | | 14 | 14 | 1 |
6 | DESCRIBE `records` | | 13 | 13 | 1 |
7 | DESCRIBE `reviews` | | 12 | 12 | 1 |
8 | DESCRIBE `headlines` | | 10 | 10 | 1 |
9 | DESCRIBE `media` | | 11 | 11 | 1 |
10 | DESCRIBE `audioplayer` | | 4 | 4 | 0 |
11 | DESCRIBE `links` | | 7 | 7 | 0 |
12 | SELECT DISTINCT `Artist`.`title`, `Artist`.`id` FROM `photos` AS `Photo` LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Artist`.`enable` != "0000-00-00 00:00:00" AND `Photo`.`artist_id` = `Artist`.`id`) WHERE `Photo`.`enable` != '0000-00-00 00:00:00' AND `Photo`.`enable` <= '2022-08-15 10:09:28' | | 52 | 52 | 1 |
13 | SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Artist`.`enable` != "0000-00-00 00:00:00" AND `Photo`.`artist_id` = `Artist`.`id`) WHERE `Artist`.`title` = 'Electrelane (Popfrenzy Presents)' | | 1 | 1 | 1 |
14 | SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`image`, `Photo`.`artist_id` FROM `photos` AS `Photo` LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `artists` AS `Artist` ON (`Artist`.`enable` != "0000-00-00 00:00:00" AND `Photo`.`artist_id` = `Artist`.`id`) WHERE `Artist`.`title` = 'Electrelane (Popfrenzy Presents)' ORDER BY `Photo`.`id` DESC LIMIT 20 | | 1 | 1 | 1 |