Warning (2): pg_query() [http://php.net/function.pg-query]: Query failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe92527 [CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 167]
Code | Context
$sql	=	""
pg_query - [internal], line ??
DboPostgres::_execute() - CORE/cake/libs/model/datasources/dbo/dbo_postgres.php, line 167
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 253
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
SearchController::free() - APP/controllers/search_controller.php, line 225
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Warning (512): SQL Error: ERROR:  invalid byte sequence for encoding "UTF8": 0xe92527 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Code | Context
            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);
$sql	=	""
$error	=	"ERROR:  invalid byte sequence for encoding "UTF8": 0xe92527"
$out	=	null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
SearchController::free() - APP/controllers/search_controller.php, line 225
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Query: SELECT COUNT(*) AS "count" FROM "tbl_schools" AS "School"   WHERE ((((((school_name like '%æ™®é%' ) OR (school_desc like '%æ™®é%' ) OR (recommendation like '%æ™®é%' ) OR (campaign_desc like '%æ™®é%' ) OR (camp_standard_1_desc like '%æ™®é%' ) OR (camp_standard_2_desc like '%æ™®é%' ) OR (camp_standard_3_desc like '%æ™®é%' ) OR (camp_standard_4_desc like '%æ™®é%' ) OR (camp_standard_5_desc like '%æ™®é%' ) OR (camp_bike_1_desc like '%æ™®é%' ) OR (camp_bike_2_desc like '%æ™®é%' ) OR (camp_bike_3_desc like '%æ™®é%' ) OR (camp_bike_4_desc like '%æ™®é%' ) OR (camp_bike_5_desc like '%æ™®é%' ) OR (comparison_direct_1 like '%æ™®é%' ) OR (comparison_direct_2 like '%æ™®é%' ) OR (comparison_direct_3 like '%æ™®é%' ) OR (comparison_direct_4 like '%æ™®é%' ) OR (comparison_direct_5 like '%æ™®é%' ) OR (comment_from_staff like '%æ™®é%' ) OR (word_mouth like '%æ™®é%' ) OR (nearest_station like '%æ™®é%' ) OR (access_desc like '%æ™®é%' ) OR (region like '%æ™®é%' ) OR (prefecture like '%æ™®é%' ) OR (town like '%æ™®é%' ) OR (address like '%æ™®é%' ) OR (bus_route_name_1 like '%æ™®é%' ) OR (bus_route_name_2 like '%æ™®é%' ) OR (bus_route_name_3 like '%æ™®é%' ) OR (bus_route_name_4 like '%æ™®é%' ) OR (bus_route_name_5 like '%æ™®é%' ) OR (bus_route_name_6 like '%æ™®é%' ) OR (bus_route_name_7 like '%æ™®é%' ) OR (bus_route_name_8 like '%æ™®é%' ) OR (bus_route_name_9 like '%æ™®é%' ) OR (bus_route_name_10 like '%æ™®é%' ) OR (bus_route_1 like '%æ™®é%' ) OR (bus_route_2 like '%æ™®é%' ) OR (bus_route_3 like '%æ™®é%' ) OR (bus_route_4 like '%æ™®é%' ) OR (bus_route_5 like '%æ™®é%' ) OR (bus_route_6 like '%æ™®é%' ) OR (bus_route_7 like '%æ™®é%' ) OR (bus_route_8 like '%æ™®é%' ) OR (bus_route_9 like '%æ™®é%' ) OR (bus_route_10 like '%æ™®é%' ) OR (teach_time like '%æ™®é%' ) OR (teach_time_weekday like '%æ™®é%' ) OR (apply_car like '%æ™®é%' ) OR (apply_bike like '%æ™®é%' ) OR (apply_addition like '%æ™®é%' ) OR (enter_time like '%æ™®é%' ) OR (enter_ceremony like '%æ™®é%' ) OR (nursery_time like '%æ™®é%' ) OR (nursery_use like '%æ™®é%' ) OR (nursery_age like '%æ™®é%' ) OR (nursery_cant like '%æ™®é%' )))  AND  ("publish_flag" = '1'))) AND (((((school_name like '%šè»Š%' ) OR (school_desc like '%šè»Š%' ) OR (recommendation like '%šè»Š%' ) OR (campaign_desc like '%šè»Š%' ) OR (camp_standard_1_desc like '%šè»Š%' ) OR (camp_standard_2_desc like '%šè»Š%' ) OR (camp_standard_3_desc like '%šè»Š%' ) OR (camp_standard_4_desc like '%šè»Š%' ) OR (camp_standard_5_desc like '%šè»Š%' ) OR (camp_bike_1_desc like '%šè»Š%' ) OR (camp_bike_2_desc like '%šè»Š%' ) OR (camp_bike_3_desc like '%šè»Š%' ) OR (camp_bike_4_desc like '%šè»Š%' ) OR (camp_bike_5_desc like '%šè»Š%' ) OR (comparison_direct_1 like '%šè»Š%' ) OR (comparison_direct_2 like '%šè»Š%' ) OR (comparison_direct_3 like '%šè»Š%' ) OR (comparison_direct_4 like '%šè»Š%' ) OR (comparison_direct_5 like '%šè»Š%' ) OR (comment_from_staff like '%šè»Š%' ) OR (word_mouth like '%šè»Š%' ) OR (nearest_station like '%šè»Š%' ) OR (access_desc like '%šè»Š%' ) OR (region like '%šè»Š%' ) OR (prefecture like '%šè»Š%' ) OR (town like '%šè»Š%' ) OR (address like '%šè»Š%' ) OR (bus_route_name_1 like '%šè»Š%' ) OR (bus_route_name_2 like '%šè»Š%' ) OR (bus_route_name_3 like '%šè»Š%' ) OR (bus_route_name_4 like '%šè»Š%' ) OR (bus_route_name_5 like '%šè»Š%' ) OR (bus_route_name_6 like '%šè»Š%' ) OR (bus_route_name_7 like '%šè»Š%' ) OR (bus_route_name_8 like '%šè»Š%' ) OR (bus_route_name_9 like '%šè»Š%' ) OR (bus_route_name_10 like '%šè»Š%' ) OR (bus_route_1 like '%šè»Š%' ) OR (bus_route_2 like '%šè»Š%' ) OR (bus_route_3 like '%šè»Š%' ) OR (bus_route_4 like '%šè»Š%' ) OR (bus_route_5 like '%šè»Š%' ) OR (bus_route_6 like '%šè»Š%' ) OR (bus_route_7 like '%šè»Š%' ) OR (bus_route_8 like '%šè»Š%' ) OR (bus_route_9 like '%šè»Š%' ) OR (bus_route_10 like '%šè»Š%' ) OR (teach_time like '%šè»Š%' ) OR (teach_time_weekday like '%šè»Š%' ) OR (apply_car like '%šè»Š%' ) OR (apply_bike like '%šè»Š%' ) OR (apply_addition like '%šè»Š%' ) OR (enter_time like '%šè»Š%' ) OR (enter_ceremony like '%šè»Š%' ) OR (nursery_time like '%šè»Š%' ) OR (nursery_use like '%šè»Š%' ) OR (nursery_age like '%šè»Š%' ) OR (nursery_cant like '%šè»Š%' )))  AND  ("publish_flag" = '1'))))    

Query: SELECT COUNT(*) AS "count" FROM "tbl_schools" AS "School"   WHERE ((((((school_name like '%æ™®é%' ) OR (school_desc like '%æ™®é%' ) OR (recommendation like '%æ™®é%' ) OR (campaign_desc like '%æ™®é%' ) OR (camp_standard_1_desc like '%æ™®é%' ) OR (camp_standard_2_desc like '%æ™®é%' ) OR (camp_standard_3_desc like '%æ™®é%' ) OR (camp_standard_4_desc like '%æ™®é%' ) OR (camp_standard_5_desc like '%æ™®é%' ) OR (camp_bike_1_desc like '%æ™®é%' ) OR (camp_bike_2_desc like '%æ™®é%' ) OR (camp_bike_3_desc like '%æ™®é%' ) OR (camp_bike_4_desc like '%æ™®é%' ) OR (camp_bike_5_desc like '%æ™®é%' ) OR (comparison_direct_1 like '%æ™®é%' ) OR (comparison_direct_2 like '%æ™®é%' ) OR (comparison_direct_3 like '%æ™®é%' ) OR (comparison_direct_4 like '%æ™®é%' ) OR (comparison_direct_5 like '%æ™®é%' ) OR (comment_from_staff like '%æ™®é%' ) OR (word_mouth like '%æ™®é%' ) OR (nearest_station like '%æ™®é%' ) OR (access_desc like '%æ™®é%' ) OR (region like '%æ™®é%' ) OR (prefecture like '%æ™®é%' ) OR (town like '%æ™®é%' ) OR (address like '%æ™®é%' ) OR (bus_route_name_1 like '%æ™®é%' ) OR (bus_route_name_2 like '%æ™®é%' ) OR (bus_route_name_3 like '%æ™®é%' ) OR (bus_route_name_4 like '%æ™®é%' ) OR (bus_route_name_5 like '%æ™®é%' ) OR (bus_route_name_6 like '%æ™®é%' ) OR (bus_route_name_7 like '%æ™®é%' ) OR (bus_route_name_8 like '%æ™®é%' ) OR (bus_route_name_9 like '%æ™®é%' ) OR (bus_route_name_10 like '%æ™®é%' ) OR (bus_route_1 like '%æ™®é%' ) OR (bus_route_2 like '%æ™®é%' ) OR (bus_route_3 like '%æ™®é%' ) OR (bus_route_4 like '%æ™®é%' ) OR (bus_route_5 like '%æ™®é%' ) OR (bus_route_6 like '%æ™®é%' ) OR (bus_route_7 like '%æ™®é%' ) OR (bus_route_8 like '%æ™®é%' ) OR (bus_route_9 like '%æ™®é%' ) OR (bus_route_10 like '%æ™®é%' ) OR (teach_time like '%æ™®é%' ) OR (teach_time_weekday like '%æ™®é%' ) OR (apply_car like '%æ™®é%' ) OR (apply_bike like '%æ™®é%' ) OR (apply_addition like '%æ™®é%' ) OR (enter_time like '%æ™®é%' ) OR (enter_ceremony like '%æ™®é%' ) OR (nursery_time like '%æ™®é%' ) OR (nursery_use like '%æ™®é%' ) OR (nursery_age like '%æ™®é%' ) OR (nursery_cant like '%æ™®é%' )))  AND  ("publish_flag" = '1'))) AND (((((school_name like '%šè»Š%' ) OR (school_desc like '%šè»Š%' ) OR (recommendation like '%šè»Š%' ) OR (campaign_desc like '%šè»Š%' ) OR (camp_standard_1_desc like '%šè»Š%' ) OR (camp_standard_2_desc like '%šè»Š%' ) OR (camp_standard_3_desc like '%šè»Š%' ) OR (camp_standard_4_desc like '%šè»Š%' ) OR (camp_standard_5_desc like '%šè»Š%' ) OR (camp_bike_1_desc like '%šè»Š%' ) OR (camp_bike_2_desc like '%šè»Š%' ) OR (camp_bike_3_desc like '%šè»Š%' ) OR (camp_bike_4_desc like '%šè»Š%' ) OR (camp_bike_5_desc like '%šè»Š%' ) OR (comparison_direct_1 like '%šè»Š%' ) OR (comparison_direct_2 like '%šè»Š%' ) OR (comparison_direct_3 like '%šè»Š%' ) OR (comparison_direct_4 like '%šè»Š%' ) OR (comparison_direct_5 like '%šè»Š%' ) OR (comment_from_staff like '%šè»Š%' ) OR (word_mouth like '%šè»Š%' ) OR (nearest_station like '%šè»Š%' ) OR (access_desc like '%šè»Š%' ) OR (region like '%šè»Š%' ) OR (prefecture like '%šè»Š%' ) OR (town like '%šè»Š%' ) OR (address like '%šè»Š%' ) OR (bus_route_name_1 like '%šè»Š%' ) OR (bus_route_name_2 like '%šè»Š%' ) OR (bus_route_name_3 like '%šè»Š%' ) OR (bus_route_name_4 like '%šè»Š%' ) OR (bus_route_name_5 like '%šè»Š%' ) OR (bus_route_name_6 like '%šè»Š%' ) OR (bus_route_name_7 like '%šè»Š%' ) OR (bus_route_name_8 like '%šè»Š%' ) OR (bus_route_name_9 like '%šè»Š%' ) OR (bus_route_name_10 like '%šè»Š%' ) OR (bus_route_1 like '%šè»Š%' ) OR (bus_route_2 like '%šè»Š%' ) OR (bus_route_3 like '%šè»Š%' ) OR (bus_route_4 like '%šè»Š%' ) OR (bus_route_5 like '%šè»Š%' ) OR (bus_route_6 like '%šè»Š%' ) OR (bus_route_7 like '%šè»Š%' ) OR (bus_route_8 like '%šè»Š%' ) OR (bus_route_9 like '%šè»Š%' ) OR (bus_route_10 like '%šè»Š%' ) OR (teach_time like '%šè»Š%' ) OR (teach_time_weekday like '%šè»Š%' ) OR (apply_car like '%šè»Š%' ) OR (apply_bike like '%šè»Š%' ) OR (apply_addition like '%šè»Š%' ) OR (enter_time like '%šè»Š%' ) OR (enter_ceremony like '%šè»Š%' ) OR (nursery_time like '%šè»Š%' ) OR (nursery_use like '%šè»Š%' ) OR (nursery_age like '%šè»Š%' ) OR (nursery_cant like '%šè»Š%' )))  AND  ("publish_flag" = '1'))))    

Query: SELECT "School"."school_id" AS "School__school_id", "School"."school_name" AS "School__school_name", "School"."school_code" AS "School__school_code", "School"."school_desc" AS "School__school_desc", "School"."recommendation" AS "School__recommendation", "School"."school_img_01" AS "School__school_img_01", "School"."school_img_02" AS "School__school_img_02", "School"."school_img_03" AS "School__school_img_03", "School"."license_cat" AS "School__license_cat", "School"."campaign_desc" AS "School__campaign_desc", "School"."camp_standard_1_desc" AS "School__camp_standard_1_desc", "School"."camp_standard_2_desc" AS "School__camp_standard_2_desc", "School"."camp_standard_3_desc" AS "School__camp_standard_3_desc", "School"."camp_standard_4_desc" AS "School__camp_standard_4_desc", "School"."camp_standard_5_desc" AS "School__camp_standard_5_desc", "School"."camp_bike_1_desc" AS "School__camp_bike_1_desc", "School"."camp_bike_2_desc" AS "School__camp_bike_2_desc", "School"."camp_bike_3_desc" AS "School__camp_bike_3_desc", "School"."camp_bike_4_desc" AS "School__camp_bike_4_desc", "School"."camp_bike_5_desc" AS "School__camp_bike_5_desc", "School"."speed_resv" AS "School__speed_resv", "School"."basic_exist" AS "School__basic_exist", "School"."shortest_day" AS "School__shortest_day", "School"."comparison_direct_1" AS "School__comparison_direct_1", "School"."comparison_direct_2" AS "School__comparison_direct_2", "School"."comparison_direct_3" AS "School__comparison_direct_3", "School"."comparison_direct_4" AS "School__comparison_direct_4", "School"."comparison_direct_5" AS "School__comparison_direct_5", "School"."comment_from_staff_img" AS "School__comment_from_staff_img", "School"."comment_from_staff" AS "School__comment_from_staff", "School"."word_mouth_img" AS "School__word_mouth_img", "School"."word_mouth" AS "School__word_mouth", "School"."days_off" AS "School__days_off", "School"."nearest_station" AS "School__nearest_station", "School"."access_desc" AS "School__access_desc", "School"."region" AS "School__region", "School"."prefecture" AS "School__prefecture", "School"."town" AS "School__town", "School"."address" AS "School__address", "School"."bus_route_name_1" AS "School__bus_route_name_1", "School"."bus_route_1" AS "School__bus_route_1", "School"."bus_route_name_2" AS "School__bus_route_name_2", "School"."bus_route_2" AS "School__bus_route_2", "School"."bus_route_name_3" AS "School__bus_route_name_3", "School"."bus_route_3" AS "School__bus_route_3", "School"."bus_route_name_4" AS "School__bus_route_name_4", "School"."bus_route_4" AS "School__bus_route_4", "School"."bus_route_name_5" AS "School__bus_route_name_5", "School"."bus_route_5" AS "School__bus_route_5", "School"."bus_route_name_6" AS "School__bus_route_name_6", "School"."bus_route_6" AS "School__bus_route_6", "School"."bus_route_name_7" AS "School__bus_route_name_7", "School"."bus_route_7" AS "School__bus_route_7", "School"."bus_route_name_8" AS "School__bus_route_name_8", "School"."bus_route_8" AS "School__bus_route_8", "School"."bus_route_name_9" AS "School__bus_route_name_9", "School"."bus_route_9" AS "School__bus_route_9", "School"."bus_route_name_10" AS "School__bus_route_name_10", "School"."bus_route_10" AS "School__bus_route_10", "School"."teach_time" AS "School__teach_time", "School"."teach_time_weekday" AS "School__teach_time_weekday", "School"."apply_car" AS "School__apply_car", "School"."apply_bike" AS "School__apply_bike", "School"."apply_addition" AS "School__apply_addition", "School"."enter_time" AS "School__enter_time", "School"."enter_ceremony" AS "School__enter_ceremony", "School"."nursery_time" AS "School__nursery_time", "School"."nursery_use" AS "School__nursery_use", "School"."nursery_age" AS "School__nursery_age", "School"."nursery_cant" AS "School__nursery_cant", "School"."eq_parking_car" AS "School__eq_parking_car", "School"."eq_parking_bike" AS "School__eq_parking_bike", "School"."eq_smoking_room" AS "School__eq_smoking_room", "School"."eq_dressing_room" AS "School__eq_dressing_room", "School"."eq_dining_room" AS "School__eq_dining_room", "School"."resv_tel" AS "School__resv_tel", "School"."resv_net" AS "School__resv_net", "School"."resv_cellphone" AS "School__resv_cellphone", "School"."resv_counter" AS "School__resv_counter", "School"."nomination_flag" AS "School__nomination_flag", "School"."lend_helmet" AS "School__lend_helmet", "School"."lend_globe" AS "School__lend_globe", "School"."lend_boots" AS "School__lend_boots", "School"."lend_coat" AS "School__lend_coat", "School"."publish_flag" AS "School__publish_flag", "School"."created" AS "School__created", "School"."modified" AS "School__modified", "School"."school_img" AS "School__school_img" FROM "tbl_schools" AS "School"   WHERE ((((((school_name like '%æ™®é%' ) OR (school_desc like '%æ™®é%' ) OR (recommendation like '%æ™®é%' ) OR (campaign_desc like '%æ™®é%' ) OR (camp_standard_1_desc like '%æ™®é%' ) OR (camp_standard_2_desc like '%æ™®é%' ) OR (camp_standard_3_desc like '%æ™®é%' ) OR (camp_standard_4_desc like '%æ™®é%' ) OR (camp_standard_5_desc like '%æ™®é%' ) OR (camp_bike_1_desc like '%æ™®é%' ) OR (camp_bike_2_desc like '%æ™®é%' ) OR (camp_bike_3_desc like '%æ™®é%' ) OR (camp_bike_4_desc like '%æ™®é%' ) OR (camp_bike_5_desc like '%æ™®é%' ) OR (comparison_direct_1 like '%æ™®é%' ) OR (comparison_direct_2 like '%æ™®é%' ) OR (comparison_direct_3 like '%æ™®é%' ) OR (comparison_direct_4 like '%æ™®é%' ) OR (comparison_direct_5 like '%æ™®é%' ) OR (comment_from_staff like '%æ™®é%' ) OR (word_mouth like '%æ™®é%' ) OR (nearest_station like '%æ™®é%' ) OR (access_desc like '%æ™®é%' ) OR (region like '%æ™®é%' ) OR (prefecture like '%æ™®é%' ) OR (town like '%æ™®é%' ) OR (address like '%æ™®é%' ) OR (bus_route_name_1 like '%æ™®é%' ) OR (bus_route_name_2 like '%æ™®é%' ) OR (bus_route_name_3 like '%æ™®é%' ) OR (bus_route_name_4 like '%æ™®é%' ) OR (bus_route_name_5 like '%æ™®é%' ) OR (bus_route_name_6 like '%æ™®é%' ) OR (bus_route_name_7 like '%æ™®é%' ) OR (bus_route_name_8 like '%æ™®é%' ) OR (bus_route_name_9 like '%æ™®é%' ) OR (bus_route_name_10 like '%æ™®é%' ) OR (bus_route_1 like '%æ™®é%' ) OR (bus_route_2 like '%æ™®é%' ) OR (bus_route_3 like '%æ™®é%' ) OR (bus_route_4 like '%æ™®é%' ) OR (bus_route_5 like '%æ™®é%' ) OR (bus_route_6 like '%æ™®é%' ) OR (bus_route_7 like '%æ™®é%' ) OR (bus_route_8 like '%æ™®é%' ) OR (bus_route_9 like '%æ™®é%' ) OR (bus_route_10 like '%æ™®é%' ) OR (teach_time like '%æ™®é%' ) OR (teach_time_weekday like '%æ™®é%' ) OR (apply_car like '%æ™®é%' ) OR (apply_bike like '%æ™®é%' ) OR (apply_addition like '%æ™®é%' ) OR (enter_time like '%æ™®é%' ) OR (enter_ceremony like '%æ™®é%' ) OR (nursery_time like '%æ™®é%' ) OR (nursery_use like '%æ™®é%' ) OR (nursery_age like '%æ™®é%' ) OR (nursery_cant like '%æ™®é%' )))  AND  ("publish_flag" = '1'))) AND (((((school_name like '%šè»Š%' ) OR (school_desc like '%šè»Š%' ) OR (recommendation like '%šè»Š%' ) OR (campaign_desc like '%šè»Š%' ) OR (camp_standard_1_desc like '%šè»Š%' ) OR (camp_standard_2_desc like '%šè»Š%' ) OR (camp_standard_3_desc like '%šè»Š%' ) OR (camp_standard_4_desc like '%šè»Š%' ) OR (camp_standard_5_desc like '%šè»Š%' ) OR (camp_bike_1_desc like '%šè»Š%' ) OR (camp_bike_2_desc like '%šè»Š%' ) OR (camp_bike_3_desc like '%šè»Š%' ) OR (camp_bike_4_desc like '%šè»Š%' ) OR (camp_bike_5_desc like '%šè»Š%' ) OR (comparison_direct_1 like '%šè»Š%' ) OR (comparison_direct_2 like '%šè»Š%' ) OR (comparison_direct_3 like '%šè»Š%' ) OR (comparison_direct_4 like '%šè»Š%' ) OR (comparison_direct_5 like '%šè»Š%' ) OR (comment_from_staff like '%šè»Š%' ) OR (word_mouth like '%šè»Š%' ) OR (nearest_station like '%šè»Š%' ) OR (access_desc like '%šè»Š%' ) OR (region like '%šè»Š%' ) OR (prefecture like '%šè»Š%' ) OR (town like '%šè»Š%' ) OR (address like '%šè»Š%' ) OR (bus_route_name_1 like '%šè»Š%' ) OR (bus_route_name_2 like '%šè»Š%' ) OR (bus_route_name_3 like '%šè»Š%' ) OR (bus_route_name_4 like '%šè»Š%' ) OR (bus_route_name_5 like '%šè»Š%' ) OR (bus_route_name_6 like '%šè»Š%' ) OR (bus_route_name_7 like '%šè»Š%' ) OR (bus_route_name_8 like '%šè»Š%' ) OR (bus_route_name_9 like '%šè»Š%' ) OR (bus_route_name_10 like '%šè»Š%' ) OR (bus_route_1 like '%šè»Š%' ) OR (bus_route_2 like '%šè»Š%' ) OR (bus_route_3 like '%šè»Š%' ) OR (bus_route_4 like '%šè»Š%' ) OR (bus_route_5 like '%šè»Š%' ) OR (bus_route_6 like '%šè»Š%' ) OR (bus_route_7 like '%šè»Š%' ) OR (bus_route_8 like '%šè»Š%' ) OR (bus_route_9 like '%šè»Š%' ) OR (bus_route_10 like '%šè»Š%' ) OR (teach_time like '%šè»Š%' ) OR (teach_time_weekday like '%šè»Š%' ) OR (apply_car like '%šè»Š%' ) OR (apply_bike like '%šè»Š%' ) OR (apply_addition like '%šè»Š%' ) OR (enter_time like '%šè»Š%' ) OR (enter_ceremony like '%šè»Š%' ) OR (nursery_time like '%šè»Š%' ) OR (nursery_use like '%šè»Š%' ) OR (nursery_age like '%šè»Š%' ) OR (nursery_cant like '%šè»Š%' )))  AND  ("publish_flag" = '1'))))   ORDER BY "School"."school_id" desc  LIMIT 10