SELECT     `xxx_85_anime_mylist`.`ANIME` AS `PROPERTY_ANIME`,  `xxx_85_anime_mylist_main`.*, `MAIN_ANIME_table`.`value` AS `GENRE_ID_PROPERTY_MAIN_ANIME`, `GENRE_table`.`value` AS `GENRE_ID_PROPERTY_GENRE`,                    `table174_`.`value` AS `GENRE_PROPERTY_RU_NAME`,`GENRE_main`.`id` AS `GENRE_id`,  `GENRE_main`.`name` AS `GENRE_name`,                 COUNT(`xxx_85_anime_mylist`.`ANIME`) AS genre_count FROM `xxx_85_anime_mylist_main`  INNER JOIN `xxx_85_anime_mylist` ON `xxx_85_anime_mylist`.`element`=`xxx_85_anime_mylist_main`.`id`  LEFT JOIN `xxx_add_integer` AS `MAIN_ANIME_table` ON `MAIN_ANIME_table`.`value`=`xxx_85_anime_mylist`.`ANIME` AND `MAIN_ANIME_table`.`add`='140' 
 LEFT JOIN `xxx_add_integer` AS `GENRE_table` ON `GENRE_table`.`element`=`MAIN_ANIME_table`.`element` AND `GENRE_table`.`add`='141' 
    LEFT JOIN `xxx_dynamic` AS `GENRE_main` ON `GENRE_main`.`id`=`GENRE_table`.`value`  LEFT JOIN `xxx_add_string` as `table174_` ON `GENRE_table`.`value`=`table174_`.`element` AND `table174_`.`add`=174
 WHERE ( ( `xxx_85_anime_mylist_main`.`created_by` = '453' ) )  GROUP BY `GENRE_table`.`value`  ORDER BY `genre_count` DESC  The table '/tmp/#sql1_1607fe9_0' is fullDB error