SELECT `table_thumbs`.*, `table_childs`.`parent`, `table_childs`.`child`, `table_groups`.`group` FROM ( SELECT `images`.`id`, `images`.`timestamp`, `images`.`name`, `images_files`.`file`, `table_rating`.`explicit` FROM `images` INNER JOIN `images_files` ON `images`.`id` = `images_files`.`imageid` LEFT JOIN ( SELECT `imageid`, `tagid` `explicit` FROM `tags_images` WHERE `tagid` = "1" ) `table_rating` ON `images`.`id` = `table_rating`.`imageid` ) `table_thumbs` LEFT JOIN ( SELECT `images`.`id`, `table_parents`.`parentid` `parent`, `table_childs`.`childid` `child` FROM `images` LEFT JOIN `images_childs` `table_parents` ON `images`.`id` = `table_parents`.`parentid` LEFT JOIN `images_childs` `table_childs` ON `images`.`id` = `table_childs`.`childid` ) `table_childs` ON `table_thumbs`.`id` = `table_childs`.`id` LEFT JOIN ( SELECT `imageid`, `groupid` `group` FROM `groups_images` GROUP BY `imageid` ) `table_groups` ON `table_thumbs`.`id` = `table_groups`.`imageid` WHERE `table_thumbs`.`explicit` IS NULL AND `table_childs`.`parent` IS NOT NULL
home

[

art groups tags

]

Showing images 0 ~ 7 of 7.


Tags

NULL NULL NULL NULL NULL NULL NULL