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-27 04:15:20')
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 MAX(price02)
LIMIT 0, 120
13645 SABBAT13×激ロック 缶バッジ BLACK
13646 SABBAT13×激ロック 缶バッジ WHITE
13647 SABBAT13×激ロック 缶バッジ BLUE
13649 SABBAT13×激ロック 缶バッジ RED
13208 SABBAT13 PVC KEY HOLDER IGOR
40597 SABBAT13 GOOD DIE SOX BLACK
40598 SABBAT13 GOOD DIE SOX WHITE
40599 SABBAT13 GOOD DIE SOX YELLOW
40600 SABBAT13 GOOD DIE SOX GRAY
60614 SABBAT13 PARADISE LOST CAP BLACK
60615 SABBAT13 PARADISE LOST CAP BEIGE
13651 SABBAT13×激ロック 缶バッジ 4色セット
55585 SABBAT13 GHOST SOX ブラック
55586 SABBAT13 GHOST SOX ホワイト
55587 SABBAT13 GHOST SOX イエロー
58549 【予約商品】SABBAT13 GHOST POCKET T キャメル
60612 SABBAT13 CONSPIRACY L/S T WHITE
53029 SABBAT13 HODGE PODGE T BLACK
15870 SABBAT13 KNIT CAP BURGUNDY
57126 SABBAT13 SPOOK INSIDE L/S T BLACK
64145 SABBAT13(サバトサーティーン) GOD T (PK)
64148 SABBAT13(サバトサーティーン) STORY TELLING T (BG)
64149 SABBAT13(サバトサーティーン) STORY TELLING T (KH)
65014 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BG)
65021 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (GR)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
57141 SABBAT13 HIDE&SEEK T BLACK
57142 SABBAT13 HIDE&SEEK T WHITE
57151 SABBAT13 CREEPY BIG T BEIGE
58555 SABBAT13 MALUS T コーラルベージュ
58557 SABBAT13 SUPPER T ベージュ
58559 SABBAT13 WIND PRANK T ブラック
65020 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (SMOKE)
13644 SABBAT13×激ロック TOTE BAG
68393 SABBAT13(サバトサーティーン) POSTHUMOUS LUNCH BAG (BLACK)
68394 SABBAT13(サバトサーティーン) POSTHUMOUS LUNCH BAG (CAMO)
25219 SABBAT13 iPhone6/6s・6plusCASE EERIE AD
25220 SABBAT13 iPhone6/6s CASE 13X DOT
28654 SABBAT13 Message from IGOR iPhone CASE WH
28655 SABBAT13 Message from IGOR iPhone CASE BK
65682 SABBAT13(サバトサーティーン) SCAPEGOAT L/S T BLACK
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
47760 SABBAT13 CRYPT WAIST BAG BLACK
47761 SABBAT13 CRYPT WAIST BAG BROWN
54080 SABBAT13 YOKAI TRUMP POUCH (ブラック)
58531 SABBAT13 GHOST PURCE ブラック
58532 SABBAT13 GHOST PURCE ベージュ
58533 SABBAT13 GHOST PURCE オリーブ
64150 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BK)
64151 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BG)
64506 SABBAT13(サバトサーティーン) OUT GRAVE PURCE (OL)
64146 SABBAT13(サバトサーティーン) FRIEND T (GD)
65011 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BK)
65012 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (WH)
60707 SABBAT13 WIND PRANK HOODIE BLACK
60708 SABBAT13 WIND PRANK HOODIE BLUE
57136 SABBAT13 SPOOK INSIDE T WHITE
46267 SABBAT13 SBT-LT-023 G.F.G L/S T(ホワイト)
57128 SABBAT13 SPOOK INSIDE L/S T BLUE
57133 SABBAT13 HIDE&SEEK L/S T WHITE
13650 SABBAT13×激ロック TOTE BAG & 缶バッジ4色セット
22172 SABBAT13 CABLE KNIT CAP BLACK
22173 SABBAT13 CABLE KNIT BURGUNDY
22174 SABBAT13 CABLE KNIT BLUE
28451 SABBAT13 ARCH LOW CAP BK
28452 SABBAT13 ARCH LOW CAP BL
28453 SABBAT13 DARK LOW CAP BL
28454 SABBAT13 DARK LOW CAP BK
28456 SABBAT13 S-BONE LOW CAP BK
28458 SABBAT13 S-BONE LOW CAP BL
29709 SABBAT13 KNIT CAP BLACK
29710 SABBAT13 KNIT CAP BGN
29711 SABBAT13 KNIT CAP OLIVE
39787 SABBAT13 CALL OF THE DEAD TOTE BAG BLACK
39788 SABBAT13 CALL OF THE DEAD TOTE BAG BEIGE
60619 SABBAT13 PARADISE LOST COACH JKT BLACK
60620 SABBAT13 PARADISE LOST COACH JKT BEIGE
34989 SABBAT13 CABLE KNIT CAP (ブラック) BLACK
34990 SABBAT13 CABLE KNIT CAP (バーガンディ) BURGUNDY
34991 SABBAT13 CABLE KNIT CAP (マスタード) MASTARD
34996 SABBAT13 BEAST iPhone CASE (ブラック) BLACK
34997 SABBAT13 BEAST iPhone CASE (ホワイト) WHITE
39961 SABBAT13 WEIRD LOW CAP(BK)
39962 SABBAT13 WEIRD LOW CAP(WH)
39963 SABBAT13 WEIRD LOW CAP(PK)
39964 SABBAT13 666 LOW CAP(BK)
39965 SABBAT13 666 LOW CAP(WH)
40841 SABBAT13 BORN TO BE BONE LONG BELT
40842 SABBAT13 BORN TO BE BONE LONG BELT RED
40843 SABBAT13 BORN TO BE BONE LONG BELT YELLOW
46195 SABBAT13 SBT-CP-021 WITCH LOW CAP (ブラック)
46196 SABBAT13 SBT-CP-021 WITCH LOW CAP (パープル)
54115 SABBAT13 SCARE WAIST POUCH BLACK
54116 SABBAT13 SCARE WAIST POUCH GREEN
55588 SABBAT13 GHOST LOGO BELT ブラック
55589 SABBAT13 GHOST LOGO BELT レッド
55590 SABBAT13 GHOST LOGO BELT イエロー
54563 SABBAT13 GHOST CHECK S/S SHIRTS BLUE
13196 SABBAT13 Shrunken Head T-shirt PP
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
24805 SABBAT13 IGOR BORDER T WHT
24806 SABBAT13 IGOR BORDER T GRY
27821 SABBAT13 RESURGENT T-sh (RD)
27822 SABBAT13 RESURGENT T-sh (YE)
27823 SABBAT13 MONSTERS T-sh (WH)
27824 SABBAT13 MONSTERS T-sh (BK)
34004 SABBAT13 13X-BONE T (WH)
34005 SABBAT13 13X-BONE T (BK)
34210 SABBAT13 DYING "OFFICER" T (BK)