Résidence Mont-Bleu

QueryBuilder

SELECT t.*, u.relation FROM (SELECT r.*, 111.045 * DEGREES(ACOS(COS(RADIANS())
                                             * COS(RADIANS(r.lat))
                                             * COS(RADIANS(r.lng) - RADIANS())
                                             + SIN(RADIANS())
                                             * SIN(RADIANS(r.lat))))
                                             AS distance
                                            FROM residences r) AS t
                                            LEFT JOIN utilisateurs u ON u.res_id = t.id AND u.groupe = 4
                                            WHERE t.id IN (1251,2811,1163,1959,2625,1320,1632,2237,542,156,414,2786,555,2831,2089,1500,1449,3317,2257,2239,3048,3047,3065,2986,1931,3054,3441,820,2203,699,1751,1184,3353,2785,2154,146,2757,2842,2948,533,313,2837,1660,43,1748,1789,494,540,2118) AND u.relation !='' AND u.relation != 'Non-Client' AND t.distance < 100
                                            GROUP BY t.id
                                            ORDER BY t.distance ASC
                                            LIMIT 6

Incorrect parameter count in the call to native function 'RADIANS'