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-05-25 00:28:59')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 1680, 120
53042 SABBAT13 CASKET T BLACK
53044 SABBAT13 SKATE HAND T BLACK
53051 SABBAT13 PENNYWISE T YELLOW
53052 SABBAT13 PENNYWISE T BLACK
53053 SABBAT13 PENNYWISE T WHITE
53086 KAVANE Clothing "HYPOTHESIS"OVERSIZE CUTSEW(Blk)
53087 KAVANE Clothing "HYPOTHESIS"OVERSIZE CUTSEW(Red)
53099 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE INDIGO
53102 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE WHITE
53120 LILWHITE(dot) LW-20SS-T01 ANGERL TEE BLK
53121 LILWHITE(dot) LW-20SS-T01 ANGERL TEE WHT
53137 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type A
53138 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type B
53139 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type A
53140 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type B
53141 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Black
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
53144 HEDWiNG HD1-019 80’s Tropical T-shirt White
53146 HEDWiNG HD1-020 Drawstring 2020 T-shirt Black
53148 HEDWiNG HD1-020 Drawstring 2020 T-shirt White
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
53241 Zephyren(ゼファレン)SWITCHING TEE S/S WHITE / BLACK
53253 Zephyren(ゼファレン)SWITCHING TEE S/S BLACK / GRAFFITI
53291 Zephyren(ゼファレン)S/S TEE - PROVE - BLACK
53868 MISHKA(ミシカ) MSS200069 T-SHIRTS WHITE
53869 MISHKA(ミシカ) MSS200069 T-SHIRTS BLACK
53871 MISHKA(ミシカ) MSS200085 T-SHIRTS BLACK
53872 MISHKA(ミシカ) MSS200086 T-SHIRTS
53876 MISHKA(ミシカ) MSS201102 T-SHIRTS WHITE
53877 MISHKA(ミシカ) MSS201102 T-SHIRTS BLACK
53900 TRAVAS TOKYO All Strawberry patternedビッグTシャツ Black×Red
53901 TRAVAS TOKYO All Strawberry patternedビッグTシャツ Black×Blue
53902 TRAVAS TOKYO Furry bearビッグTシャツ White
53903 TRAVAS TOKYO Furry bearビッグTシャツ Pink
53904 TRAVAS TOKYO Furry bearビッグTシャツ Black×Purple
53905 TRAVAS TOKYO Furry bearビッグTシャツ Black×Blue
53907 CIVARIZE【シヴァーライズ】 Lady's型 Tee WHITE
53908 CIVARIZE【シヴァーライズ】 Lady's型 Tee BLACK
53910 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type A
53911 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type B
53960 Civil Regime 20CV-SP01T REBEL YOUTH CO TEE
53961 Civil Regime 20CV-SP02T OUTSIDERS FOREVER TEE
53962 Civil Regime 20CV-SP04T BORN WILD TEE VINTAGE BLACK TEE
53963 TRAVAS TOKYO たれくまTシャツ
53964 SILLENT FROM ME 沈黙 BLACK
53965 SILLENT FROM ME 沈黙 WHITE
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
53985 GALFY 鬼YABAI Tee カーキ
53986 GALFY 鬼YABAI Tee 漆黒
53987 GALFY 鬼YABAI Tee 江戸紫
53988 PUNK DRUNKERS 2020BIG.TEE BLACK
54005 PUNK DRUNKERS ステッカーTEE'20 / REVIVAL - WHITE
54006 PUNK DRUNKERS ステッカーTEE'20 / REVIVAL - M.GREEN
54040 GALFY イヌツカイTee 漆黒
54064 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - BLACK
54065 PUNK DRUNKERS [PDSxくっきー!]ミスティTEE - KHAKI
54111 SABBAT13 SKATE HAND T WHITE
54112 SABBAT13 CASKET T LAVENDER
54113 SABBAT13 BLESSING T BLACK
54114 SABBAT13 BLESSING T TURQUOISE
54126 ROLLING CRADLE TIEFYE TEE PINK
54127 ROLLING CRADLE TIEFYE TEE YELLOW
54128 ROLLING CRADLE TIEFYE TEE BLUE
54171 GALFY カラーギャングTee 白黒ギャング
54172 GALFY カラーギャングTee 黒紫ギャング
54173 GALFY カラーギャングTee グリーンオレンジギャング
54174 GALFY 色秀逸背中にドーン! BIG Tee 純白/薄ピンク/水色
54175 GALFY 色秀逸背中にドーン! BIG Tee 漆黒/紫/オレンジ
54206 TOY MACHINE PRINT POCKET SST (BIG SIZE) - WHITE
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
54256 NOT COMMON SENSE SCARF PRINTED TEE
54257 NOT COMMON SENSE ”ANCIENT”SIDE ZIP TEE BLACK
54259 NOT COMMON SENSE ”NCS FILM” TEE BLACK
54291 PUNK DRUNKERS タイダイーズTEE - GREEN
54292 PUNK DRUNKERS タイダイーズTEE - PURPLE
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
54453 MISHKA(ミシカ) MSS200031 T-SHIRTS Gray
54454 MISHKA(ミシカ) MSS200076 T-SHIRTS Black
54459 MISHKA(ミシカ) MSS200044 T-SHIRTS
54541 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE WHITE
54542 PUNK DRUNKERS [PDSxデラべっぴん]デラぱんくどTEE BLACK
54545 PUNK DRUNKERS ポケットから女TEE BLACK
54546 PUNK DRUNKERS ポケットから女TEE LT.PINK
54595 PARADOX PX17-CS03 BIG WIDE TEE WHITE
54640 ROLLING CRADLE JUDGEMENT TEE NAVY
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
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
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
53215 Zephyren(ゼファレン)PONCHO TEE S/S BLACK
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
54381 Nine Microphones -walkin'mic- S/S - WHITE
56553 NineMicrophones 9MC Crew S/S White/Burgundy
56572 NineMicrophones 9MC Crew S/S Blue