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-29 03:57:39')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 10560, 120
54413 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / WHITE
54415 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / BEIGE
54416 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / BLUE
54417 ROLLING CRADLE RGCDL BEAR SUPER BIG TEE / PINK
54418 ROLLING CRADLE RGCDL BEAR SUPER BIG TEE / BLACK
54419 SILLENT FROM ME PHILOSOPHY T-Shirt BLK
54420 SILLENT FROM ME PHILOSOPHY T-Shirt WHT
54421 SILLENT FROM ME SIGN -Pocket- T-Shirt BLK
54422 SILLENT FROM ME SIGN -Pocket- T-Shirt WHT
54423 【BTS着用モデル】 FILA FFM9357 T-shirts Turquoise
54424 【BTS着用モデル】 FILA FFM9357 T-shirts Pink
54425 【BTS着用モデル】 FILA FFM9357 T-shirts Orange
54426 【BTS着用モデル】 FILA FFM9357 T-shirts Green
54427 【BTS着用モデル】 FILA FFM9357 T-shirts Navy
54428 【BTS着用モデル】 FILA FFM9357 T-shirts Dark Navy
54429 【BTS着用モデル】 FILA FFM9357 T-shirts OffWhite
54452 MISHKA(ミシカ) MSS200031 T-SHIRTS Safety Green
54453 MISHKA(ミシカ) MSS200031 T-SHIRTS Gray
54454 MISHKA(ミシカ) MSS200076 T-SHIRTS Black
54455 MISHKA(ミシカ) MSS200076 T-SHIRTS Purple
54459 MISHKA(ミシカ) MSS200044 T-SHIRTS
54541 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE WHITE
54542 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE BLACK
54543 PUNK DRUNKERS REAL MONSTER.TEE BLACK
54544 PUNK DRUNKERS REAL MONSTER.TEE LIME
54545 PUNK DRUNKERS ポケットから女TEE BLACK
54546 PUNK DRUNKERS ポケットから女TEE LT.PINK
54557 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” てぃー WHITE
54558 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” てぃー BLACK
54559 MAGICAL MOSH MISFITS SONIC THE HEDGEHOG x MxMxM MAGICAL SONIC MISFITS TEE YELLOW
54560 MAGICAL MOSH MISFITS SONIC THE HEDGEHOG x MxMxM MAGICAL SONIC MISFITS TEE DOKU
54561 MAGICAL MOSH MISFITS SONIC THE HEDGEHOG x MxMxM MAGICAL SONIC MISFITS TEE GREEN
54595 PARADOX PX17-CS03 BIG WIDE TEE WHITE
54617 Survive Said The Prophet STANDARD TEE
54629 FILA FFM9836 ユニセックス クルーネックシャツ WHITE
54630 FILA FFM9836 ユニセックス クルーネックシャツ RED
54631 FILA FFM9836 ユニセックス クルーネックシャツ NAVY
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54633 FILA FFM9841 ユニセックス クルーネックシャツ RED
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
54635 FILA FFM9848 ユニセックス クルーネックシャツ BLACK
54636 FILA FFM9848 ユニセックス クルーネックシャツ WHITE
54637 FILA FFM9847 ユニセックス クルーネックシャツ WHITE
54638 FILA FFM9847 ユニセックス クルーネックシャツ BLACK
54640 ROLLING CRADLE JUDGEMENT TEE NAVY
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
54649 mnml(ミニマル) STRIOED BOXY TEE BLUE/YELLOW
54652 CIVARIZE【シヴァーライズ】レースアップZIPデザインビッグTシャツ WHITE
54653 CIVARIZE【シヴァーライズ】レースアップZIPデザインビッグTシャツ BLACK
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
54696 Civil Regime 20CV-SP05T NEW BLOOM TEE
54697 Civil Regime 20CV-SP07T 8 BALL TEE PASTEL SPIRAL
54698 Civil Regime 20CV-SP08T TIMES UP TEE PASTEL SPIRAL
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
54700 MISHKA(ミシカ) MSS200032 T-SHIRTS GREEN
54703 MISHKA MSS200005 T-SHIRTS GREEN
54704 MISHKA MSS200005 T-SHIRTS ORANGE
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
53248 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE/BLACK
54648 RUDIE'S (ルーディーズ) SOLID PHAT GRADATION-T BLACK
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
55631 Anti Social Social Club BAT EMOJI WHITE TEE
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
54432 THRASHER (スラッシャー) OUTLINED CRACK S/S T-SHIRTS WHITE
53215 Zephyren(ゼファレン)PONCHO TEE S/S BLACK
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
41034 RIPNDIP LORD NERMAL POCKET TEE BLACK
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
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
51154 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ BLACK
51155 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ WHITE
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