gpt4 book ai didi

php - 查询中的操作数应包含 1 列

转载 作者:行者123 更新时间:2023-11-29 06:48:32 25 4
gpt4 key购买 nike

<分区>

我有一个复杂的查询,在执行时出现 Operand should contain 1 column(s) 错误。我知道这个错误意味着有一些不需要的括号,但我不知道是哪些。

这是查询:

SELECT 
*
FROM
deals
WHERE
country_id = 2 AND
(city_id = 4 OR city_id = 0) AND
section_id = 2 AND
id IN (
SELECT
deal_id
FROM
deal_repeat
WHERE
start_date = '2013-06-14') AND
business_id IN (
SELECT
*, ( 3959 * acos( cos( radians('51') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('-114') ) + sin( radians('51') ) * sin( radians( lat ) ) ) ) AS distance
FROM
address
HAVING
distance < '25'
)
ORDER BY id DESC

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com