Time : 14:11:07 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 's Surya Flats, Plot no:67, TVS Nagar 1st Main Road, Vallalar St, TVS Nagar, Kora' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7305119601','0','Cooking','2','','Female','2024-03-14 14:11:07','1A,Ken's Surya Flats, Plot no:67, TVS Nagar 1st Main Road, Vallalar St, TVS Nagar, Korattur, Chennai, Tamil Nadu 600076, India','4.0') Time : 14:04:25 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 's Surya Flats, Plot no:67, TVS Nagar 1st Main Road, Vallalar St, TVS Nagar, Kora' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7305119601','0','Cooking','2','','Female','2024-03-14 14:04:25','1A,Ken's Surya Flats, Plot no:67, TVS Nagar 1st Main Road, Vallalar St, TVS Nagar, Korattur, Chennai, Tamil Nadu 600076, India','4.0') Time : 19:00:29 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 ') and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LI' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(18.969539)) * cos(radians(latitude)) * cos(radians(longitude) - radians(72.819329)) + sin (radians(18.969539)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN () and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LIKE '%1%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 19:00: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 ') and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LI' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(18.969539)) * cos(radians(latitude)) * cos(radians(longitude) - radians(72.819329)) + sin (radians(18.969539)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN () and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LIKE '%1%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 19:00:16 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 ') and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LI' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(18.969539)) * cos(radians(latitude)) * cos(radians(longitude) - radians(72.819329)) + sin (radians(18.969539)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id NOT IN () and booking_on_the_go='yes' and food_type_id LIKE '%4%' and sub_category_id LIKE '%1%' and category_id LIKE '%1%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 13:11:31 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.7138188)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8445478)) + sin (radians(30.7138188)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id IN (Array) and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 13:09:35 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.7138188)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8445478)) + sin (radians(30.7138188)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id != Array and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 13:03:18 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 'and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 13:02: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 'and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id != and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 13:02:19 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 'and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where id != and FIND_IN_SET(6, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 11:12:58 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 'Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bag' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9900222566','0','Cleaning','2','','male','2024-03-14 11:12:58','G2' Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bagh Layout, Bengaluru, Karnataka 560017, India','4.0') Time : 11:07:54 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 'Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bag' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9900222566','0','Cleaning','2','','Female','2024-03-14 11:07:54','G2' Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bagh Layout, Bengaluru, Karnataka 560017, India','4.0') Time : 11:07: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 'Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bag' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9900222566','0','Cleaning','2','','Female','2024-03-14 11:07:44','G2' Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bagh Layout, Bengaluru, Karnataka 560017, India','4.0') Time : 11:07: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 'Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bag' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9900222566','0','Cleaning','2','','Female','2024-03-14 11:07:03','G2' Ground floor ,Elegance Golf View Apartment, 5th Cross Rd, S R Layout, Rustam Bagh Layout, Bengaluru, Karnataka 560017, India','4.0') Time : 10:35: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 'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karn' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9980164786','0','Cleaning','3','','Female','2024-03-14 10:35:45','46 THE ADDRESS VIVIANI ROAD RICHARD'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karnataka 560005, India','4.0') Time : 10:32: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 'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karn' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9980164786','0','Cleaning','3','','Female','2024-03-14 10:32:50','46 THE ADDRESS VIVIANI ROAD RICHARD'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karnataka 560005, India','4.0') Time : 10:23:24 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 'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karn' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('9980164786','0','Cleaning','3','','Female','2024-03-14 10:23:24','46 THE ADDRESS VIVIANI ROAD RICHARD'S TOWN FLAT NO 303,46, Viviani Rd, Lazar Layout, Richards Town, Bengaluru, Karnataka 560005, India','4.0') Time : 09:22: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 's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full ti' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('8575911624','1','Cooking,Cleaning','5','','Female','2024-03-14 09:22:12','C/B 016, Rymbai Villa, Carmel Girl's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full time') Time : 09:10:15 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 's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full ti' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('8575911624','1','Cooking,Cleaning','5','','Female','2024-03-14 09:10:15','C/B 016, Rymbai Villa, Carmel Girl's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full time') Time : 08:59: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 ': 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number: 9849015616, new_user: 0, pswd: , customer_address: 9849015616, customer_area: , landmark: null, city: 40-9-43 B, near Benz Circle, Municipal Employees Colony, Acharya Ranga Nagar, Benz Circle, Vijayawad, state: 0, zip_code: null, latitude: 16.500676262616015, longitude: 80.65320701400749, status: 1, android_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, ios_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, created_at: 2024-01-13 10:54:24, updated_at: 2024-01-13 10:54:24} Time : 08:58:28 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 ': 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number: 9849015616, new_user: 0, pswd: , customer_address: 9849015616, customer_area: , landmark: null, city: 40-9-43 B, near Benz Circle, Municipal Employees Colony, Acharya Ranga Nagar, Benz Circle, Vijayawad, state: 0, zip_code: null, latitude: 16.500676262616015, longitude: 80.65320701400749, status: 1, android_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, ios_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, created_at: 2024-01-13 10:54:24, updated_at: 2024-01-13 10:54:24} Time : 07: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 ': 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number: 9849015616, new_user: 0, pswd: , customer_address: 9849015616, customer_area: , landmark: null, city: 40-9-43 B, near Benz Circle, Municipal Employees Colony, Acharya Ranga Nagar, Benz Circle, Vijayawad, state: 0, zip_code: null, latitude: 16.500676262616015, longitude: 80.65320701400749, status: 1, android_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, ios_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, created_at: 2024-01-13 10:54:24, updated_at: 2024-01-13 10:54:24} Time : 07:34:35 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 ': 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number: 9849015616, new_user: 0, pswd: , customer_address: 9849015616, customer_area: , landmark: null, city: 40-9-43 B, near Benz Circle, Municipal Employees Colony, Acharya Ranga Nagar, Benz Circle, Vijayawad, state: 0, zip_code: null, latitude: 16.500676262616015, longitude: 80.65320701400749, status: 1, android_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, ios_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, created_at: 2024-01-13 10:54:24, updated_at: 2024-01-13 10:54:24} Time : 07:34:27 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 ': 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10616, customer_name: Rajeswari k, email_addr: raj_di@yahoo.com, phone_number: 9849015616, new_user: 0, pswd: , customer_address: 9849015616, customer_area: , landmark: null, city: 40-9-43 B, near Benz Circle, Municipal Employees Colony, Acharya Ranga Nagar, Benz Circle, Vijayawad, state: 0, zip_code: null, latitude: 16.500676262616015, longitude: 80.65320701400749, status: 1, android_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, ios_device_id: el-RM7ByTkkrgVdxj3dN4m:APA91bFTcSACm8QXDECCID0lL71odo5qvyxk_AtFa9Km08_9nPGXcezo-x0aVmF3Kbs-0Tkh3DOE3QOYR6VM2aVKXBqaQJkifzMH1qAffg2nRE2eTQ26VgByLLf1qrUiZ_rWqEgHGv45, created_at: 2024-01-13 10:54:24, updated_at: 2024-01-13 10:54:24} Time : 05:13:55 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'FIND_IN_SET' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6861458)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449656)) + sin (radians(30.6861458)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where FIND_IN_SET(5,6,8, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 05:13:41 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'FIND_IN_SET' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where FIND_IN_SET(6,5,8, sub_category_id) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 05:11:28 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'your_column' in 'where clause' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where FIND_IN_SET(5, your_column) OR FIND_IN_SET(6, your_column) OR FIND_IN_SET(8, your_column) and hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 04:49:58 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 '[1,2,5,6,7,8,9,10])' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN ([1,2,5,6,7,8,9,10]) Time : 04:49:25 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 '[1,2,5,6,7,8,9,10])' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN ([1,2,5,6,7,8,9,10]) Time : 04:48: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 '[1,2,5,6,7,8,9,10])' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN ([1,2,5,6,7,8,9,10]) Time : 02:06:15 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','Female','2024-03-14 02:06:15','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time') Time : 01:54:01 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','Female','2024-03-14 01:54:01','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time') Time : 01:53:51 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','null','2024-03-14 01:53:51','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time') Time : 01:52:39 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','Female','2024-03-14 01:52:39','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time') Time : 01:51:38 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','Female','2024-03-14 01:51:38','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time') Time : 01:49:52 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 's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('7398950188','1','Cooking','3','','Female','2024-03-14 01:49:52','605,Bcc Residency, 5, Balmiki Marg, Kaiserbagh Officer's Colony, Qaisar Bagh, Lucknow, Uttar Pradesh 226001, India','Full time')