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 18:33:13')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
54642 THRASHER TH8177A S.A.D Tee WHITE
54643 THRASHER TH8177A S.A.D Tee BLACK
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
7047 RUDIE'S (ルーディーズ) AGAINST-Tee BLACK/WHITE
8059 KILL STAR CLOTHING METAL T-SHIRT [B]
9419 WE CAME AS ROMANS Truth Black T-Shirt
10021 Subciety Kurt Cobain × Subciety S/S -Dive-BLK
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
11189 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-DENI
12976 HOLYSHITz Hexagram T-shirts sumi
14181 METALLICA RIDE LYRICS All Over TEE
17711 RIP DESIGN WORXX ripdwスタンダードロゴTシャツ BLACK
17819 NineMicrophones King Of The Road S/S CHARCOAL
18308 PUNK DRUNKERS CITY. TEE WHITE
22892 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- BLACK
23083 Subciety(サブサエティ) GLORIOUS S/S-MELT- WHITE/BLUE
23330 GoneR Logo T-Shirts Ver.3 - Grey
29535 CARCASS UNFIT TEE
35392 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- BLACKxWHITE
38833 MISHKA (ミシカ) LAMOUR SCUM LOVE T-SHIRT FL 171116 YEL
40647 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE BLACK
41254 RIP DESIGN WORXX グレイヴメイカーパンダTシャツ GRAY
42873 MISHKA x AIR JAM 2018 TEE WHITE
45484 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE BLACK
46341 Zephyren(ゼファレン)S/S TEE - alea iacta est / milestone - BLACK
46345 Zephyren(ゼファレン)S/S TEE - MONOLITH - WHITE
47524 VIRGO VG-CUT-381 VINTAGE RAGLAN CUTSEW 染めカットソー BLACK
49813 Subciety (サブサエティ) elements S/S WHITE
49919 Subciety (サブサエティ) TAG S/S WHITE/GREEN
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
52001 Zephyren(ゼファレン) S/S TEE -BEYOND- D.GREEN/WHITE
52024 Zephyren(ゼファレン) S/S TEE -Got lst Todi- WHITE
53924 THRASHER THRASHER DAVID GONZALEZ T-SHIRTS BLUE
54381 Nine Microphones -walkin'mic- S/S - WHITE
54644 THRASHER TH91257 JAN 82 S/S T-SHIRTS
56553 NineMicrophones 9MC Crew S/S White/Burgundy
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
56574 SO SO HAPPY Lucky Wink In Grey
56575 ICECREAM MASH S/S T-SHIRT BLACK
51154 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ BLACK
51155 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ WHITE
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52950 Survive Said The Prophet UNBALANCE TEE WHITE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
41034 RIPNDIP LORD NERMAL POCKET TEE BLACK
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
53215 Zephyren(ゼファレン)PONCHO TEE S/S BLACK
54432 THRASHER (スラッシャー) OUTLINED CRACK S/S T-SHIRTS WHITE
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
55631 Anti Social Social Club BAT EMOJI WHITE TEE
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
54613 Survive Said The Prophet INSIDE YOUR HEAD TEE WHITE
54614 Survive Said The Prophet INSIDE YOUR HEAD TEE BLACK
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
54648 RUDIE'S (ルーディーズ) SOLID PHAT GRADATION-T BLACK
53248 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE/BLACK
595 CHILDREN OF BODOM-Bloody Reaper
618 激ロックFES vol.2 Tシャツ-Red
841 激ロックFES vol.3 Tシャツ-PU
842 激ロックFES vol.3 Tシャツ-GR
844 激ロックFES vol.4 Tシャツ-PU
845 激ロックFES vol.4 Tシャツ-GR
888 IRON FIST CLOTHING-Daniel Son S/S Tee
910 LINKIN PARK Skull Bird T-Shirt
912 BRING ME THE HORIZON BELANGER T-Shirt
919 The Devil Wears Prada Virus Allover Print T-Shirt
1061 ALL THAT REMAINS Lightning Chong on Black Fine Jer
1062 OPETH Hand Parchment Guys Official T Shirt
1364 RANCID Out Come The Wolves Slim-Fit T-Shirt
1448 CHILDREN OF BODOM REAPER EARTH T-Shirt
1828 SUFFOCATION BLEEDING THE SPAWN T-Shirt
1830 SHADOWS FALL OF ONE BLOOD T-Shirt
1840 GOD FORBID LOGO-PHOTO T-Shirt
1896 IWRESTLEDABEARONCE Home Black T-Shirt
2173 THE BLACK DAHLIA MURDER Ritual Girls T-Shirt
2184 ALL SHALL PERISH Bird Flu T-Shirt
2246 BRING ME THE HORIZON LADY OF LIFE T-Shirt
2248 BRING ME THE HORIZON BLACK METAL T-shirt
2251 SLIPKNOT 9 FRAMES T-shirt
2269 BLINK182 3BARS T-shirt
2270 BLINK182 CHAMP T-shirt
2278 A DAY TO REMEMBER FRIENDS T-Shirt
2279 A DAY TO REMEMBER BRING THE NOISE T-Shirt
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2285 BLACK VEIL BRIDES GATE T-Shirt
2452 BLESS THE FALL Road Rage Black
2539 KILLSWITCH ENGAGE DRAGON T-Shirt
2540 KILLSWITCH ENGAGE HORSE T-Shirt
2636 WE CAME AS ROMANS Feel My Wrath Black T-Shirt
2637 WE CAME AS ROMANS Album Black T-Shirt
2647 Iwrestledabearonce Claw Black T-Shirt
2731 IRON FIST Squealer Boyfriend Tee
2813 GLAMOUR KILLS GIRLS HEARTKEY SLOUCHY CROP TOP TEE
2955 SLIPKNOT ALL HOPE STAR T-Shirt
3026 SRH Flowing Sccop Neck G/T
3064 GREEN DAY NEON WINGS T-shirt
3066 GREEN DAY VANDALS T-Shirt
3156 AVENGED SEVENFOLD SWEET SCREAM T-shirt
3158 BULLET FOR MY VALENTINE SKULL BLOSSOM T-shirt
3160 CHILDREN OF BODOM REAPER LIGHTNING T-shirt
3410 UNEARTH RIBS T-Shirt
3465 DEFTONES WHITE PONY T-Shirt
3555 Nine Microphones Pray with the microphone R-S/S BK
3574 A DAY TO REMEMBER WHAT SEPERATES... T-Shirt
3599 FOO FIGHTERS GUITAR T-Shirt
3600 FOO FIGHTERS REEL TO REEL T-Shirt
3601 FOO FIGHTERS RANDOM LETTERS T-Shirt
3616 AVENGED SEVENFOLD ALLOVER DEATHBATS T-Shirt
3617 BLACK VEIL BRIDES ANDY Babydoll