Notice (8): Undefined variable: count_target [APP/Model/User/UserMaterial.php, line 351]
Errors | 建設MiL

Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IS NULL) ORDER BY `UserMaterial`.`has_image_flag` desc, `UserMaterial`.`sort_s' at line 1

SQL Query: SELECT `UserMaterial`.`id`, count(`UserMaterial`.`id`) as cnt FROM `kmil`.`materials` AS `UserMaterial` LEFT JOIN `kmil`.`makers` AS `Maker` ON (`UserMaterial`.`maker` = `Maker`.`id`) left JOIN `kmil`.`material_classifications` AS `MaterialClassification` ON (`UserMaterial`.`material_classification` = `MaterialClassification`.`id`) left JOIN `kmil`.`pillars` AS `Pillar` ON (`UserMaterial`.`pillar` = `Pillar`.`id`) left JOIN `kmil`.`bands` AS `Band` ON (`UserMaterial`.`band` = `Band`.`id`) left JOIN `kmil`.`unique_classifications` AS `UniqueClassification` ON (`UserMaterial`.`unique_classification` = `UniqueClassification`.`id`) left JOIN `kmil`.`material_classifications` AS `MaterialClassification2` ON (`UserMaterial`.`material_classification2` = `MaterialClassification2`.`id`) left JOIN `kmil`.`pillars` AS `Pillar2` ON (`UserMaterial`.`pillar2` = `Pillar2`.`id`) left JOIN `kmil`.`bands` AS `Band2` ON (`UserMaterial`.`band2` = `Band2`.`id`) left JOIN `kmil`.`unique_classifications` AS `UniqueClassification2` ON (`UserMaterial`.`unique_classification2` = `UniqueClassification2`.`id`) left JOIN `kmil`.`material_classifications` AS `MaterialClassification3` ON (`UserMaterial`.`material_classification3` = `MaterialClassification3`.`id`) left JOIN `kmil`.`pillars` AS `Pillar3` ON (`UserMaterial`.`pillar3` = `Pillar3`.`id`) left JOIN `kmil`.`bands` AS `Band3` ON (`UserMaterial`.`band3` = `Band3`.`id`) left JOIN `kmil`.`unique_classifications` AS `UniqueClassification3` ON (`UserMaterial`.`unique_classification3` = `UniqueClassification3`.`id`) left JOIN `kmil`.`material_classifications` AS `MaterialClassification4` ON (`UserMaterial`.`material_classification4` = `MaterialClassification4`.`id`) left JOIN `kmil`.`pillars` AS `Pillar4` ON (`UserMaterial`.`pillar4` = `Pillar4`.`id`) left JOIN `kmil`.`bands` AS `Band4` ON (`UserMaterial`.`band4` = `Band4`.`id`) left JOIN `kmil`.`unique_classifications` AS `UniqueClassification4` ON (`UserMaterial`.`unique_classification4` = `UniqueClassification4`.`id`) left JOIN `kmil`.`material_classifications` AS `MaterialClassification5` ON (`UserMaterial`.`material_classification5` = `MaterialClassification5`.`id`) left JOIN `kmil`.`pillars` AS `Pillar5` ON (`UserMaterial`.`pillar5` = `Pillar5`.`id`) left JOIN `kmil`.`bands` AS `Band5` ON (`UserMaterial`.`band5` = `Band5`.`id`) left JOIN `kmil`.`unique_classifications` AS `UniqueClassification5` ON (`UserMaterial`.`unique_classification5` = `UniqueClassification5`.`id`) WHERE `UserMaterial`.`public_flag` = '1' AND `UserMaterial`.`delete_flag` = '0' AND NOT ( IS NULL) ORDER BY `UserMaterial`.`has_image_flag` desc, `UserMaterial`.`sort_search_result` asc, `UserMaterial`.`material_classification` asc, `UserMaterial`.`pillar` asc, `UserMaterial`.`band` asc, `UserMaterial`.`unique_classification` asc, `UserMaterial`.`name_kana` asc

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace