728x90
반응형
SELECT b.* from {$g5['g5_shop_cart_table']} a
left join {$g5['g5_shop_cart_table'] b on (a.it_id=b.it_id)
where a.mb_id IN (
select mb_id from {$g5['g5_shop_cart_table']} where it_id = '1601352389'
) group by it_id
HAVING count(*) > 1
order by count(*) DESC
LIMIT 10
728x90
반응형