SELECT id,businessName,GROUP_CONCAT(id) FROM tbl_business LIMIT 0,1

以上查询给出了以下结果

1   Camp San Fransisco  1,4

现在，如果我应用GROUP BY并限制相同的查询，GROUP_CONCAT列不会给我与以前相同的结果 .

SELECT id,businessName,GROUP_CONCAT(id) FROM tbl_business GROUP BY id LIMIT 0,1

查询结果

1   Camp San Fransisco  1

我正在使用GROUP BY id来获取具有某些where条件的唯一记录 .

是否有任何替代方法可以使用GROUP_BY和GROUP_CONCAT或MySQL的任何其他方法，这在这里很有用 .

我想保留第一个带有id的查询结果，所以我只需要根据第一个结果id调用第二个查询，如果可能的话 . 我无法删除GROUP BY id，因为多个表的LEFT JOIN和一些SUB QUERY取决于它

以上查询仅用于解释目的，原始查询更长 .

实际查询：

SELECT bs.id,bs.businessName,bs.businessDesc,bs.latitude,bs.longitude,bs.slug,bs.contactNo,bs.location,bs.isAddedBy,bs.createdDate,cat.categoryName as category,GROUP_CONCAT(DISTINCT(bcat.categoryName) SEPARATOR ', ') as subcategory,
        (SELECT COUNT(id) FROM tbl_reviews WHERE referenceId = bs.id) as totalReview,
        (SELECT CEIL(AVG(rating)) FROM tbl_reviews WHERE referenceId = bs.id) as avgRating,
        (SELECT imageName FROM tbl_business_images as bimg WHERE bimg.businessId = bs.id LIMIT 1) as bImage,

        (
            (ACOS
                (
                    SIN(37.09024 * PI() / 180) * SIN(bs.latitude * PI() / 180) + COS(37.09024 * PI() / 180) * COS(bs.latitude * PI() / 180) * COS(
                                (-95.712891 - bs.longitude) * PI() / 180)
                )* 180 / PI()
            ) * 60 * 1.1515 * 1.609344
        ) as distance,

        (SELECT 
                (DATEDIFF(bs.createdDate,NOW()) * 5) + 
                ((SELECT COUNT(id) FROM tbl_business_images WHERE businessId = bs.id) * 2) + 
                ((SELECT count(id) FROM tbl_business_views WHERE businessId = bs.id) * 2) + 
                ((SELECT COUNT(id) FROM tbl_reviews WHERE referenceId = bs.id) * 10)) 
        as totalPoint
        FROM tbl_business as bs
        LEFT JOIN tbl_category as cat
        ON bs.businessCat = cat.id
        LEFT JOIN tbl_business_subcategories as bsubs
        ON bs.id = bsubs.businessId
        LEFT JOIN tbl_category as bcat
        ON bsubs.subcategoryId = bcat.id
        WHERE bs.isActive = 'y' 
        GROUP BY bs.slug

当前查询输出：

id  businessName  businessDesc  latitude  longitude slug  contactNo location  isAddedBy createdDate category  subcategory totalReview avgRating bImage  distance  totalPoint  

1   test  test   45.14  -122.82   test   1234567890  USA  c   2018-09-29 11:38:58   Category   Subcategory1,subcategory2   1   5   image.png  2382.763331498852   -4

任何帮助表示赞赏 .

mysql join subquery