Time : 21:10:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0333373)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0104256)) + SIN(RADIANS(19.0333373)) * 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 : 20:24:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.083566)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.9126193)) + SIN(RADIANS(19.083566)) * 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 : 19:24:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.083566)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.9126193)) + SIN(RADIANS(19.083566)) * 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,106082,8083) 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:28:08 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0388214)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0714331)) + SIN(RADIANS(19.0388214)) * 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,120812) 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:17:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.5620218)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.2148931)) + SIN(RADIANS(28.5620218)) * 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,120812) 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:11:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.0388214)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(73.0714331)) + SIN(RADIANS(19.0388214)) * 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,120812) 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:50:10 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,120812) 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:49:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0741592)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5133647)) + SIN(RADIANS(13.0741592)) * 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,120812) 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:48:08 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,120812) 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:21:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.0741592)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.5133647)) + SIN(RADIANS(13.0741592)) * 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 : 15:53:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.5677418)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.2871816)) + SIN(RADIANS(28.5677418)) * 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 : 15:08:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.2155354)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8363816)) + SIN(RADIANS(19.2155354)) * 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 : 14:09:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1695439)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8679137)) + SIN(RADIANS(19.1695439)) * 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 : 13:25:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.037998285346866)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.19324419126949)) + SIN(RADIANS(13.037998285346866)) * 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 : 12:11:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.483602)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.3149299)) + SIN(RADIANS(17.483602)) * 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,76418) 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:02:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1361486)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8448517)) + SIN(RADIANS(19.1361486)) * 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,76418) 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:33:08 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6388146)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.3026963)) + SIN(RADIANS(28.6388146)) * 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 : 11:31:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(22.5072836)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(88.3719273)) + SIN(RADIANS(22.5072836)) * 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 : 11:17:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.1361486)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.8448517)) + SIN(RADIANS(19.1361486)) * 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 : 11:03:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6388146)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.3026963)) + SIN(RADIANS(28.6388146)) * 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 : 10:29:04 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.952042)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.1835512)) + SIN(RADIANS(12.952042)) * 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,120590) 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:22:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(31.1054179)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.1709246)) + SIN(RADIANS(31.1054179)) * 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,120590) 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:20:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(31.1054179)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.1709246)) + SIN(RADIANS(31.1054179)) * 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,120590) 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:36:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.037998285346866)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.19324419126949)) + SIN(RADIANS(13.037998285346866)) * 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,120590) 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:05:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.037998285346866)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.19324419126949)) + SIN(RADIANS(13.037998285346866)) * 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,120590) 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:56:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(13.037998285346866)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(80.19324419126949)) + SIN(RADIANS(13.037998285346866)) * 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:48:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.9281389)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6899377)) + SIN(RADIANS(12.9281389)) * 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 : 07:28:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4787873)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.5637044)) + SIN(RADIANS(17.4787873)) * 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:21:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(19.067272)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(72.9892376)) + SIN(RADIANS(19.067272)) * 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:12:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4787873)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.5637044)) + SIN(RADIANS(17.4787873)) * 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 : 06:26:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4787873)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.5637044)) + SIN(RADIANS(17.4787873)) * 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 : 06:25:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(12.8753846)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.6580733)) + SIN(RADIANS(12.8753846)) * 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 : 06:10:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(17.4787873)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(78.5637044)) + SIN(RADIANS(17.4787873)) * 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 : 00:00:07 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.category_id' in 'where clause' Raw SQL : SELECT *, (6371 * ACOS( COS(RADIANS(28.6499455)) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(77.4742177)) + SIN(RADIANS(28.6499455)) * 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