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 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-05-22 21:40:08')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 733)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 120, 120
57100 Survive Said The Prophet SIDE ZIP HOODIE
27810 Crossfaith XENO レコード(MARBLE)
36502 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve White
36503 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve Black
2251 SLIPKNOT 9 FRAMES T-shirt
4671 KORN CLASSIC T-Shirt
12044 KORN RILLA T T-Shirt
26175 SUICIDE SILENCE Can't Stop Me
28578 MARILYN MANSON 15 STARS T-Shirts
28587 SLIPKNOT LOGO Beanie
28714 SUICIDE SILENCE MANGLED GEARS
28716 SUICIDE SILENCE YOU CAN'T STOP ME
52515 MARILYN MANSON WRIST STRAP LOGO
28692 KORN PLASTIC LOGO Beanie
37234 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ ライトピンク
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37237 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ ホワイト
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
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
58435 Survive Said The Prophet SIDE TAG BEANIE GRAY
58436 Survive Said The Prophet SIDE TAG BEANIE BLACK
58437 Survive Said The Prophet REDEFINE TYBEK BAG BLACK
62572 Survive Said The Prophet TRADITIONAL TEE
62573 Survive Said The Prophet "INFINI" TEE NATURAL
27811 Crossfaith GLITCH ON BLACK LONGSLEEVE SHIRT
27814 Crossfaith Snapback(2016Spring)
27816 Crossfaith Longsleeve Shirt(2016Spring)
32273 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 冬季講習 ロングTシャツ
34352 a crowd of rebellion 10th Anniversary Tour 2017 Mobile Battery
34354 a crowd of rebellion 10th Anniversary Tour 2017 Smart Phone Case Black
34355 a crowd of rebellion 10th Anniversary Tour 2017 Smart Phone Case Pink
34353 a crowd of rebellion 10th Anniversary Tour 2017 iPhone Case
26437 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ BLUExPINK
26438 【限定アイテム】a crowd of rebellion ゲキクロ&VV 限定Tシャツ WHITExRED
26439 【限定アイテム】a crowd of rebellion 激クロ&VV限定Tシャツ GREENxWHITE
36499 【ゲキクロ限定】 a crowd of rebellion Gingerol T-Shirt Orange
42375 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLACKxWHITE
42376 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLACKxRED
42377 【限定アイテム】 a crowd of rebellion Ill Reversible Belt ORANGE
42378 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLUE
49833 SLIPKNOT Barcode-CD Wallet
17748 a crowd of rebellion The Crow Black TEE
17749 a crowd of rebellion The Crow Off White
17750 a crowd of rebellion Band Logo Black
17751 a crowd of rebellion Band Logo Off White
19156 a crowd of rebellion Blood Sphere Ver2 WHITE
19157 a crowd of rebellion Blood Sphere Ver2 BLACK
19158 a crowd of rebellion 【お犬様】
25561 a crowd of rebellion Tシャツ 宇宙人
25562 a crowd of rebellion Tシャツ あーす
25563 a crowd of rebellion Tシャツ ごま達 反逆
27819 Crossfaith 限定デザイン Tシャツ
32271 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 冬期講習 Tシャツ
34344 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Charcoal Gray
34345 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Light Blue
36504 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Black
36505 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Yellow
36506 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Red
40981 a crowd of rebellion T-Shirts
70721 Survive Said The Prophet HASHTAG MULTI SHOULDER STRAP
57101 Survive Said The Prophet WATER PROOF COACH JKT (BLACK)
37236 魔法少女になり隊 ネックストラップ
51192 SLIPKNOT STANDARD KEYCHAIN: LOGO
25567 a crowd of rebellion ロゴどん!タオル ver.2
32275 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 タオル
34347 a crowd of rebellion 10th Anniversary Tour 2017 Towel
17757 a crowd of rebellion Towel Blue
35285 SLIPKNOT Standard Keychain
52952 Survive Said The Prophet FIRE LOGO CAP
70712 Survive Said The Prophet CARABINER RANDOM MARBLE
70713 Survive Said The Prophet CARABINER CLEAR NEON YELLOW
42379 【限定アイテム】 a crowd of rebellion Rubber Band BLACKxWHITE
52950 Survive Said The Prophet UNBALANCE TEE WHITE
27820 Crossfaith 限定デザイン バンダナ
34351 a crowd of rebellion 10th Anniversary Tour 2017 Bottle Strap
35283 SLIPKNOT Logo Gummy Band
36507 【ゲキクロ限定】 a crowd of rebellion Gingerol Rubberband Black
36508 【ゲキクロ限定】 a crowd of rebellion Gingerol Rubberband Pink
36509 【ゲキクロ限定】 a crowd of rebellion Gingerol Rubberband Blue
36510 【ゲキクロ限定】 a crowd of rebellion Gingerol Rubberband Purple
25564 a crowd of rebellion りべ子 ヴァンパイアバージョン PNK×BLUE
25566 a crowd of rebellion りべ子 ヴァンパイアバージョン WHT×RED
25571 a crowd of rebellion ロゴバンド ボタン付き
52953 Survive Said The Prophet EVERY DAY SOX A
17753 a crowd of rebellion Rubber Bracelet CAMO
25570 a crowd of rebellion ロゴバンド ボタン無し
26440 【限定アイテム】a crowd of rebellion ゲキクロ&VV 限定ラバーバンドBLUE
26441 【限定アイテム】a crowd of rebellion ゲキクロ&VV 限定ラバーバンドRED
34350 a crowd of rebellion 10th Anniversary Tour 2017 Rubber Bracelet
41368 a crowd of rebellion ラバーバンド
57095 Survive Said The Prophet DISPOSABLE MASK ORANGE
57096 Survive Said The Prophet DISPOSABLE MASK PINK
57098 Survive Said The Prophet DISPOSABLE MASK BLACK
14105 a crowd of rebellion Rubber Bracelet GREEN
19909 a crowd of rebellion ラバーバンド お犬様 BLK
19910 a crowd of rebellion ラババン お犬様 LIGHT BLUE
19911 a crowd of rebellion ラバーバンド お犬様 PINK
19912 a crowd of rebellion ラバーバンド お犬様 WHT
19913 a crowd of rebellion ラバーバンド お犬様 BLUE
32276 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 ラバーバンド
34558 a crowd of rebellion Rubber Bracelet PINK
34559 a crowd of rebellion Rubber Bracelet YELLOW
34349 a crowd of rebellion 10th Anniversary Tour 2017 IC Card Sticker
37238 魔法少女になり隊×ハジメ☆ファンタジーコラボ缶バッジ ぶっとバスターホワイト
37239 魔法少女になり隊×ハジメ☆ファンタジーコラボ缶バッジ ぶっとバスターブラック
37240 魔法少女になり隊×ハジメ☆ファンタジーコラボ缶バッジ 完全無敵ホワイト
37241 魔法少女になり隊×ハジメ☆ファンタジーコラボ缶バッジ 完全無敵ブラック
34348 a crowd of rebellion 10th Anniversary Tour 2017 Badge
17759 a crowd of rebellion Sticker Black
17760 a crowd of rebellion Sticker Red