Aller au contenu
Database Error; SQL: SELECT
DISTINCT
`t`.*
FROM `wplki_posts` AS `t`
LEFT JOIN `wplki_postmeta` AS `latitude` ON
`latitude`.`meta_key` = 'latitude'
AND `latitude`.`post_id` = `t`.`ID`
LEFT JOIN `wplki_postmeta` AS `longitude` ON
`longitude`.`meta_key` = 'longitude'
AND `longitude`.`post_id` = `t`.`ID`
WHERE ( ( t.ID !=199 AND (ACOS( SIN( RADIANS( ) ) * SIN( RADIANS( `latitude`.`meta_value` ) ) + COS( RADIANS( ) ) * COS( RADIANS( `latitude`.`meta_value` ) ) * COS( RADIANS( `longitude`.`meta_value` ) - RADIANS( ) ) ) *6371) <= 15 ) AND ( `t`.`post_type` = 'programme' ) AND ( `t`.`post_status` IN ( 'publish' ) ) )
ORDER BY (ACOS( SIN( RADIANS( ) ) * SIN( RADIANS( `latitude`.`meta_value` ) ) + COS( RADIANS( ) ) * COS( RADIANS( `latitude`.`meta_value` ) ) * COS( RADIANS( `longitude`.`meta_value` ) - RADIANS( ) ) ) *6371), `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`
LIMIT 0, 3; Response: Incorrect parameter count in the call to native function 'RADIANS'