Time : 21:00:03 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 '' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE status='1' AND city LIKE 'mumbai' ORDER BY last_seen DESC LIMIT Time : 15:00:04 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 '' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE status='1' AND city LIKE 'mumbai' ORDER BY last_seen DESC LIMIT Time : 14:00:03 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 '' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE status='1' AND city LIKE 'mumbai' ORDER BY last_seen DESC LIMIT Time : 13:00:04 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 '' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE status='1' AND city LIKE 'mumbai' ORDER BY last_seen DESC LIMIT Time : 11:48:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:47:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:46:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:45:08 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:45:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:44:45 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:44:44 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL AND id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:44:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:43:53 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:43:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:42:17 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:41:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:40:50 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:40:49 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:40:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:39:31 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:39:30 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:39:20 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:39:03 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:38:56 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:35:48 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:35:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:34:34 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:34:12 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:34:10 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:34:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:33:11 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:32:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:31:33 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,600 Time : 11:31:02 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,400' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,400 Time : 11:30:44 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 ') HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,400' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 0,400 Time : 11:30:14 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 ') HAVING distance <= ORDER BY last_seen DESC LIMIT 0,400' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (0) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= ORDER BY last_seen DESC LIMIT 0,400 Time : 11:27:12 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 ') HAVING distance <= ORDER BY last_seen DESC LIMIT 0,400' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (123) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= ORDER BY last_seen DESC LIMIT 0,400 Time : 11:13:11 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 ') HAVING distance <= 15 ORDER BY last_seen DESC LIMIT 0,400' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068503)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960553)) + sin (radians(31.1068503)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN (123) and food_type_id LIKE '%4%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and last_seen IS NOT NULL and id NOT IN () HAVING distance <= 15 ORDER BY last_seen DESC LIMIT 0,400 Time : 11:05:53 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 '== 500 and status='success' and type='credit' ORDER BY id DESC' at line 1 Raw SQL : SELECT * FROM rt_provider_wallet WHERE amount == 500 and status='success' and type='credit' ORDER BY id DESC Time : 11:01:56 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'all_data' in 'field list' Raw SQL : INSERT INTO rt_booking_on_the_go (user_id, provider_id,booking_app_id,booking_address,latitude,longitude,booking_status, gender, service_type, schedule_sub_category_id,hours_per_day, job_types, food_type, house_size, members, user_cost, provider_salary, user_rating,provider_rating,start_date, interview_time, end_date, customer_address,record_time,customer_token_id, customer_device_os, temp_provider_id,date_time,booking_date,schedule_date,schedule_time,mention_detail,type,otp,admin_commission,helper_admin_commission,user_admin_commission,send_noti,firebase_token,washroom,wardrobe,all_data) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 10:59:49 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 '== 500 and status='success' and type='credit' ORDER BY id DESC' at line 1 Raw SQL : SELECT * FROM rt_provider_wallet WHERE amount == 500 and status='success' and type='credit' ORDER BY id DESC