FuelPHP Bin
Sign in
Public
PHP
Save
Fuel\Core\Database_Exception [ 42000 ]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN `students` AS `t2` ON (`t0`.`id` = `t2`.`institution` AND `t2`.`delet' at line 1 with query: "SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`address` AS `t0_c2`, `t0`.`cell` AS `t0_c3`, `t0`.`email` AS `t0_c4`, `t0`.`alias` AS `t0_c5`, `t0`.`status` AS `t0_c6`, `t0`.`deleted_at` AS `t0_c7`, `t0`.`created_at` AS `t0_c8`, `t0`.`updated_at` AS `t0_c9`, `t1`.`id` AS `t1_c0`, `t1`.`parent` AS `t1_c1`, `t1`.`name` AS `t1_c2`, `t1`.`deleted_at` AS `t1_c3`, `t1`.`created_at` AS `t1_c4`, `t1`.`updated_at` AS `t1_c5`, `t2`.`id` AS `t2_c0`, `t2`.`institution` AS `t2_c1`, `t2`.`std` AS `t2_c2`, `t2`.`name` AS `t2_c3`, `t2`.`gender` AS `t2_c4`, `t2`.`cell` AS `t2_c5`, `t2`.`email` AS `t2_c6`, `t2`.`status` AS `t2_c7`, `t2`.`deleted_at` AS `t2_c8`, `t2`.`created_at` AS `t2_c9`, `t2`.`updated_at` AS `t2_c10`, `t3`.`id` AS `t3_c0`, `t3`.`parent` AS `t3_c1`, `t3`.`name` AS `t3_c2`, `t3`.`deleted_at` AS `t3_c3`, `t3`.`created_at` AS `t3_c4`, `t3`.`updated_at` AS `t3_c5`, `t4_through`.`product_id`, `t4_through`.`std_id`, `t4`.`id` AS `t4_c0`, `t4`.`institution_id` AS `t4_c1`, `t4`.`name` AS `t4_c2`, `t4`.`gender` AS `t4_c3`, `t4`.`narration` AS `t4_c4`, `t4`.`user` AS `t4_c5`, `t4`.`deleted_at` AS `t4_c6`, `t4`.`created_at` AS `t4_c7`, `t4`.`updated_at` AS `t4_c8`, `t5`.`id` AS `t5_c0`, `t5`.`institution` AS `t5_c1`, `t5`.`student` AS `t5_c2`, `t5`.`product` AS `t5_c3`, `t5`.`measures` AS `t5_c4`, `t5`.`size` AS `t5_c5`, `t5`.`user` AS `t5_c6`, `t5`.`deleted_at` AS `t5_c7`, `t5`.`created_at` AS `t5_c8`, `t5`.`updated_at` AS `t5_c9` FROM (SELECT `t0`.`id`, `t0`.`name`, `t0`.`address`, `t0`.`cell`, `t0`.`email`, `t0`.`alias`, `t0`.`status`, `t0`.`deleted_at`, `t0`.`created_at`, `t0`.`updated_at` FROM `institutions` AS `t0` WHERE `t0`.`deleted_at` IS null AND (`t0`.`id` = '2') LIMIT 1) AS `t0` LEFT JOIN `stds` AS `t1` ON (`t0`.`id` = `t1`.`parent` AND `t1`.`deleted_at` IS NULL) LEFT INNER JOIN `students` AS `t2` ON (`t0`.`id` = `t2`.`institution` AND `t2`.`deleted_at` IS NULL) LEFT JOIN `stds` AS `t3` ON (`t2`.`std` = `t3`.`id` AND `t3`.`deleted_at` IS NULL) LEFT JOIN `products_stds` AS `t4_through` ON (`t3`.`id` = `t4_through`.`std_id`) LEFT JOIN `products` AS `t4` ON (`t4_through`.`product_id` = `t4`.`id` AND `t4`.`deleted_at` IS NULL) LEFT JOIN `measurements` AS `t5` ON (`t2`.`id` = `t5`.`student` AND `t5`.`deleted_at` IS NULL)"