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 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-04-25 13:48:11')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 720, 120
54181 Subcietyx攻殻機動隊SAC_2045 ZIP PARKA-GHOST HACK- BLACK
54182 Subcietyx攻殻機動隊SAC_2045 ZIP PARKA-GHOST HACK- PURPLE
54183 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S WHITE
54184 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S BLACK
54185 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S PURPLE
54186 Subcietyx攻殻機動隊SAC_2045 Major S/S WHITE
54187 Subcietyx攻殻機動隊SAC_2045 Major S/S BLACK
54188 Subcietyx攻殻機動隊SAC_2045 Major S/S PURPLE
54189 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S WHITE
54190 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S BLACK
54191 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S RED
52805 Subciety MULTI BORDER L/S PINK
52806 Subciety MULTI BORDER L/S BLUE
52780 Subciety $??¥ S/S GREEN
52779 Subciety $??¥ S/S BLACK
53022 Subciety Daisy S/S WHITE
53021 Subciety Daisy S/S BLACK
52791 Subciety PYTHON S/S BLACK
52789 Subciety MARIA S/S KHAKI
52788 Subciety MARIA S/S BLACK
52787 Subciety MARIA S/S WHITE
52799 Subciety EMBROIDERY THE BASE TEE GRAY
52798 Subciety EMBROIDERY THE BASE TEE BLACK
52797 Subciety EMBROIDERY THE BASE TEE WHITE
52765 Subciety PAISLEY DROP SHOULDER SHIRT NAVY
52764 Subciety PAISLEY DROP SHOULDER SHIRT BLACK
52763 Subciety MARIA WORK SHIRT GREEN
52762 Subciety MARIA WORK SHIRT BLACK
52761 Subciety MARIA WORK SHIRT WHITE
52807 Subciety PYTHON CARGO SHORTS BLACK
52810 Subciety WIDE SLACKSBEIGE
52809 Subciety WIDE SLACKS BLACK
52821 Subciety LOW CAP ORANGE
52820 Subciety LOW CAP GRAY
52819 Subciety LOW CAP BLACK
52847 Subciety GYM SOCKS WHITE/BLUE
52846 Subciety GYM SOCKS WHITE/GREEN
52845 Subciety GYM SOCKS WHITE/YELLOW
52830 Subciety CAUCHO BELT NAVY/GREEN
52829 Subciety CAUCHO BELT NAVY/BURGUNDY
52851 Subciety AIRPODS CASE BLACK
52855 Subciety SHOWER SANDALS BLACK
16179 Subciety SNAP BACK CAP-GLORIOUS- - BLACK/BLACK
53023 Subciety EMOTION S/S BLACK
53024 Subciety EMOTION S/S WHITE
53025 Subciety Guadalupe S/S BLACK
53027 Subciety RATIO S/S BLACK
53028 Subciety RATIO S/S WHITE
50942 Subciety (サブサエティ) FLAVOR S/S STRAWBERRY
50952 Subciety (サブサエティ) DROP SHOULDER TEE-TAG- BLACK
50953 Subciety (サブサエティ) EMBROIDERY TEE BK/WHT
50955 Subciety (サブサエティ) EMBROIDERY TEE BLACK/RED
47051 Subciety 【WOMENS】TINY TEE-THE BASE- WHITE
47434 Subciety SIDE GLORIOUS S/S WHITE
47521 Subciety (サブサエティ) DRY TEE-THE BASE- WHITE
47522 Subciety (サブサエティ) DRY TEE-GLORIOUS- BLACK
47870 Subciety (サブサエティ) X-RATIO S/S BURGUNDY
48288 Subciety (サブサエティ) SUKA SOUVENIR S/S WHITE
48289 Subciety (サブサエティ) SUKA SOUVENIR S/S BLACK
49738 Subciety (サブサエティ) BigB S/S BLACK
49811 Subciety (サブサエティ) LABEL SS BLACK
49918 Subciety (サブサエティ) TAG S/S WHITE/PINK
49921 Subciety (サブサエティ) GI S/S NAVY
42883 Subciety THE BASE S/S - MAGENTA/WHITE
42882 Subciety THE BASE S/S - ORANGE/WHITE
42890 Subciety GLORIOUS S/S - PURPLE/WHITE
41436 Subciety (サブサエティ) BRAND S/S BLACK
12479 Subciety TIE DYE TEE S/S GRAY
45736 Subciety (サブサエティ) BABYLON TEE WHITE
45737 Subciety (サブサエティ) BABYLON TEE BLACK
45738 Subciety (サブサエティ) Dear president S/S WHITE
45739 Subciety (サブサエティ) Dear president S/S BLACK
46765 【Subciety x RADIO EVA】 RADIO EVA TOUR S/S RED/WHITE
48371 【Subciety x RADIO EVA】 RADIO EVA TOUR S/S WHITE/BLACK
25771 Subciety STANDARD S/S BLACK
34686 Subciety (サブサエティ) TAG S/S WHITE
34687 Subciety (サブサエティ) TAG S/S BLACK
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
39616 Subciety Beach S/S BLACK
39621 Subciety LADY S/S BLACK
20756 Subciety POCKET TEE S/S-GLORIOUS- WHITE
20757 Subciety POCKET TEE S/S-GLORIOUS- BLACK
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
20769 Subciety (サブサエティ) FLAG S/S NAVY
20780 Subciety GLORIOUS S/S BLUE/ORANGE
20781 Subciety GLORIOUS S/S PURPLE/YELLOW
22990 Subciety(サブサエティ) R.I.P. S/S WHITE
23056 Subciety GI S/S BLACK
23078 Subciety(サブサエティ) GLORIOUS S/S-BRIGHT- GREEN
23079 Subciety(サブサエティ) GLORIOUS S/S-BRIGHT- YELLOW
23090 Subciety(サブサエティ) THRON S/S BLACK
23098 Subciety GLORIOUS S/S OLIVE
23110 Subciety SALOON S/S BLACK/RED
23111 Subciety SALOON S/S NAVY/YELLOW
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23125 Subciety COLLEGE S/S NAVY/WHITE
23132 Subciety BREAK DOWN WALLS S/S WHITE
9219 Subciety MAD Ollie 2013 –SENDAI- WHITE
9218 Subciety MAD Ollie 2013 –SENDAI- BLACK
8773 Subciety MAD Ollie 2013 –NAGOYA- BLACK/GRAY
11187 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BLKW
11864 Subciety PATTERNED TEE S/S -GLORIOUS- PINK
11869 Subciety ONE RAD LIFE S/S BLACK/GOLD
12333 Subciety Guadalupe S/S WHITE
12458 Subciety TRUST S/S WHITE
12459 Subciety TRUST S/S BLACK/WHITE
12460 Subciety MAD HATTER S/S -Baphomet-WHITE
12466 Subciety MAD Ollie 2014 TEE DENIM
12620 Subciety SURF SKULL S/S NAVY
12621 Subciety SURF SKULL S/S BGN
12626 Subciety HEART BIRD S/S GREEN
13701 Subciety BORDER S/S-GLORIOUS- BLUE/GRAY
16101 Subciety 15th GLORIOUS S/S - BLACK/GOLD
16103 Subciety 15th GLORIOUS S/S - BLACK/RED
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
17673 Subciety TIE DYE TEE-GLORIOUS- GREEN
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18448 Subciety GLORIOUS S/S - BLACK/GOLD
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
18467 Subciety 15th GLORIOUS S/S - NAVY/WHITE