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-20 23:59:32')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 647)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
57189 acOlaSia SMILE MOON BEANIE RED
57196 acOlaSia LOGO BEANIE ORANGE
48535 acOlaSia LOGO Socks White×Red
48536 acOlaSia LOGO Socks White×Black
48537 acOlaSia LOGO Socks Black×Red
49672 acOlaSia キーストラップ
66639 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・缶バッジ・セット
44923 【ゲキクロ限定】acOlaSia STAFF TEE WHITE[B]
36305 acOlaSia ▽ WHITE
36298 acOlaSia jAmmer BLACK
36299 acOlaSia jAmmer WHITE
36300 acOlaSia aSk
36294 acOlaSia sKull souris BLACK
36297 acOlaSia sKull souris WHITE
36312 acOlaSia cIgarettes BLACK
36303 acOlaSia Machinery Duck WHITE
36308 acOlaSia g◇at
36309 acOlaSia Machinery Mouse WHITE
40872 acOlaSia hybrid TEE
60241 acOlaSia FRIDAY BACK PRINT TEE BLACK
60243 acOlaSia I DON'T GIVE A SHIT TEE BLACK
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
57194 acOlaSia LOGO BEANIE RED
36301 acOlaSia cOntrol B
36302 acOlaSia cOntrol P
36304 acOlaSia wOlf
36306 acOlaSia ▽ BLACK
36307 acOlaSia Machinery Mouse BLACK
36310 acOlaSia cIgarettes color
36311 acOlaSia re:d◇ll
42974 【ゲキクロ限定】acOlaSia STAFF TEE WHITE
49674 acOlaSia STAFF TEE BLACK
49675 acOlaSia STAFF PASS TEE BLACK
45733 南菜生×火寺バジル×acOlaSia コラボTシャツ BLACK
63235 acOlaSia (アコレイジア) Hungry L/S WHITE
51772 極東ロマンス×acOlaSia ゲキクロ限定コラボ第2弾 ネックストラップ
36290 【ゲキクロ限定】acOlaSia Machinery Mouse BIG TEE WHITE
36292 【ゲキクロ限定】acOlaSia Machinery Mouse BIG TEE BLACK
43753 KAVANE Clothing × acOlaSia 限定コラボTEE
48531 acOlaSia gag Big tee
48532 acOlaSia angel pics Big tee
48533 acOlaSia TOKYO BIG T White
48534 acOlaSia TOKYO BIG T Black
49673 acOlaSia PUNISH T
37474 ゲキクロ限定 acOlaSia mOrSe BIG TEE BLACK
40388 acOlaSia STAFF LONG SLEEVE TEE
41068 【ゲキクロ限定】acOlaSia STAFF LONG SLEEVE TEE WHITE
60245 acOlaSia MEDAMAYAKI TEE BLACK
60247 acOlaSia NEXT IS YOU TEE BLACK
64892 acOlaSia (アコレイジア) RABBIT tee BLACK
57182 acOlaSia poison hoodie BLACK
61818 acOlaSia (アコレイジア) VxC hoodie BLACK
43361 acOlaSia I(CA)T パーカー
57187 acOlaSia SMILE MOON BEANIE BLACK
57188 acOlaSia SMILE MOON BEANIE WHITE
57190 acOlaSia SMILE MOON BEANIE PURPLE
57191 acOlaSia SMILE MOON BEANIE ORANGE
57192 acOlaSia LOGO BEANIE BLACK
57193 acOlaSia LOGO BEANIE WHITE
57195 acOlaSia LOGO BEANIE PURPLE
45121 acOlaSia × ぽにきんぐだむ コラボパーカー
36296 acOlaSia Machinery Duck BLACK
45732 南菜生×火寺バジル×acOlaSia コラボジップパーカー SLEEVE WHITE
64890 acOlaSia (アコレイジア) RABBIT tee WHITE
64891 acOlaSia (アコレイジア) RABBIT tee BLUE
45734 南菜生×火寺バジル×acOlaSia コラボTシャツ WHITE
54499 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 キャップ
60027 acOlaSia ロゴ シャワーサンダル
50720 悲撃のヒロイン症候群×acOlaSia ゲキクロ・コラボ・Tシャツ WHITE
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
54498 【バンドリ!×ゲキクロ第1弾復刻】acOlaSia×今井リサコラボ 限定 Tシャツ
55754 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 ニットキャップ
69371 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・バケットハット BLUE
69372 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・バケットハット RED
50208 acOlaSia from煙仄 WHITE
50209 acOlaSia from煙仄 BLACK
55755 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 Tシャツ
37473 ゲキクロ限定 acOlaSia mOrSe BIG TEE WHITE
39494 acOlaSia BIOHAZARD COACH JACKET BLACK
39495 acOlaSia BIOHAZARD COACH JACKET WHITE
39496 acOlaSia BIOHAZARD COACH JACKET BURGUNDY
54735 acOlaSia “MONKEY BANANA” No sleeve
54730 acOlaSia “EXIT” big tee Black
54731 acOlaSia “EXIT” big tee White
54732 acOlaSia “KILL NOTICE” big tee Black
54733 acOlaSia “KILL NOTICE” big tee White
54734 acOlaSia “MONKEY BANANA” Tee
60239 acOlaSia VICTIM TEE BLACK
60240 acOlaSia VICTIM TEE WHITE
60242 acOlaSia FRIDAY BACK PRINT TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
64889 acOlaSia (アコレイジア) HUNGRY tee WHITE
64899 acOlaSia (アコレイジア) HUNGRY tee BLUE
64900 acOlaSia (アコレイジア) HUNGRY tee BLACK
50206 acOlaSia Mariyn M BLACK
68000 【BanG Dream! ×ゲキクロ 2023 ver.】ロック×acOlaSia コラボ L/S Tシャツ
55998 acOlaSia LOSING MY MIND TEE WHITE
55999 acOlaSia LOSING MY MIND TEE BLACK
56000 acOlaSia MARLBONALD TEE WHITE
56001 acOlaSia MARLBONALD TEE BLACK
56083 acOlaSia SKULL BATTERY tee white
56084 acOlaSia SKULL BATTERY tee black
56085 acOlaSia SKULL SKATE tee white
56086 acOlaSia SKULL SKATE tee black
69166 acOlaSia (アコレイジア)Melancholy Twins tee Black
69167 acOlaSia (アコレイジア)Melancholy Twins tee White
69168 acOlaSia (アコレイジア)Thanatos tee Black
69169 acOlaSia (アコレイジア)Thanatos tee White
51695 acOlaSia LUXURY L/S BLACK
51696 acOlaSia LUXURY L/S WHITE
51697 acOlaSia REAPER L/S BLACK
51698 acOlaSia DELETE L/S BLACK
52419 acOlaSia Biohazard ロンT RED
52420 acOlaSia Biohazard ロンT GREEN
52421 acOlaSia Biohazard ロンT YELLOW
52422 acOlaSia Biohazard ロンT ORANGE
52973 acOlaSia DDD L/S
52976 acOlaSia ボディバッグ
54129 acOlaSia ENCHANT MARROW INSTILL L/S