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 17:44:02')
AND FIND_IN_SET(21, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
57987 GoneR GR28CT002 Tie-dye Line T-Shirts Light Pink
42551 S/S TEE 京都大作戦2018×Zephyren FLAMES BLUE TIE DYE
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
42544 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 BLACK TIE DYE
42545 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 BLUE TIE DYE
48292 REBEL8 HAIGHT SST MULTI
43118 RIP DESIGN WORXX ホラークラウンイビルTシャツ TIEDYE
57985 GoneR GR28CT002 Tie-dye Line T-Shirts White
57988 GoneR GR28CT002 Tie-dye Line T-Shirts Dark Chocolate
35096 THRASHER TH8101YD BLK
46981 PUNK DRUNKERS タイダイアイツTEE BLUE
46982 PUNK DRUNKERS タイダイアイツTEE PINK
46983 PUNK DRUNKERS タイダイアイツベアTEE BLACK
49704 RIP DESIGN WORXX スネークタイダイTシャツ BLUE
49705 RIP DESIGN WORXX スネークタイダイTシャツ EMERALD
49706 RIP DESIGN WORXX スネークタイダイTシャツ GRAY
49707 RIP DESIGN WORXX スネークタイダイTシャツ PINK
42859 RIP DESIGN WORXX レインボーラスタスクリューロゴTシャツ
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
24611 THRASHER ANTI LOGO PRINT S/S T-SHIRT RAINBOW
24612 THRASHER ANTI LOGO PRINT S/S T-SHIRT BLUE OCEAN
35224 THRASHER TH8101STD RED/WHT
35225 THRASHER TH8101STD ROY/WHT
35226 THRASHER TH8101STD ROY/WHT
24232 SpecialThanks missa ツアーT タイダイ
42860 RIP DESIGN WORXX 復刻ripdwオリジナルスパイダータイダイTシャツ WHITE
42861 RIP DESIGN WORXX 復刻ripdwオリジナルスパイダータイダイTシャツ RED
42862 RIP DESIGN WORXX 復刻ripdwオリジナルスパイダータイダイTシャツ BLUE
43117 RIP DESIGN WORXX 謎袋2018夏
41792 FILA FM9490 GRAPHIC T-SHIRT BLACK
23847 BACK LIFT タイダイTシャツ TROPICAL
23848 BACK LIFT タイダイTシャツ GREEN
24257 UNDEAD CORPORATION 朱美デザインTシャツ Tie Dye
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
19804 MISHKA (ミシカ) KEEP WATCH (GID) T-SHIRT Black Spiral TD
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
36264 MISHKA (ミシカ) SM171105TD TEE タイダイ
36265 MISHKA (ミシカ) SM171104TD TEE タイダイ
24198 MISHKA (ミシカ) LAMOUR KILL WITH POWER TIE DYE TEE Purple Sphere Tie Dy
21805 MISHKA (ミシカ) Gazin’s Oscar the Grouch T-Shirt DIEDYE
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
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
47569 Zephyren(ゼファレン)S/S TEE - GIRL TATTOO - BLACK / TIE DIE
18084 AC/DC CANNMON Tie-Dye
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
15601 TEXAS IN JULY Draw The Line Black Tie Dye
19821 MAYDAY PARADE Label Crimson Tie Dye
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
23859 BACKDATE NOVEMBER タイダイ Tee
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
28297 UPON A BURNING BODY Sharks Spider Black
50407 Drug Honey FUCKスケルトンテディ総柄Tシャツ
21215 Stay Sick Clothing Rainbow Anchor Rainbow Sleeve
25483 PIERCE THE VEIL Sugar Skull Tie Dye - T-Shirt
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24761 NORTHLANE Sphere Black w/ Orange Spider Tie Dye - T-Shirt
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)
35251 MISHKA (ミシカ) MSS170028 TEE
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
35022 【ゲキクロ限定】DEADHEARTZ Engrave Tees タイダイ
35037 RUDIE'S DRAWING DYED TEE T.STR
35041 RUDIE'S DRAWING DYED TEE SRW
41562 RUDIE'S 85006 SPARK CYCLON DYED-T BLACK
41563 RUDIE'S 85007 SPARK CYCLON DYED-T BLUE
41564 RUDIE'S 85008 SPARK CYCLON DYED-T ORANGE
41583 MOTORHEAD×LAKAI Iron Fist Tee Tiedye
57989 GoneR GR28CT002 Tie-dye Line T-Shirts Black
16623 DEADHEARTZ BUG TEES TIE DIE
24812 RUDIE'S DECAY TIGER STRIPE DYED-T BLUE
26215 RUDIE'S DISCHARGE SCREW DYED-T BLUE
26216 RUDIE'S DISCHARGE SCREW DYED-T ORANGE
26602 【ゲキクロ限定】deathsight タイダイT BLK
28686 DEADHEARTZ “WORLD”TEES TYEDIE
28687 DEADHEARTZ MOON TEES TYEDIE
35568 RUDIE'S PHAT DYED-T AERIAL
35571 RUDIE'S (ルーディーズ) PHAT DYED-T RAINBOW
40907 RUDIE'S HUMMING DYED-T SPAIRAL USA
40908 RUDIE'S CHAMELEON DYED-T SPAIRAL STORM
40909 RUDIE'S PENGUIN DYED-T SPAIRAL RAINBOW
40910 RUDIE'S SOLID PHAT VIRUS DYED-T WHITE/BLUE
40911 RUDIE'S SOLID PHAT VIRUS DYED-T WHITE/GREEN
40912 RUDIE'S SOLID PHAT VIRUS DYED-T WHITE/PINK
54126 ROLLING CRADLE TIEFYE TEE PINK
54127 ROLLING CRADLE TIEFYE TEE YELLOW
54128 ROLLING CRADLE TIEFYE TEE BLUE
54291 PUNK DRUNKERS タイダイーズTEE - GREEN
54292 PUNK DRUNKERS タイダイーズTEE - PURPLE
49478 SANTA CRUZ CLASSIC DOT S/S REGULAR T-SHIRT SPIDER BLACK
46327 SANTA CRUZ SCREAMING HAND TEE WILD SPIDER
46328 SANTA CRUZ SCREAMING HAND TEE SPIDER BLACK