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 13:16:00')
AND pc.stock > 0
AND FIND_IN_SET(1, 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 120, 120
15510 WE CAME AS ROMANS Hope Crest Black
15537 MAYDAY PARADE Chain Gang Black
15549 NEW BREED SKULL TEE
15579 SECRETS Heart Black Tank Top
15582 TEXAS IN JULY Vice Black
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
16616 this is not a business カタカナTシャツ
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
17973 UNEARTH SKATE RAGE
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
18979 MEMPHIS MAY FIRE Nautical Black
18981 MEMPHIS MAY FIRE Cartoon Matty Black
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19010 WHITECHAPEL Thirst Black
19014 REVOCATION Deathless Album Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19100 ATTILA Guilty Pleasure Black Crewneck
19107 ATTILA SLUGGER BLACK
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19883 WITHIN THE RUINS Green Crest Black Tank Top
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20126 激ロック×サボパン【激サボパンTシャツ】 BLACK
20169 FUZZ REZ ZWEEP DELAY TEE BLK
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
20303 REBEL8 GR8FUL TEE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
21079 ライブキッズあるある ライブキッズTシャツ
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
21125 BEARTOOTH Generation Of Disorder Black
21141 BEFORE MY LIFE FAILS NEW LOGO TEE BLACK
21968 セプテンバーミー ユーレイTシャツ 黒
21991 THREE LIGHTS DOWN KINGS FIRE T-Shirts BLACK
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22377 小南泰葉 「EMETH」 Tシャツ
22613 Bentham cokeTシャツ BLK
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
23453 HER NAME IN BLOOD NEON HOODIE
23454 HER NAME IN BLOOD BEAST MODE TOUR T-Shirts
23591 HER NAME IN BLOOD HOODIE
23685 SPITFIRE Malt Bighead Black
24258 UNDEAD CORPORATION 朱美デザインTシャツ BLACK
24260 UNDEAD CORPORATION LOGO Tshirt BLK×GOLD
24434 【限定カラー】あゆみくりかまき MATAGI IN DA HOUSE Tシャツ
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24655 NECK DEEP Hero Quest Black - Crewneck
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24755 WHITECHAPEL Crate Black - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24771 NORTHLANE Gravity Black - Long Sleeve Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
25127 THE STORY SO FAR Snakes Black - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25137 SEAWAY Crystal Ball Black - T-Shirt
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25230 LIKE MOTHS TO FLAMES Pizza Black - T-Shirt
25232 LIKE MOTHS TO FLAMES Baseball Black - T-Shirt
25266 DOCAN! ANARCHY workshirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
25308 CHIODOS Snowman Black - T-Shirt
25443 MAYDAY PARADE Dying To Meet You Black - T-Shirt
25450 MAYDAY PARADE Bright Idea
25482 PIERCE THE VEIL Orange Seal Black - T-Shirt
25487 SECRETS Scuba Black - T-Shirt
25491 THE SUMMER SET Legendary Black - T-Shirt
26142 CONVERGE Poacher Black
26144 ARCHITECTS Daybreaker Crewneck
26150 I KILLED THE PROM QUEEN Monogram Tee
26152 I KILLED THE PROM QUEEN Monogram Zip Hoodie
26230 OPETH Morningrise Hoodie
26281 DROPKICK MURPHYS Drinking Skeleton Cross Zip Hood
26431 モーモールルギャバン 2014 Tシャツ ブラック
26451 MOTION CITY SOUNDTRACK GO Album Logo
26454 REFUSED All Dressed Up
26455 SLEEPING WITH SIRENS Red Chain
26456 SLEEPING WITH SIRENS Grey Crest
26542 UROBOROS TシャツA
26543 UROBOROS TシャツB
27374 THE USED VULNERABLE T
27377 DEEZ NUTS Bout It Sweatshirt
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
28025 ATTILA BASEBALL T-SHIRT
28047 SPITFIRE Bighead Fill T-Shirt - Black/Red
28240 CITY LIGHTS Skeleton T-shirt
28295 THE BROWNING Skull Black
28301 UPON A BURNING BODY Logo All Over T-Shirt
28310 FRONZILLA Party People's Anthem Black TankTop
28362 ALL OFF おつきT BLACK
28575 DEFTONES CALIFORNIA T-Shirts
28607 PINK FLOYD MELTING PRISM
28609 PINK FLOYD COMPASS
28627 GUNS N' ROSES HEADS VINTAGE
28663 DEMON HUNTER BASIC
28710 SOILWORK ANCHOR
31952 Bentham ExPツアーTシャツ BLACK
31955 Bentham NEW LIFE Tシャツ
35515 ALL OFF×LILWHITE. SEEKER T-shirt Black×Red