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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)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-28 21:21:55')
AND FIND_IN_SET(21, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
71404 PSYCHO NATION(サイコネーション) アイコンハトメTEE タイダイBLACK
70875 RIPNDIP(リップンディップ) LORD NERMAL POCKET TEE (BLACK LIGHTNING WASH)
69508 AILE VIVANTES(エイルヴィヴァンテス) Masonry t-shirt Tie Dye
69509 AILE VIVANTES(エイルヴィヴァンテス) 4th dimension tie dye t-shirt
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60694 DI:VISION ENVIOUS TEE WASHED SPIDER DYE
60695 DI:VISION ENVIOUS TEE WASHED MARBLE
60604 RIPNDIP OG Prisma Embroidered Tee (Red Tie Dye)
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
60054 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE BLU-BLK
60055 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE ORG-BLK
57987 GoneR GR28CT002 Tie-dye Line T-Shirts Light Pink
57989 GoneR GR28CT002 Tie-dye Line T-Shirts Black
58823 MISHKA(ミシカ) M21000015 T-SHIRTS
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
58204 PUNK DRUNKERS タイダイマッポTEE - GREEN/YELLOW
58205 PUNK DRUNKERS タイダイマッポTEE - PINK/PURPLE
57985 GoneR GR28CT002 Tie-dye Line T-Shirts White
57988 GoneR GR28CT002 Tie-dye Line T-Shirts Dark Chocolate
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
35571 RUDIE'S (ルーディーズ) PHAT DYED-T RAINBOW
50942 Subciety (サブサエティ) FLAVOR S/S STRAWBERRY
12479 Subciety TIE DYE TEE S/S GRAY
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
12476 Subciety TIE DYE TEE S/S BGN
15601 TEXAS IN JULY Draw The Line Black Tie Dye
16623 DEADHEARTZ BUG TEES TIE DIE
18084 AC/DC CANNMON Tie-Dye
19804 MISHKA (ミシカ) KEEP WATCH (GID) T-SHIRT Black Spiral TD
19821 MAYDAY PARADE Label Crimson Tie Dye
20038 THRASHER SKATE MAG TIE DYE TEE TH8101RTD BLUE
20039 THRASHER SKATE MAG TIE DYE TEE TH8101RTD BLK
20040 THRASHER SKATE MAG TIE DYE TEE TH8101RTD WHT
20128 激ロック×サボパン【激サボパンTシャツ】 レインボー
20326 MISHKA (ミシカ) KEEP WATCH TIE-DYE T-SHIRT ORANGE
20452 MISHKA (ミシカ) ANDREI BOUZIKOV: KEEP WATCH TIE-DYE T-SHIRT
20496 MISHKA (ミシカ) CYCO MANIA TIE-DYE T-SHIRT RED SPIRAL
20506 FAR★STAR Octopus Eddy TAIDAI BIG T SANレインボー
20509 FAR★STAR Octopus Eddy TAIDAI BIG T ピンクイエロー
20512 FAR★STAR Octopus Eddy TAIDAI BIG T Vレインボー
20611 MISHKA (ミシカ) LAMOUR SUPREME: DEATH ADDER TIE-DYE T-SHIRT
21215 Stay Sick Clothing Rainbow Anchor Rainbow Sleeve
21803 MISHKA (ミシカ) Lamour’s 2 Headed Monster T-Shirt TIEDYE
21805 MISHKA (ミシカ) Gazin’s Oscar the Grouch T-Shirt DIEDYE
23689 SPITFIRE Tripper 2
23690 SPITFIRE Bighead Light grey crinkle tie dye
23847 BACK LIFT タイダイTシャツ TROPICAL
23848 BACK LIFT タイダイTシャツ GREEN
23859 BACKDATE NOVEMBER タイダイ Tee
24029 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE NAVY
24030 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE L.BLUE
24031 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE RED
24198 MISHKA (ミシカ) LAMOUR KILL WITH POWER TIE DYE TEE Purple Sphere Tie Dy
24232 SpecialThanks missa ツアーT タイダイ
24257 UNDEAD CORPORATION 朱美デザインTシャツ Tie Dye
24417 Hypocrite(ヒポクリット) The Tye Dye Orm Logo Tee
24611 THRASHER ANTI LOGO PRINT S/S T-SHIRT RAINBOW
24612 THRASHER ANTI LOGO PRINT S/S T-SHIRT BLUE OCEAN
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24761 NORTHLANE Sphere Black w/ Orange Spider Tie Dye - T-Shirt
24812 RUDIE'S DECAY TIGER STRIPE DYED-T BLUE
24900 ANIMALIA DOWN TO TEXAS BLUE
24901 ANIMALIA DOWN TO TEXAS NAVY
25311 THE DEVIL WEARS PRADA All Over Print Blue
25483 PIERCE THE VEIL Sugar Skull Tie Dye - T-Shirt
26215 RUDIE'S DISCHARGE SCREW DYED-T BLUE
26216 RUDIE'S DISCHARGE SCREW DYED-T ORANGE
26309 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- BLACK
26310 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- BURGUNDY
26311 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- NAVY
26312 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- BLACK
26313 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- NAVY
26317 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- BURGUNDY
26602 【ゲキクロ限定】deathsight タイダイT BLK
27378 KILL STAR CLOTHING (キルスター・クロージング) F MONDAY T-Shirt [ENZYME]
27450 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Lime Tiger Stripe Tie Dye
27451 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Pink Purple Horizontal Wave
27537 KILL STAR CLOTHING (キルスター・クロージング) There Is No We T-Shirt [TIEDYE]
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
28056 SPITFIRE Bighead Premium T-Shirt - Red & Black Web Tie Dye
28057 SPITFIRE Retro Classic T-Shirt - Royal Tie Dye
28058 SPITFIRE Bighead T-Shirt - White/Turquoise/Grey Tie Dye
28244 STAY SICK CLOTHING Suck My Fuck "Slime Squad" Edition Tie Dye
28245 STAY SICK CLOTHING Pizza Eternity Tie Dye
28270 STAY SICK CLOTHING Diamond Tie Dye
28297 UPON A BURNING BODY Sharks Spider Black
28686 DEADHEARTZ “WORLD”TEES TYEDIE
28687 DEADHEARTZ MOON TEES TYEDIE
30651 Zephyren(ゼファレン) TIE DYE S/S TEE -BEYOND- BLACK
30652 Zephyren(ゼファレン) TIE DYE S/S TEE -BEYOND- NAVY
30655 Zephyren(ゼファレン) TIE DYE S/S TEE -REBEL FLAG- BLACK
30656 Zephyren(ゼファレン) TIE DYE S/S TEE -REBEL FLAG- NAVY
33196 Zephyren (ゼファレン) EKG TIE DYE S/S TEE -BEYOND- BLUE
34058 MISHKA TIE DYE SOFT CREAM KEEP WATCH TEE ORANGE
34059 MISHKA TIE DYE SOFT CREAM KEEP WATCH TEE BLACK
34060 MISHKA TIE DYE SOFT CREAM KEEP WATCH TEE TURQUOISE
34245 MISHKA (ミシカ) EXWD1002B SACRYFICE TIE DYE TEE BLK
34246 MISHKA (ミシカ) EXWD1002B SACRYFICE TIE DYE TEE BLU
34247 MISHKA (ミシカ) EXWD1002D LAMOUR LOGO TIE DYE TEE RED
34248 MISHKA (ミシカ) EXWD1002D LAMOUR LOGO TIE DYE TEE GREEN
35022 【ゲキクロ限定】DEADHEARTZ Engrave Tees タイダイ
35037 RUDIE'S DRAWING DYED TEE T.STR
35041 RUDIE'S DRAWING DYED TEE SRW
35046 SQUARE BEACH TIME Ts
35096 THRASHER TH8101YD BLK
35224 THRASHER TH8101STD RED/WHT
35225 THRASHER TH8101STD ROY/WHT
35226 THRASHER TH8101STD ROY/WHT