Time : 05:45:29
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'job_type' in 'where clause'
Raw SQL : SELECT *, (
                                111.111 * DEGREES(acos (
                                  cos ( radians(18.5610259) )
                                  * cos( radians( latitude ) )
                                  * cos( radians( longitude ) - radians(73.9118954) )
                                  + sin ( radians(18.5610259) )
                                  * sin( radians( latitude ) )
                                ))
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  job_type LIKE ? and (city = ? OR relocation='yes')

Time : 05:42:45
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (city = ? OR relocation='yes')' at line 9
Raw SQL : SELECT *, (
                                111.111 * DEGREES(acos (
                                  cos ( radians(18.5610259) )
                                  * cos( radians( latitude ) )
                                  * cos( radians( longitude ) - radians(73.9118954) )
                                  + sin ( radians(18.5610259) )
                                  * sin( radians( latitude ) )
                                ))
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  and (city = ? OR relocation='yes')

Time : 05:42:28
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (city = ? OR relocation='yes')' at line 9
Raw SQL : SELECT *, (
                                111.111 * DEGREES(acos (
                                  cos ( radians(18.5610259) )
                                  * cos( radians( latitude ) )
                                  * cos( radians( longitude ) - radians(73.9118954) )
                                  + sin ( radians(18.5610259) )
                                  * sin( radians( latitude ) )
                                ))
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  and (city = ? OR relocation='yes')

Time : 05:42:12
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (city = ? OR relocation='yes')' at line 9
Raw SQL : SELECT *, (
                                111.111 * DEGREES(acos (
                                  cos ( radians(18.5610259) )
                                  * cos( radians( latitude ) )
                                  * cos( radians( longitude ) - radians(73.9118954) )
                                  + sin ( radians(18.5610259) )
                                  * sin( radians( latitude ) )
                                ))
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  and (city = ? OR relocation='yes')

Time : 05:41:49
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (city = ? OR relocation='yes')' at line 9
Raw SQL : SELECT *, (
                                111.111 * DEGREES(acos (
                                  cos ( radians(18.5610259) )
                                  * cos( radians( latitude ) )
                                  * cos( radians( longitude ) - radians(73.9118954) )
                                  + sin ( radians(18.5610259) )
                                  * sin( radians( latitude ) )
                                ))
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  and (city = ? OR relocation='yes')

Time : 05:05:25
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'
Raw SQL : SELECT *, (
                                3959 * acos (
                                  cos ( radians(19.0124878) )
                                  * cos( radians( lat ) )
                                  * cos( radians( lng ) - radians(73.1543218) )
                                  + sin ( radians(19.0124878) )
                                  * sin( radians( lat ) )
                                )
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  (city = ? OR relocation='yes')

Time : 05:05:18
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'
Raw SQL : SELECT *, (
                                3959 * acos (
                                  cos ( radians(19.0124878) )
                                  * cos( radians( lat ) )
                                  * cos( radians( lng ) - radians(73.1543218) )
                                  + sin ( radians(19.0124878) )
                                  * sin( radians( lat ) )
                                )
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  (city = ? OR relocation='yes')

Time : 05:05:07
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'
Raw SQL : SELECT *, (
                                3959 * acos (
                                  cos ( radians(19.0124878) )
                                  * cos( radians( lat ) )
                                  * cos( radians( lng ) - radians(73.1543218) )
                                  + sin ( radians(19.0124878) )
                                  * sin( radians( lat ) )
                                )
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  (city = ? OR relocation='yes')

Time : 05:04:54
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'
Raw SQL : SELECT *, (
                                3959 * acos (
                                  cos ( radians(19.0124878) )
                                  * cos( radians( lat ) )
                                  * cos( radians( lng ) - radians(73.1543218) )
                                  + sin ( radians(19.0124878) )
                                  * sin( radians( lat ) )
                                )
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  (city = ? OR relocation='yes')

Time : 05:04:51
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'
Raw SQL : SELECT *, (
                                3959 * acos (
                                  cos ( radians(19.0124878) )
                                  * cos( radians( lat ) )
                                  * cos( radians( lng ) - radians(73.1543218) )
                                  + sin ( radians(19.0124878) )
                                  * sin( radians( lat ) )
                                )
                              ) AS distance from rt_service_providers where latitude <> '' and longitude <> '' and  (city = ? OR relocation='yes')