SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 dtb_products AS p
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-05-01 20:12:56')
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
70684 LINKIN PARK UNISEX PULLOVER HOODIE: METEORA WALL ART
66944 KORN UNISEX T-SHIRT: BLOCKS
52907 KORN UNISEX TEE: DEATH DREAM
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
70679 KORN UNISEX PULLOVER HOODIE: STILL A FREAK (BACK PRINT)
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
28592 MARILYN MANSON CROWN T-Shirts
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
62584 MARILYN MANSON LOGO BACKPACK
69360 MARILYN MANSON UNISEX PULLOVER HOODIE: CLASSIC LOGO
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
59257 NINE INCH NAILS Unisex Tee: Classic Logo
8372 FALLING IN REVERSE Lips T-Shirt BLACK
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
10233 METALLICA DORIS T-Shirt
700 METALLICA-KILL EM ALL
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
10235 METALLICA VINTAGE METAL UP T-Shirt
70282 METALLICA UNISEX PULLOVER HOODIE: 72 SEASONS CHARRED LOGO (BACK PRINT)
69361 METALLICA UNISEX PULLOVER HOODIE: SKULL SCREAMING RED BLACK
585 RED HOT CHILI PEPPERS Asterisk Logo Black
70938 RED HOT CHILI PEPPERS UNISEX HI-BUILD T-SHIRT: CLASSIC ASTERISK LOGO
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
70937 RED HOT CHILI PEPPERS UNISEX SWEATSHIRT: SCRIBBLE ASTERISK
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
70556 MY CHEMICAL ROMANCE UNISEX SWEATSHIRT: MARCH (SLEEVE PRINT)
66947 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: THE BLACK PARADE COVER
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
70948 SUM41 UNISEX T-SHIRT: AKNF SKELETON EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
70933 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SKULL
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT
51426 GREEN DAY Unisex Tee: Hypno 4
10258 GUNS N' ROSES CROSS T-Shirt
36663 GUNS N' ROSES BULLET LOGO
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
59255 NIRVANA Unisex Tee:White Happy Face
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY Happy Face T-Shirt
67967 NIRVANA UNISEX T-SHIRT: SORBET RAY Happy Face
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
59258 Kurt Cobain Unisex Tee: Coloured Side View
69352 NIRVANA UNISEX LONG SLEEVE T-SHIRT: GRADIENT HAPPY FACE (BACK & SLEEVE PRINT)
69366 NIRVANA UNISEX PULLOVER HOODIE: YELLOW HAPPY FACE BLACK
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67953 FALL OUT BOY UNISEX T-SHIRT: TAKE THIS TO YOUR GRAVE
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
71424 BLXCK Tokyo(ブラックトーキョー) Dokuro Sweatshirt
71477 BLXCK Tokyo (ブラックトーキョー) Spiked Trucker Hat
71425 BLXCK Tokyo(ブラックトーキョー) PINK TRIBAL SWEATSHIRT BLACK
71159 GALFY(ガルフィー) 病みに染まりしショートパンツ BLACK
71179 GALFY (ガルフィー) 球蹴りTee BLACK
71223 【予約商品】GALFY(ガルフィー) ガルスモリンガーTee BLACK
70340 GALFY (ガルフィー) いにしえSETUP春の陣 BLACK
70696 環やね × GALFY コラボ・ニットカーディガン BLACK
65622 やね×GALFY×GEKIROCK CLOTHING やねの犬Tシャツ BLACK
70837 Appare!×GALFY×GEKIROCK CLOTHING コラボ・Tシャツ BLACK
70368 Appare!×GALFY×GEKIROCK CLOTHING コラボ・パーカー
71226 【予約商品】GALFY(ガルフィー) ガルプロTee BLACK
71217 【予約商品】GALFY(ガルフィー) 犬まみれショーツ BLACK
71427 gibous(ギボス) Wind hoodie black
71428 gibous(ギボス) button gothic logo hoodie BLACK
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
70898 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE BLACK
70771 TOY MACHINE (トイマシーン) (HEAVY WEIGHT) LIVING TOY - TRANSMISSIONATOR LONG TEE BLACK
70517 TOY MACHINE (トイマシーン) LIVING TOY - FIST LONG TEE BLACK
71168 TOY MACHINE (トイマシーン) RITUAL SECT TRACK JACKET BLACK
71166 TOY MACHINE (トイマシーン) ERIC FOUNTAIN ART COACH JACKET BLACK
70680 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA BLACK
70676 TOY MACHINE (トイマシーン) MATOKIE MONSTER CARGO PANTS BLACK
70904 TOY MACHINE (トイマシーン) OG MONSTER DENIM BUCKET HAT BLACK
69713 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE BLACK
71085 月に足跡を残した6人の少女達は一体何を見たのか...×アマツカミ×GEKIROCK CLOTHING スペシャル・コラボ・パーカー
71086 月に足跡を残した6人の少女達は一体何を見たのか...×アマツカミ×GEKIROCK CLOTHING スペシャル・コラボ・Tシャツ
71407 PSYCHO NATION(サイコネーション) カッティングショルダーTEE BLACKxPURPLE
71410 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE BLACKxBLACK
71397 寝田ルネ×PSYCHO NATION(サイコネーション) デビルTEE BLACK
71400 寝田ルネ×PSYCHO NATION(サイコネーション) ゲーマーTEE BLACK
71403 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE BLACK
71405 PSYCHO NATION(サイコネーション) アイコンハトメTEE BLACK
71408 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE タイダイBLUExBLACK
71409 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE タイダイREDxBLACK
71280 PSYCHO NATION (サイコネーション) チャイナジャージ BLACK×PURPLE
70690 PSYCHO NATION(サイコネーション) ろろコラボトレーナー BLACK
70687 PSYCHO NATION(サイコネーション) ボーンアップリケジップパーカー