ID: 0
gültig bis:
08/19
WordPress-Datenbank-Fehler: [Incorrect parameter count in the call to native function 'radians']SELECT ID,
coalesce(nickname,name1) as name ,
ch.status,
name2,
street,
streetNo,
zip,
city,
classycardID,
cc.status,
cc.category as cat,
( 6371 * acos (
cos ( radians() )
* cos( radians( lat ) )
* cos( radians( lng ) - radians() )
+ sin ( radians() )
* sin( radians( lat ) )
)
)AS distance,
lat,
lng
FROM tbl_companies as comp
INNER JOIN tbl_companies_qultus_check ch
on ch.companyID = comp.ID
INNER JOIN tbl_classycard cc
on cc.companyID = comp.ID
WHERE comp.isActive = "true"
AND cc.isActive = "true"
AND ch.status not like "reject"
AND cc.isExpired like "false"
AND cc.category in ("classycard","angebot")
group by classycardID
HAVING distance < 50
ORDER BY cc.lastUpdate desc
LIMIT 3
WordPress-Datenbank-Fehler: [Incorrect parameter count in the call to native function 'radians']SELECT ID,
coalesce(nickname,name1) as name ,
ch.status,
name2,
street,
streetNo,
zip,
city,
classycardID,
cc.status,
cc.category as cat,
( 6371 * acos (
cos ( radians() )
* cos( radians( lat ) )
* cos( radians( lng ) - radians() )
+ sin ( radians() )
* sin( radians( lat ) )
)
)AS distance,
lat,
lng
FROM tbl_companies as comp
INNER JOIN tbl_companies_qultus_check ch
on ch.companyID = comp.ID
INNER JOIN tbl_classycard cc
on cc.companyID = comp.ID
WHERE comp.isActive = "true"
AND cc.isActive = "true"
AND ch.status not like "reject"
AND cc.isExpired like "false"
AND cc.category in ("classycard","angebot")
group by classycardID
HAVING distance < 50
ORDER BY cc.lastUpdate desc
LIMIT 3