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 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-04-19 20:19:17')
AND FIND_IN_SET(21, p.color)
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
58826 MISHKA(ミシカ) M21000823 SHORTS
64285 RIPNDIP (リップンディップ) Wilshire Sweatshorts (Blue Stripe Dye)
61936 glamb (グラム) Watercolor SH - Black
61935 glamb (グラム) Watercolor SH - Blue
35571 RUDIE'S (ルーディーズ) PHAT DYED-T RAINBOW
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
12571 THRASHER SILVER FLAME LOGO PULLOVER HOODIE GRAY
13799 Subciety TIE DYE PARKA-GLORIOUS- GRAY
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
13801 Subciety TIE DYE PARKA-GLORIOUS- GREEN
13802 Subciety TIE DYE ZIP PARKA-EMOTION- NAVY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
15601 TEXAS IN JULY Draw The Line Black Tie Dye
16604 Subciety TIE DYE ZIP PARKA-EMOTION- GRN
16623 DEADHEARTZ BUG TEES TIE DIE
18084 AC/DC CANNMON Tie-Dye
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
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
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
22408 KILL STAR CLOTHING So Goth Sweatshirt
23679 SPITFIRE Ragran Tee Red Spiral web /Black
23684 SPITFIRE Bighead Grey Spiral Black Rib
23689 SPITFIRE Tripper 2
23690 SPITFIRE Bighead Light grey crinkle tie dye
23847 BACK LIFT タイダイTシャツ TROPICAL
23848 BACK LIFT タイダイTシャツ GREEN
23864 MISHKA (ミシカ) KEEP WATCH BOX LOGO PULLOVER HOODIE BLACK
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
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
24406 Hypocrite(ヒポクリット) The Chemical denimshirts
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
24900 ANIMALIA DOWN TO TEXAS BLUE
24901 ANIMALIA DOWN TO TEXAS NAVY
25185 IWRESTLEDABEARONCE Surf Dracula Multi-Rainbow - Pullover
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
26602 【ゲキクロ限定】deathsight タイダイT BLK
27378 KILL STAR CLOTHING (キルスター・クロージング) F MONDAY T-Shirt [ENZYME]
27413 THRASHER 13WOLVES HOOD
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
27518 KILL STAR CLOTHING (キルスター・クロージング) Slay Sweatshirt [TIEDYE]
27537 KILL STAR CLOTHING (キルスター・クロージング) There Is No We T-Shirt [TIEDYE]
27973 RIP DESIGN WORXX Tie-Dye ハーフパンツ RED
27974 RIP DESIGN WORXX Tie-Dyeハーフパンツ BLUE
27975 RIP DESIGN WORXX Tie-Dye ハーフパンツ PURPLE
28054 SPITFIRE Lil Bighead Premium Long Sleeve T-Shirt - Black Crinkle
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
28056 SPITFIRE Bighead Premium T-Shirt - Red & Black Web 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
28281 STAY SICK CLOTHING Anchor Tie Dye Pullover
28297 UPON A BURNING BODY Sharks Spider Black
28686 DEADHEARTZ “WORLD”TEES TYEDIE
28687 DEADHEARTZ MOON TEES TYEDIE
28851 THRASHER TH8501TD2 MAG LOGO HOODIE WHT/RED
28852 THRASHER TH8501TD2 MAG LOGO HOODIE WHT/BLUE
28853 THRASHER TH8501TD2 MAG LOGO HOODIE BLUE/BLUE
28854 THRASHER TH8501TD2 MAG LOGO HOODIE YEL/YEL
28855 THRASHER TH8501TD2 MAG LOGO HOODIE RED/RED
28856 THRASHER TH8501TD2 MAG LOGO HOODIE WHT/WHT
28857 THRASHER TH8508TD2 FLAME LOGO HOODIE RED/RED
28858 THRASHER TH8508TD2 FLAME LOGO HOODIE WHT/WHT
28859 THRASHER TH8508TD2 FLAME LOGO HOODIE BLUE/BLUE
28873 THRASHER TH8501SD2 MAG LOGO HOODIE BLK
28874 THRASHER TH8501SD2 MAG LOGO HOODIE BLUE
28875 THRASHER TH8501SD2 MAG LOGO HOODIE NAVY
28876 THRASHER TH8501SD2 MAG LOGO HOODIE GRAY
28877 THRASHER TH8508SD2 FLAME LOGO HOODIE BLK
28878 THRASHER TH8508SD2 FLAME LOGO HOODIE BLUE
28879 THRASHER TH8508SD2 FLAME LOGO HOODIE NAVY
28880 THRASHER TH8508SD2 FLAME LOGO HOODIE GRAY
28947 【ゲキクロ限定カラー】deathsight HOODIE BLACK TIEDYE
29796 MISHKA KEEP WATCH PULLOVER HOOD TIEDYE
29839 RUDIE'S PHAT TIEDYE HOOD SWEAT BLACK/WHITE
29840 RUDIE'S PHAT TIEDYE HOOD SWEAT BLACK/BLACK
30097 MISHKA(ミシカ) PEACE CREM KEEP WATCH HOODIE
34247 MISHKA (ミシカ) EXWD1002D LAMOUR LOGO TIE DYE TEE RED
34248 MISHKA (ミシカ) EXWD1002D LAMOUR LOGO TIE DYE TEE GREEN
35037 RUDIE'S DRAWING DYED TEE T.STR
35248 MISHKA (ミシカ) MSS170819M00 Shorts
35252 MISHKA (ミシカ) MSS170834 Shorts
35257 MISHKA (ミシカ) MSS170013 TEE
35568 RUDIE'S PHAT DYED-T AERIAL
37082 MISHKA(ミシカ) MAW170416
39191 STAY SICK CLOTHING Anchor Tie Dye Pullover[B]
39287 REBEL8 TAINTED JACKET
40907 RUDIE'S HUMMING DYED-T SPAIRAL USA
40908 RUDIE'S CHAMELEON DYED-T SPAIRAL STORM
40909 RUDIE'S PENGUIN DYED-T SPAIRAL RAINBOW