Time : 23:57:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0945628)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.2803956)) + SIN(RADIANS(13.0945628)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,88357) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 21:51:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.088385785040845)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.24956351238613)) + SIN(RADIANS(13.088385785040845)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,88357) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 21:35:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.088385785040845)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.24956351238613)) + SIN(RADIANS(13.088385785040845)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,88357) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 18:10:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.8906038)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.616637)) + SIN(RADIANS(12.8906038)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,111337,67895) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 18:08:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.2831858)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.954662)) + SIN(RADIANS(19.2831858)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,111337,67895) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 18:06:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.8906038)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.616637)) + SIN(RADIANS(12.8906038)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,111337,67895) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:45:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6146243)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.3121575)) + SIN(RADIANS(28.6146243)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111337) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:42:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4356755)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.4527817)) + SIN(RADIANS(17.4356755)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111337) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:35:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0362703)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.841487)) + SIN(RADIANS(19.0362703)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,111337) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:32:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6810525)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.2793226)) + SIN(RADIANS(28.6810525)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:31:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4356755)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.4527817)) + SIN(RADIANS(17.4356755)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:26:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4356755)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.4527817)) + SIN(RADIANS(17.4356755)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 17:05:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4356755)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.4527817)) + SIN(RADIANS(17.4356755)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 16:17:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.5885984)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.0504225)) + SIN(RADIANS(28.5885984)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 16:00:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.4968291)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.4410417)) + SIN(RADIANS(28.4968291)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:29:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.189444)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8451432)) + SIN(RADIANS(19.189444)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:25:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1803961)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8591191)) + SIN(RADIANS(19.1803961)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:18:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0366478)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.58998520000002)) + SIN(RADIANS(13.0366478)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,79843,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:17:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6146243)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.3121575)) + SIN(RADIANS(28.6146243)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,79843,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:16:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.964161)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.53694039999999)) + SIN(RADIANS(12.964161)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,79843,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:13:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0190171)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.7183676)) + SIN(RADIANS(13.0190171)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,79843,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:06:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0208379)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.1491346)) + SIN(RADIANS(13.0208379)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,79843,111632,114900) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 15:00:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.175513246371402)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.95256220387284)) + SIN(RADIANS(19.175513246371402)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:58:04 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1176287)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.908491)) + SIN(RADIANS(19.1176287)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:56:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9654421)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6604859)) + SIN(RADIANS(12.9654421)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:53:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0190171)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.7183676)) + SIN(RADIANS(13.0190171)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:50:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0208379)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.1491346)) + SIN(RADIANS(13.0208379)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:49:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0134133)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5957272)) + SIN(RADIANS(13.0134133)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,79843,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:45:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1803961)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8591191)) + SIN(RADIANS(19.1803961)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,111632) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:33:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9657475)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5789635)) + SIN(RADIANS(12.9657475)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:29:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0061359)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.84483689999999)) + SIN(RADIANS(19.0061359)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:09:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.6065765)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.377613)) + SIN(RADIANS(22.6065765)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:06:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9317558)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5458269)) + SIN(RADIANS(12.9317558)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:02:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.2831858)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.954662)) + SIN(RADIANS(19.2831858)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 14:01:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.5885984)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.0504225)) + SIN(RADIANS(28.5885984)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:59:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.053153)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.62771459999999)) + SIN(RADIANS(13.053153)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:55:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0247291)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5947532)) + SIN(RADIANS(13.0247291)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,52434,31485) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:40:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9317558)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5458269)) + SIN(RADIANS(12.9317558)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111632,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:34:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0415411)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5479639)) + SIN(RADIANS(13.0415411)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111632,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:28:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.015286)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6495469)) + SIN(RADIANS(13.015286)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111632,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:24:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.4137954)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(76.9309808)) + SIN(RADIANS(28.4137954)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111632,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:09:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0134133)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5957272)) + SIN(RADIANS(13.0134133)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,0,0,0,111632,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:05:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9317558)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5458269)) + SIN(RADIANS(12.9317558)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,0,0,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:03:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(23.0555518)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.5505761)) + SIN(RADIANS(23.0555518)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,0,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:02:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0264375)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5377585)) + SIN(RADIANS(13.0264375)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,0,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 13:01:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(23.0555518)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.5505761)) + SIN(RADIANS(23.0555518)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:59:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.8329644)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6734384)) + SIN(RADIANS(12.8329644)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (85434) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,111869,52434) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:57:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0520876)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0143318)) + SIN(RADIANS(19.0520876)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:49:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6591733)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.2813712)) + SIN(RADIANS(28.6591733)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:47:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.964161)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.53694039999999)) + SIN(RADIANS(12.964161)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:35:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0036447)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.259511)) + SIN(RADIANS(13.0036447)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:34:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.104689)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8514013)) + SIN(RADIANS(19.104689)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:31:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9317558)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5458269)) + SIN(RADIANS(12.9317558)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,111869) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 12:05:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.964161)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.53694039999999)) + SIN(RADIANS(12.964161)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,18649) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 11:50:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0129127)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.7167074)) + SIN(RADIANS(13.0129127)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,18649,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 11:38:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.964161)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.53694039999999)) + SIN(RADIANS(12.964161)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,18649,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 11:19:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6864984)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.1375303)) + SIN(RADIANS(28.6864984)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,18649,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 11:18:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.97331)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6651976)) + SIN(RADIANS(12.97331)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,18649,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 11:09:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0648786)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.58719459999999)) + SIN(RADIANS(13.0648786)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:56:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.5892766)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.42349949999999)) + SIN(RADIANS(22.5892766)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:55:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0648786)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.58719459999999)) + SIN(RADIANS(13.0648786)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0,74345) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:51:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.033388049541019)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.63009046623337)) + SIN(RADIANS(13.033388049541019)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:45:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.2323939)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.9905998)) + SIN(RADIANS(19.2323939)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:33:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(31.1075588)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.1959622)) + SIN(RADIANS(31.1075588)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 10:30:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9213959)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5492141)) + SIN(RADIANS(12.9213959)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:56:08 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.4867635)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3396083)) + SIN(RADIANS(22.4867635)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:46:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.5140502)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3662462)) + SIN(RADIANS(22.5140502)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:35:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0382443)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6015195)) + SIN(RADIANS(13.0382443)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:30:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.4530945)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3183288)) + SIN(RADIANS(22.4530945)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:29:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0726741)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5346748)) + SIN(RADIANS(13.0726741)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:28:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0520876)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0143318)) + SIN(RADIANS(19.0520876)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:24:04 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0609031)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6235051)) + SIN(RADIANS(13.0609031)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:17:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0726741)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5346748)) + SIN(RADIANS(13.0726741)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:14:04 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.4530945)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3183288)) + SIN(RADIANS(22.4530945)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:13:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0520876)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0143318)) + SIN(RADIANS(19.0520876)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 09:12:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0726741)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5346748)) + SIN(RADIANS(13.0726741)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 08:15:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.4867635)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3396083)) + SIN(RADIANS(22.4867635)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 08:09:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0543422)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.2204544)) + SIN(RADIANS(13.0543422)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 07:57:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.4867635)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3396083)) + SIN(RADIANS(22.4867635)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 07:56:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9902642)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6560111)) + SIN(RADIANS(12.9902642)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 07:22:02 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.3420317)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.3883942)) + SIN(RADIANS(17.3420317)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 07:11:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9941061)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.7287551)) + SIN(RADIANS(12.9941061)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 07:01:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9902642)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6560111)) + SIN(RADIANS(12.9902642)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500 Time : 05:30:04 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.5945707)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.0335188)) + SIN(RADIANS(28.5945707)) * SIN(RADIANS(latitude)) )) AS distance from rt_service_providers where status = 1 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) OR sub_category_id = '5' and id NOT IN (0,0,0) and (FIND_IN_SET(1, category_id) OR FIND_IN_SET(1, h.category_id) OR FIND_IN_SET(20, category_id) OR FIND_IN_SET(8, category_id) OR FIND_IN_SET(17, category_id) OR FIND_IN_SET(2, category_id) ) and deactivate_account = 0 and latitude IS NOT NULL and longitude IS NOT NULL and category_id <> '' and last_seen IS NOT NULL HAVING distance <= 20 ORDER BY last_seen DESC LIMIT 500