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-04-28 06:56:03')
AND pc.price02 > 2727
AND price02 <= 4545
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 437)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 75
69992 SABBAT13(サバトサーティーン) SPOOK KNIT CAP GRAY
69993 SABBAT13(サバトサーティーン) SPOOK KNIT CAP MOCHA
69991 SABBAT13(サバトサーティーン) SPOOK KNIT CAP NAVY
69990 SABBAT13(サバトサーティーン) SPOOK KNIT CAP BLACK
65682 SABBAT13(サバトサーティーン) SCAPEGOAT L/S T BLACK
65604 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (BK)
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
65023 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (BG)
64504 SABBAT13(サバトサーティーン) FRIEND T (WH)
64505 SABBAT13(サバトサーティーン) FRIEND T (BK)
64146 SABBAT13(サバトサーティーン) FRIEND T (GD)
64502 SABBAT13(サバトサーティーン) GOD T (WH)
64503 SABBAT13(サバトサーティーン) GOD T (BK)
64147 SABBAT13(サバトサーティーン) STORY TELLING T (BK)
65012 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (WH)
65011 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BK)
64151 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BG)
64506 SABBAT13(サバトサーティーン) OUT GRAVE PURCE (OL)
65015 SABBAT13(サバトサーティーン) OUT GRAVE CAP(BK)
64150 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BK)
61144 SABBAT13 SPOOK CHECK SHIRTS GREEN
60707 SABBAT13 WIND PRANK HOODIE BLACK
60708 SABBAT13 WIND PRANK HOODIE BLUE
60617 SABBAT13 PARADISE LOST TOTE BAG BLACK
60618 SABBAT13 PARADISE LOST TOTE BAG BEIGE
60619 SABBAT13 PARADISE LOST COACH JKT BLACK
60620 SABBAT13 PARADISE LOST COACH JKT BEIGE
58532 SABBAT13 GHOST PURCE ベージュ
58531 SABBAT13 GHOST PURCE ブラック
58533 SABBAT13 GHOST PURCE オリーブ
57136 SABBAT13 SPOOK INSIDE T WHITE
57156 SABBAT13 GHOST CHECK SLACKS BROWN
57123 SABBAT13 BLACK HEART CHECK SHIRTS BEIGE
57128 SABBAT13 SPOOK INSIDE L/S T BLUE
57133 SABBAT13 HIDE&SEEK L/S T WHITE
55766 【バンドリ!×ゲキクロ 第2弾復刻】SABBAT13×宇田川あこコラボ 限定 キャップ
55588 SABBAT13 GHOST LOGO BELT ブラック
55589 SABBAT13 GHOST LOGO BELT レッド
55590 SABBAT13 GHOST LOGO BELT イエロー
13196 SABBAT13 Shrunken Head T-shirt PP
13650 SABBAT13×激ロック TOTE BAG & 缶バッジ4色セット
17399 SABBAT13 TITLE T-sh BK
17400 SABBAT13 TITLE T-sh GY
17404 SABBAT13 KEEP WEIRD T-sh BK
17407 SABBAT13 DEADLY T-sh BK
17408 SABBAT13 DEADLY T-sh GY
17411 SABBAT13 REBEL T-sh GR
18021 SABBAT13 WEIRD T-sh BLK
18022 SABBAT13 WEIRD T-sh NVY
18272 SABBAT13 CHEERS T-sh GRY
18279 SABBAT13 CROSS LOGO BUCKET HAT BLK
18281 SABBAT13 CROSS LOGO BUCKET HAT WHT
19088 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6plus WHITE
19089 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6+ BLACK
19090 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ BLACK
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
22172 SABBAT13 CABLE KNIT CAP BLACK
22173 SABBAT13 CABLE KNIT BURGUNDY
22174 SABBAT13 CABLE KNIT BLUE
24805 SABBAT13 IGOR BORDER T WHT
24806 SABBAT13 IGOR BORDER T GRY
24807 SABBAT13 HAND MONSTERS "VAMPIRE" T-sh BLK
24808 SABBAT13 HAND MONSTERS "VAMPIRE" T-sh WHT
24809 SABBAT13 HAND MONSTERS "FRANKEN" T-sh BLK
24810 SABBAT13 HAND MONSTERS "FRANKEN" T-sh WHT
25219 SABBAT13 iPhone6/6s・6plusCASE EERIE AD
25220 SABBAT13 iPhone6/6s CASE 13X DOT
27821 SABBAT13 RESURGENT T-sh (RD)
27822 SABBAT13 RESURGENT T-sh (YE)
27823 SABBAT13 MONSTERS T-sh (WH)
27824 SABBAT13 MONSTERS T-sh (BK)
28451 SABBAT13 ARCH LOW CAP BK
28452 SABBAT13 ARCH LOW CAP BL
28453 SABBAT13 DARK LOW CAP BL
28454 SABBAT13 DARK LOW CAP BK