SELECT
*
FROM
`gs_store_corner_marks`
WHERE
EXISTS (
SELECT
*
FROM
`gs_store_goods`
INNER JOIN `gs_store_goods_corner_marks` ON `gs_store_goods`.`id` = `gs_store_goods_corner_marks`.`goods_id`
WHERE
`gs_store_corner_marks`.`id` = `gs_store_goods_corner_marks`.`corner_mark_id`
AND `gs_store_goods`.`deleted_at` IS NULL
)
AND `store_id` = 1000106
ORDER BY
`gs_store_corner_marks`.`id` DESC
whereHas语句执行的sql
SELECT
*
FROM
`gs_store_corner_marks`
WHERE
EXISTS (
SELECT
*
FROM
`gs_store_goods`
INNER JOIN `gs_store_goods_corner_marks` ON `gs_store_goods`.`id` = `gs_store_goods_corner_marks`.`goods_id`
WHERE
`gs_store_corner_marks`.`id` =