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-18 00:40:00')
AND FIND_IN_SET(7, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
4457 SYSTEM OF A DOWN AERIALS T-Shirt
14103 SLIPKNOT THORNS ALL OVER T-Shirt
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15511 WE CAME AS ROMANS Conquer Maroon
15584 TEXAS IN JULY Ministry Maroon
18036 BAD RELIGION NAUGHTY NUNS
18980 MEMPHIS MAY FIRE Eagle Dagger Red
19094 ATTILA About That Life Graffiti Red
19800 CHUNK!NO,CAPTAIN CHUNK! Steering Wheel Cardinal Re
19808 CAPTURE THE CROWN Grim Concrete/Cherry
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19856 A SKYLIT DRIVE Rise Again Maroon
20193 KEYTALK ボーダーTシャツ赤
21220 ATTILA RageAholics Red - T-Shirt
22854 四星球 2015パーカー(A)
24643 NECK DEEP Generic Pop Punk Red Marble - Pullover
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25442 MAYDAY PARADE Keys to a Broken Heart Red - T-Shirt
25506 WE CAME AS ROMANS Andy Wolf Maroon
26419 モーモールルギャバン 復活ツアーTシャツ ウーマン ピンク
28582 AEROSMITH LIVIN ON THE EDGE
29568 Aldious LIVE 2016 Tシャツ ブラック x ピンク
31735 Xmas Eileen ONLY THE BEGINNING ジップアップパーカー(赤)
34154 Xmas Eileen Xmas Eileen カレッジTシャツ BURGUNDY
35705 RED HOT CHILI PEPPERS Asterisk t-shirt Red
36811 SLIPKNOT Embroidered and Applique-Authentic Basketball Jersey
36821 DEFTONES Altar-Red t-shirt
36858 RED HOT CHILI PEPPERS Wheel Outline-Red t-shirt
41052 OBEY x Misfits Fiend Rocker Basic Tee RED
41070 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / RED
41073 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / RED
41076 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 BLACK / RED
42596 Bentham Chicago Tシャツ バーガンディー
42628 KEYTALK シンプルロゴ刺繍Tシャツ バーガンディー
52520 RUDIE’S 2020 NEWYEAR PACK
52983 VIRGO VG-PT-229A NOSTALGIC CHECK PANTS RED
52989 VIRGOVG-CUT-400 PERFECTION NEO US [3/4 SLEEVE] RED
53041 SABBAT13 PARADISE T BURGANDY
53070 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE RED
53076 SAMURAI CORE 釈迦 HOODIE RED
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53134 RUDIE'S DRAWING-T BURGUNDY
53269 Zephyren(ゼファレン)DOLMAN BIG HOODY S/S RED
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
54098 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE RED
54202 TOY MACHINE NEON PRINT SS SHIRT - WINE
54518 ROLLING CRADLE GOKU-BUTO CHECK PANTS / RED
54520 FILA TOKYO ユニセックス プルオーバーフーディ RED
54671 FILA FFM9801 ユニセックス クルーネックシャツ RED
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
54680 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE WHITE
53242 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / RED
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
53249 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE / BURGUNDY
53234 Zephyren(ゼファレン)SWITCHING SHIRT S/S MIX
55548 PUNK DRUNKERS 切替イージーパンツ RED/BLACK
54168 GoneR Day of the Dead Tank-Top Black/Red
54165 GoneR Rose Logo Tank-Top Black/Red
55632 Anti Social Social Club FRANTIC RED FLANNEL
54761 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS RED
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
55988 ROLLING CRADLE ICEE SWEAT / RED
56029 RUDIE'S PHAT CHECK SHIRTS RED
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
54978 Zephyren(ゼファレン)COACH JACKET - fiat lux - BURGUNDY
55034 Zephyren(ゼファレン)KNIT CHECK
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
56201 CIVARIZE【シヴァーライズ】フェザーヤーンプルオーバーロングニット Black×Red
56204 Anti Social Social Club Headrush All Over White Hoodie
56206 Anti Social Social Club Don’t Red Hoodie
56213 Anti Social Social Club Headrush All Over White Tee
55625 SABBAT13 PENNYWISE HOODIE レッド
54234 Subciety BANDANA QUILTING JKT BLACK/RED
56089 ROLLING CRADLE COMBI VEST / RED
56105 ROLLING CRADLE BOUCLE TURTLE NECK / PINK
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
57069 SALUTE CACTUS PRINTER JEANS
56895 SALUTE CACTUS PRINTER HOODIE
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
56326 NineMicrophones NM/CS S/S BURGUNDY
57197 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE RED
57179 acOlaSia Camphell's コーチジャケット RED
57244 mnml(ミニマル) TRACK PANTS RED
57347 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT BURGUNDY
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
57431 THRASHER (スラッシャー) TH8928C GONZ COACH JKT RED
57027 VIRGO Perfection 21 (3/4) 「B.S」 RED
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
57323 Subciety×仮面ライダードライブ DRIVE S/S RED
56671 PUNK DRUNKERS リアルあいつTEE - CORAL
58303 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] PINK
58361 KILL STAR CLOTHING Mika Knit Sweater
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
58514 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボパーカー 如月 愛海 (きさらぎ めぐみ)
58777 Non Stop Rabbit×GEKIROCK CLOTHING コラボ・ロンT RED
59865 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BURGANDY
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
59546 Zephyren(ゼファレン) PAISLEY PARKA RED
60202 Anti Social Social Club Guard Down Shorts
60201 Anti Social Social Club Guard Down Flower Hoodie
58996 NineMicrophones SWEAT-FULLERTON- BURGUNDY
53147 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE RED
53151 SAMURAI CORE 釈迦 TEE RED
54529 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE RED
59439 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / RED
59674 Zephyren(ゼファレン) EASY PANTS 8/S FLOWER
59670 Zephyren(ゼファレン) EASY PANTS FLOWER
60503 Subciety (サブサエティ) SEA OTTER PARKA BURGUNDY
60526 MAGICAL MOSH MISFITS MxMxM HOODIE RED
60545 ROLLING CRADLE HOOD CHECK SHIRT / YELLOW