SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =330
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-04-25 22:57:42')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
41639 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Yellow
41640 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Orange
41641 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Pink
41642 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Green
41643 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue
41644 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Purple
42795 SLEEPING TABLET BETRAY CARD CASE
42849 BLACK CRAFT Believe In Yourself Wallet
42850 BLACK CRAFT BCC Goat Wallet
43107 SILLENT FROM ME RICH -Card Case- BLACK/BLACK
43108 SILLENT FROM ME RICH -Card Case- BLACK/WHITE
43109 SILLENT FROM ME RICH -Card Case- WHITE/BLACK
43110 SILLENT FROM ME RICH -Card Case- WHITE/WHITE
44863 ROB ZOMBIE×KILL STAR CLOTHING Mrs Zombie Wallet
45169 VIRGO×GARNI VG-CB-75 LABYRINTH LONG WALLET レザーロングウォレット
47288 PassCode T.Y.O.T Tour Coin Case
47658 RIPNDIP Jermal Coin Pouch (Black)
48184 KILL STAR CLOTHING Under The Stars Wallet
48281 BLACK CRAFT Protection Moth - Zip Around Wallet
49620 DISTURBIA CLOTHING All-Seeing Wallet With Chain
49854 FIVE FINGER DEATH PUNCH TRIFOLD CHAIN Wallet
50152 NOT COMMON SENSE MINI WALLET BAG BLACK
50153 NOT COMMON SENSE MINI WALLET BAG PURPLE
51553 MISHKA MSJ-WLT WALLET
51713 MUSIC SAVED MY LIFE M2A1-01K5-WB01 LONG LEATHER WALLET BLACK
52305 MAGICAL MOSH MISFITS どろたま WALLET RED
52306 MAGICAL MOSH MISFITS どろたま WALLET DOKU
52307 MAGICAL MOSH MISFITS どろたま WALLET PINK
52417 Zephyren 2020 NEW YEAR BAG
52739 MISHKA MSS203109F12 CASE SAFTY GREEN