SELECT SQL_CALC_FOUND_ROWS 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 =6
)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-24 16:44:22')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 720, 120
28865 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Red
28866 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Navy
28897 ROLLING CRADLE GRAVY BIG SHIRTS / Black
28898 ROLLING CRADLE (ロリクレ) GRAVY BIG SHIRTS / Rainbow
28903 RUDIE'S PHAT CHECK SHIRTS RED
28904 RUDIE'S PHAT CHECK SHIRTS BLUE
28943 SABBAT13 IGOR NEL SHIRTS GRAY
28944 SABBAT13 IGOR NEL SHIRTS GREEN
28954 PUNK DRUNKERS カメネルシャツ BLUE
28955 PUNK DRUNKERS カメネルシャツ ORANGE
28956 PUNK DRUNKERS カメネルシャツ RED
28957 PUNK DRUNKERS カメネルシャツ PURPLE
28998 MISHKA (ミシカ) Brock Check Shirt Black/Gray
28999 MISHKA (ミシカ) Check Shirt Red
29000 MISHKA (ミシカ) Check Shirt Blue
29068 PUNK DRUNKERS ドロドロングシャツ長袖 BLACKチェック
29069 PUNK DRUNKERS ドロドロングシャツ長袖 BLUEチェック
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
29164 Subciety (サブサエティ) EMBLEM SHIRT L/S-CAMOUFLAGE- BLACK
29166 Subciety (サブサエティ) EMBLEM SHIRT L/S-CAMOUFLAGE- KHAKI
29168 Subciety (サブサエティ) EMBLEM SHIRT L/S-CHECK- BLUE
29169 Subciety (サブサエティ) EMBLEM SHIRT L/S-CHECK- YELLOW
29172 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- BLACK
29173 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- RED
29174 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- BLUE
29175 Subciety (サブサエティ) CHECK SHIRT L/S Ⅱ-Conductor- RED
29176 Subciety (サブサエティ) CHECK SHIRT L/S Ⅱ-Conductor- BLUE
29180 Subciety (サブサエティ) LONG LENGTH P/O SHIRT L/S-Praha- WHITE
29181 Subciety (サブサエティ) LONG LENGTH P/O SHIRT L/S-Praha- NAVY
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
29405 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLUE
29406 NineMicrophones (ナインマイクロフォンズ) OXFORD SHIRT L/S-Sunny- WHITE
29407 NineMicrophones (ナインマイクロフォンズ) OXFORD SHIRT L/S-Sunny- BLACK
29412 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLACK
29413 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLUE
29608 PUNK DRUNKERS 【PDSx円谷プロ】メトロン星人デニムシャツ ONE-W
29609 PUNK DRUNKERS 【PDSx円谷プロ】メトロン星人デニムシャツ USED
29633 GoneR Flannel Check Paint Shirts BlueCH
29634 GoneR Flannel Check Paint Shirts Black CH
29843 RUDIE'S ANIMAL LONG HOOD SHIRTS BLACK
29844 RUDIE'S ANIMAL LONG HOOD SHIRTS GRAY
29845 RUDIE'S DRAWING LONG CHECK SHIRTS BLACK
29846 RUDIE'S DRAWING LONG CHECK SHIRTS RED
29878 REBEL8 WOMENS ORNATE BADGE FLANNEL DRESS
29918 REBEL8 HARSH REALM FLANNEL
30018 SQUARE (スクエア) HOOD CHECK SHIRTS BLUE×RED
30020 SQUARE (スクエア) HOOD CHECK SHIRTS GREEN×YELLOW
30038 KILL STAR CLOTHING Aurora Magical F**k Button-Up Shirt [B]
30054 DISTURBIA CLOTHING Anti-Social Shirt
30063 DISTURBIA CLOTHING Melvin Plaid Shirt
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
30148 Zephyren(ゼファレン) LONG SHIRT -CocaCola- WHITE
30149 Zephyren(ゼファレン) LONG SHIRT -CocaCola- BLACK
30207 Zephyren(ゼファレン) CHECK SHIRT L/S BLACK
30208 Zephyren(ゼファレン) CHECK SHIRT L/S NAVY
30209 Zephyren(ゼファレン) CHECK SHIRT L/S BURGUNDY
30212 Zephyren(ゼファレン) LONG SHIRT L/S PAISLEY
30216 Zephyren(ゼファレン) LONG CHECK SHIRT L/S RED
30217 Zephyren(ゼファレン) LONG CHECK SHIRT L/S WHITE
30218 Zephyren(ゼファレン) LONG CHECK SHIRT L/S BLACK
32282 SABBAT13 IGOR L/L HOOD NEL SHIRTS (BL)
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
32307 VIRGO Variable change shirts 切り替えチェックシャツ BLUE
32308 VIRGO Variable change shirts 切り替えチェックシャツ RED
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32322 REBEL8 WWD FLANNEL
32392 THE TEST GRAPHIC SHIRTS
32418 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Blue
32419 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Brown
32538 PUNK DRUNKERS あいつクロス切替シャツ BLACK
32539 PUNK DRUNKERS あいつクロス切替シャツ NAVY
32542 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT White
32543 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT Black
32640 Subciety (サブサエティ) EMBLEM SHIRT L/S-CAMOUFLAGE- NAVY
32641 Subciety (サブサエティ) EMBLEM SHIRT L/S-CAMOUFLAGE- SAX
33416 アマツカミ 弔 Long Sleeve Shirt
33436 SILLENT FROM ME NAP -Wide Shirts- BLACK
33437 SILLENT FROM ME NAP -Wide Shirts- WHITE
33438 SILLENT FROM ME NAP -Pattern Wide Shirts STRIPE
33439 SILLENT FROM ME NAP -Pattern Wide Shirts POLKA DOT
33445 LILWHITE(dot) -SEI TO SHI- RIBBON HOODSHIRT WHTxBLK
33446 LILWHITE(dot) -SEI TO SHI- RIBBON HOODSHIRT BLKxWHT
33911 RUDIE'S DRAWING LONG SHIRTS RED CHECK
33912 RUDIE'S DRAWING LONG SHIRTS BLUE CHECK
33913 RUDIE'S PHAT CHECK SHIRTS RED
33914 RUDIE'S PHAT CHECK SHIRTS BLUE
33915 RUDIE'S PHAT CHECK SHIRTS YELLOW
33916 RUDIE'S SCRIPT CHECK SHIRTS RED
33917 RUDIE'S SCRIPT CHECK SHIRTS BLUE
33922 VIRGO Step switch long shirts ロングシャツ BLACK
33923 VIRGO Step switch long shirts ロングシャツ WHITE
33987 PARADOX - LONG SHIRTS (TWOTONE)
33988 PARADOX - LONG SHIRTS (BLACK)
34446 SQUARE GRADATION DENIM SHIRTS
34630 Subciety (サブサエティ) CPO SHIRT-rockabilly- RED
34631 Subciety (サブサエティ) CPO SHIRT-rockabilly- GREEN
34632 Subciety (サブサエティ) CPO SHIRT-rockabilly- BLUE
34639 Subciety (サブサエティ) GINGHAM CHECK SHIRT WHITE
34647 Subciety (サブサエティ) VELVET SHIRT NAVY
34651 Subciety (サブサエティ) PAISLEY SHIRT BLACK
34653 Subciety (サブサエティ) DENIM WESTERN SHIRT BLACK
34654 Subciety (サブサエティ) DENIM WESTERN SHIRT INDIGO
34659 Subciety (サブサエティ) WORK STRIPE SHIRT WHITE
34660 Subciety (サブサエティ) WORK STRIPE SHIRT BLACK
34853 NineMicrophones INDIGO CHECK SHIRT L/S RED
34854 NineMicrophones INDIGO CHECK SHIRT L/S YELLOW
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
34856 NineMicrophones TWIST CHECK SHIRT L/S BLACK
34857 NineMicrophones TWIST CHECK SHIRT L/S NAVY
34861 NineMicrophones WORK SHIRT L/S-ANTI- WHITE
34862 NineMicrophones WORK SHIRT L/S-ANTI- BLACK
34863 NineMicrophones WORK SHIRT L/S-ANTI- BLUE
34954 SABBAT13 GLORY NEL SHIRTS (ブルー) BLUE
34955 SABBAT13 GLORY NEL SHIRTS (グレー) GRAY
34998 Zephyren(ゼファレン) HOODIGAN BLACK
35095 SQUARE CAMO-FLA SHIRTS WHITE
35632 SQUARE CAMO-FLA SHIRTS BLACK
35756 Zephyren (ゼファレン) EMBLEM SHIRT L/S WHITExPAINT
35757 Zephyren (ゼファレン) EMBLEM SHIRT L/S BLACKxPAINT