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 =326
)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-19 11:31:27')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
62584 MARILYN MANSON LOGO BACKPACK
70778 NineMicrophones (ナインマイクロフォンズ) DUCK KNAPSACK BLACK
69985 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM 防水 BACK PACK
62576 METALLICA FADE TO BLACK DAYPACK BACKPACK
68943 gibous(ギボス) butterfly rucksack
65830 NieR (ニーア) 7POCKET 3リボン大容量BACKPACK
64175 over print (オーバープリント) BACK PACK *PACKING (orange)
62593 MY CHEMICAL ROMANCE PARADE BACKPACK
65411 【バンドリ!×ゲキクロ 第6弾復刻】NieR×広町七深コラボ 限定 Backpack
65500 NieR (ニーア) 大容量4WAY BACKPACK
62742 PUNK DRUNKERS あいつロールトップ バックパック - BLACK
64902 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) スライム BACKPACK (黄金比サイズ) DOKU
62162 Subciety (サブサエティ) TRIP BACK PACK KHAKI
64173 over print (オーバープリント) BACK PACK *PACKING (black)
62594 AC/DC POWER UP DAYPACK BACKPACK
62592 IRON MAIDEN TROOPER BACKPACK
62575 SLAYER REPEATED BACKPACK
62175 KILL STAR Ethos Backpack
60824 (2)YOU×GoneR×GEKIROCK CLOTHING コラボ・バックパック
60138 SPRAY GROUND SG ALL DAY SAVVY CROSSBODY
57975 【バンドリ!×ゲキクロ 第6弾】NieR×広町七深コラボ 限定 Backpack
58672 KILL STAR CLOTHING Vlad Backpack
58492 RUDIE'S (ルーディーズ) SPARK BACKPACK NAVY
58493 RUDIE'S (ルーディーズ) SPARK BACKPACK BLACK
58297 KILL STAR CLOTHING Unholy Sabbath Backpack
55701 RIP DESIGN WORXX オリジナルバックパック C.HANDLE with CARE(取扱注意)
55700 RIP DESIGN WORXX オリジナルバックパック B.BOLD LOGO(ネオンエロー)
55699 RIP DESIGN WORXX オリジナルバックパック A.ST LOGO(スタンダード)
55315 NieR (ニーア) MINI BACKPACK【NieR PIN】
55316 NieR (ニーア) 総柄BACKPACK【HEART BEAT】
8092 SPRAY GROUND 7TH WONDER DELUXE BACKPACK
12324 SPRAY GROUND ADVISORY BACKPACK
12865 ROLLING CRADLE RC DAYPACK Laundry
13224 SPRAY GROUND $TASHED MONEY LEOPARD POLYESTER
13671 RUDIE'S SPARK EASY DAYPACK GREEN/YELLOW/BLACK
13694 SPRAY GROUND PIXEL GAME OVER RED
14187 DISTURBIA CLOTHING ALL-SEEING BACKPACK
14379 KILL STAR CLOTHING OCCULT BACKPACK [B]
16520 KILL STAR CLOTHING PLZDIE BACKPACK
16521 KILL STAR CLOTHING VULTURE BACKPACK [B]
16522 KILL STAR CLOTHING Tartan Backpack B/R
16625 DEADHEARTZ ALL LOGO BACKPACK
17747 ROLLING CRADLE B X W NAPZAC / Black
18092 DISTURBIA CLOTHING Downer Canvas Backpack
18093 DISTURBIA CLOTHING Downer Canvas Tote Bag
18670 Subciety DRUM BAG-GLORIOUS- - KHAKI CAMO
18839 KILL STAR CLOTHING COZMIC DEATH BACKPACK [B]
20077 SPRAY GROUND FIRE SHARK BACKPACK
20079 SPRAY GROUND WEED SHARK BACKPACK
20084 SPRAYGROUND X SPONGEBOB RAMBOB
20085 SPRAY GROUND NIGHT CRAWLERS BACKPACK
20087 SPRAY GROUND EYENSTEIN BACKPACK
20089 SPRAY GROUND X SPONGEBOB PARTY PANTS BACKPACK
20090 SPRAY GROUND X MONEY CRABS BACKPACK
20091 SPRAYGROUND X TEENAGE MUTANT SPONGEBOB TURTLE BACK
20093 SPRAYGROUND X SOUTH PARK DEAD KENNY BACKPACK
20120 KILL STAR CLOTHING PYRAMID HANDBAG [B]
20447 PARADOX × LYSERG - COCOON BACKPACK
20585 FAMOUS STARS AND STRAPS SLICED STAR BACKPACK
21297 PARADOX × LYSERG - COCOON BACKPACK WHT
21656 DISTURBIA CLOTHING Critter Bag
21952 PUNK DRUNKERS フラップポケットリュック BLACK
21953 PUNK DRUNKERS フラップポケットリュック GRAY
22213 SPRAY GROUND HELLO REFLECTIVE BACKPACK
22214 SPRAY GROUND THE U.S.A FLAG BP
22425 KILL STAR CLOTHING (キルスター・クロージング) Dark Side Handbag
22426 KILL STAR CLOTHING(キルスター・クロージング) Sad Handbag
22427 KILL STAR CLOTHING (キルスター・クロージング) Yin Yang Handbag
22494 DROP DEAD CLOTHING (ドロップデッド・クロージング) Litter Holdall Bag
22496 DROP DEAD CLOTHING (ドロップデッド・クロージング) Litter Tote Bag
22597 MISHKA (ミシカ) MISHKA LAMOUR KEEP WATCH BACKPACK(BLUE)
22845 PUNK DRUNKERS トートリュック BLACK
23216 Subciety (サブサエティ) MESSENGER BAG-GLORIOUS- BLACK
23745 Subciety (サブサエティ) 2WAY TOTE BAG-VIC.- BLACK
24208 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Black
24210 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Black-Yellow
24211 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Orange
24212 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Black
24333 SILLENT FROM ME SIN -Back Pack- BLACK
24334 SILLENT FROM ME SIN -Back Pack- WHITE
24336 KILL STAR CLOTHING (キルスター・クロージング) SO GOTH HANDBAG
24390 DISTURBIA CLOTHING EYE BACKPACK
26478 DEADHEARTZ DAY PACK BLK
26517 PUNK DRUNKERS ビアリュック BLACK
26518 PUNK DRUNKERS ビアリュック KHAKI
27323 Zephyren (ゼファレン) WAIST BAG -VISIONARY- BLACK
27325 Zephyren (ゼファレン) WAIST BAG -VISIONARY- GREEN
27326 Zephyren (ゼファレン) WAIST BAG -VISIONARY- NAVY
27503 KILL STAR CLOTHING (キルスター・クロージング) Kylie Kills Handbag [B]
27523 KILL STAR CLOTHING (キルスター・クロージング) Damsel Velvet Backpack [B]
27741 ANIMALIA AN16A-AC16 DUCK TOTE #001 NATURAL
28003 SPRAY GROUND HEXAGON MESH CARGO BLK
28008 SPRAY GROUND GOLD DRIPS RECON
28009 SPRAY GROUND LEOPARD DRIPS RECON
28010 SPRAY GROUND MINI MARVEL SPIDEY KICK
28015 SPRAY GROUND RED WING RECON
28016 SPRAY GROUND HEXAGON MESH CARGO RED
28017 SPRAY GROUND GREY KNIT CARGO
28156 KILL STAR CLOTHING (キルスター・クロージング) Ritual Ring Messenger Bag [B]
28158 KILL STAR CLOTHING (キルスター・クロージング) Ritual Ring Backpack [B]
28159 KILL STAR CLOTHING (キルスター・クロージング) Ritual Ring Backpack [C]
28505 MISHKA(ミシカ) ALL OVER BACK PACK
28507 MISHKA(ミシカ) KEEP WATCH BACK PACK
28975 PUNK DRUNKERS ランドセリュック BLACK
28977 PUNK DRUNKERS ランドセリュック GRAY
29107 KILL STAR CLOTHING (キルスター・クロージング) C U In Paradise Backpack [MULTI]
30044 KILL STAR CLOTHING Morgan Mini Backpack [B]
30067 DISTURBIA CLOTHING Oracle Mini Back Pack
32269 MISHKA (ミシカ) MSS173111 LOGO BELT BACK PACK
32270 MISHKA (ミシカ) MSS173107 PATCH BACK PACK
32291 SPRAY GROUND MUTANT SHARK MOUTH
32385 SPRAY GROUND WHITE FIRE MONEY
32404 KILL STAR CLOTHING Tarot Backpack [B]
32476 PUNK DRUNKERS (パンクドランカーズ) 反区庁リュック BLACK/WHITE
34097 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK/WHITE
34098 SILLENT FROM ME LISBETH -Flip Day Pack- BLACK
34310 MISHKA (ミシカ) HSS173104 DEATH ADDER BACK PACK
34763 Subciety (サブサエティ) BACK PACK BLACK
35301 PUNK DRUNKERS クリアーリュック BLACK
35523 DEADHEARTZ MMXVII DAY PACK BLACK