mysql - 无法使查询工作

Question

我这辈子都看不出这里出了什么问题。它很可能是愚蠢的东西，但我目前对此视而不见!我有一个问题:

SELECT 
Links.Title,
(6371 * acos( cos( radians(43.4347229) ) * cos( radians( Links.Latitude ) ) * cos( radians( Links.Longitude ) - radians(6.737222195) ) + sin( radians(43.4347229) ) * sin( radians( Links.Latitude ) ) ) AS distance 
FROM CatLinks,Links WHERE CatLinks.LinkID = Links.ID AND (Links.ID IN (16650,17190,153344) AND Links.isValidated = 'Yes' AND Links.PropertyType IN (1,2,3) AND Links.priceSort <= '9999' AND Links.PropertyType IN (1,2,3) AND Links.priceSort < '9999') ORDER BY distance LIMIT 0,50

..我得到一个错误:

Error: Could not execute query: Failed to execute query: 'SELECT Links.Title, (6371 * acos( cos( radians(43.4347229) ) * cos( radians( Links.Latitude ) ) * cos( radians( Links.Longitude ) - radians(6.737222195) ) + sin( radians(43.4347229) ) * sin( radians( Links.Latitude ) ) ) AS distance FROM CatLinks,Links WHERE CatLinks.LinkID = Links.ID AND (Links.ID IN (16650,17190,153344)) ORDER BY distance LIMIT 0,50': 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 'AS distance FROM CatLinks,Links WHERE CatLinks.LinkID =' at line 3

即使将其精简为更简单的查询，也无法正常工作:

SELECT 
    glinks_Links.Title,
    (6371 * acos( cos( radians(43.4347229) ) * cos( radians( glinks_Links.Latitude ) ) * cos( radians( glinks_Links.Longitude ) - radians(6.737222195) ) + sin( radians(43.4347229) ) * sin( radians( glinks_Links.Latitude ) ) ) AS distance 
    FROM glinks_CatLinks,glinks_Links ORDER BY distance LIMIT 0,50

我整个上午都在为这个问题四处奔波，所以任何建议都将不胜感激!

Answer 1

您忘记关闭括号(sin( radians( Links.Latitude ) ) ) ) 附近。试试这个

SELECT
    Links.Title,
    (
        6371 * acos(
            cos(radians(43.4347229)) * cos(radians(Links.Latitude)) * cos(
                radians(Links.Longitude) - radians(6.737222195)
            ) + sin(radians(43.4347229)) * sin(radians(Links.Latitude))
        )
    ) AS distance
FROM
    CatLinks,
    Links
WHERE
    CatLinks.LinkID = Links.ID
AND (
    Links.ID IN (16650, 17190, 153344)
    AND Links.isValidated = 'Yes'
    AND Links.PropertyType IN (1, 2, 3)
    AND Links.priceSort <= '9999'
    AND Links.PropertyType IN (1, 2, 3)
    AND Links.priceSort < '9999'
)
ORDER BY
    distance
LIMIT 0,50