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 03:18:38')
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 360, 120
29756 SABBAT13 RESURGENT ZIP-PARKA (RD)
29948 SABBAT13 MESSAGE from IGOR L/L ZIP-PARKA GRAY
32279 SABBAT13 S-BONE VARSITY JKT (BK)
32280 SABBAT13 S-BONE VARSITY JKT (NV)
32281 SABBAT13 S-BONE VARSITY JKT (BUR)
32282 SABBAT13 IGOR L/L HOOD NEL SHIRTS (BL)
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
32443 SABBAT13 SKATE "THING" L/S T BLACK
32444 SABBAT13 SKATE "THING" L/S T WHITE
32445 SABBAT13 LIFE L/S T BLACK
32446 SABBAT13 LIFE L/S T WHITE
32447 SABBAT13 DYING 2WAY TOTE BAG BLACK
32448 SABBAT13 DYING 2WAY TOTE BAG NATURAL
32449 SABBAT13 DYING 2WAY TOTE BAG NAVY
34004 SABBAT13 13X-BONE T (WH)
34005 SABBAT13 13X-BONE T (BK)
34209 SABBAT13 MORTAL OX S/S SHIRTS (WH)
34210 SABBAT13 DYING "OFFICER" T (BK)
34211 SABBAT13 DYING "OFFICER" T (WH)
34215 SABBAT13 DYING "BURGLAR" T (BK)
34216 SABBAT13 DYING "BURGLAR" T (WH)
34218 SABBAT13 FEEL WEIRD BIG T (BK)
34220 SABBAT13 FEEL WEIRD BIG T (WH)
34222 SABBAT13 FEEL WEIRD BIG T (GY)
34226 SABBAT13 S-BONE CRASH SKINNY (BL)
34227 SABBAT13 S-BONE CRASH SKINNY (BK)
34228 SABBAT1313X-BONE 7/S RAGLAN T (WH)
34229 SABBAT13 13X-BONE 7/S RAGLAN T (GY)
34230 SABBAT13 S-BONE 7/S RAGLAN T (WH)
34231 SABBAT13 S-BONE 7/S RAGLAN T (GY)
34376 SABBAT13 WEIRD THINGS S/S SHIRTS (BK)
34377 SABBAT13 WEIRD THINGS S/S SHIRTS (WH)
34378 SABBAT13 IGOR CHECK S/S SHIRTS (BK)
34379 SABBAT13 IGOR CHECK S/S SHIRTS (BL)
34380 SABBAT13 IGOR CHECK S/S SHIRTS (BR)
34937 SABBAT13 MATURE MODS COAT (ブラック) BLK
34938 SABBAT13 MATURE MODS COAT (オリーブ) OLIVE
34939 SABBAT13 SKULK HOOD JKT(ブラック) BLK
34940 SABBAT13 SKULK HOOD JKT(カモ) CAMO
34941 SABBAT13 REAPER SUKAJAN (ブラック) BLACK
34942 SABBAT13 REAPER SUKAJAN (ネイビー) NAVY
34944 SABBAT13 REAPER SWING TOP JKT (ネイビー) NABY
34945 SABBAT13 S?BONE COACH JKT (ブラック) BLACK
34946 SABBAT13 S?BONE COACH JKT (バーガンディ) BURGUNDY
34947 SABBAT13 S‐BONE KNIT CARDIGAN (ブラック) BLACK
34948 SABBAT13 S‐BONE KNIT CARDIGAN (オリーブ) OLIVE
34949 SABBAT13 S‐BONE KNIT CARDIGAN (マスタード) MASTARD
34950 SABBAT13 BEAST BOA ZIP HOODIE (ブラック) BLACK
34951 SABBAT13 BEAST BOA ZIP HOODIE (ベージュ) BEIGE
34952 SABBAT13 BEAST BOA SWEAT (ブラック) BLACK
34954 SABBAT13 GLORY NEL SHIRTS (ブルー) BLUE
34955 SABBAT13 GLORY NEL SHIRTS (グレー) GRAY
34956 SABBAT13 GLORY BORDER L/S T (ブラック) BLACK
34957 SABBAT13 GLORY BORDER L/S T (ホワイト) WHITE
34958 SABBAT13 CAMO POCKET L/S T (ブラック) BLACK
34959 SABBAT13 CAMO POCKET L/S T WHITE
34960 SABBAT13 CAMO POCKET L/S T GRAY
34961 SABBAT13 S-BONE ZIP HOODIE (ブラック) BLACK
34963 SABBAT13 MORTAL ZIP HOODIE (ブラック) BLACK
34964 SABBAT13 MORTAL ZIP HOODIE (グレー) GRAY
34965 SABBAT13 MORTAL ZIP HOODIE (バーガンディ) BURGUNDY
34966 SABBAT13 JANKEN HOODIE (ブラック) BLACK
34967 SABBAT13 JANKEN HOODIE (ホワイト) WHITE
34968 SABBAT13 JANKEN HOODIE (グレー) GRAY
34969 SABBAT13 GASP HOODIE (ブラック) BLACK
34970 SABBAT13 GASP HOODIE (ホワイト) WHITE
34971 SABBAT13 GASP HOODIE (グレー) GRAY
34972 SABBAT13 SKATE ""THING"" HOODIE(ブラック) BLACK
34973 SABBAT13 SKATE ""THING"" HOODIE(ホワイト) WHITE
34974 SABBAT13 MORTAL SWEAT (ブラック) BLACK
34975 SABBAT13 MORTAL SWEAT (ホワイト) WHITE
34976 SABBAT13 "DYING OFFICER" SWEAT BLACK
34977 SABBAT13 DYING "BURGLAR" SWEAT GRAY
34978 SABBAT13 DYING "BURGLAR" SWEAT BLACK
34979 SABBAT13 DYING "DYING OFFICER" SWEAT GRAY
34980 SABBAT13 JANKEN L/S T (ブラック) BLACK
34981 SABBAT13 JANKEN L/S T (ホワイト) WHITE
34985 SABBAT13 S-BONE JOGGER PANTS (オリーブ) OLIVE
34986 SABBAT13 FLABBY CORDUROY CAP (ブラック) BLACK
34987 SABBAT13 FLABBY CORDUROY CAP (ネイビー) NAVY
34988 SABBAT13 FLABBY CORDUROY CAP (マスタード) WHITE
34989 SABBAT13 CABLE KNIT CAP (ブラック) BLACK
34990 SABBAT13 CABLE KNIT CAP (バーガンディ) BURGUNDY
34991 SABBAT13 CABLE KNIT CAP (マスタード) MASTARD
34992 SABBAT13 DISPORT WAIST BAG (ブラック) BLACK
34993 SABBAT13 DISPORT WAIST BAG (カモ) CAMO
34994 SABBAT13 IMP WALLET (ブラック) BLACK
34995 SABBAT13 IMP WALLET (カモ) CAMO
34996 SABBAT13 BEAST iPhone CASE (ブラック) BLACK
34997 SABBAT13 BEAST iPhone CASE (ホワイト) WHITE
35076 SABBAT13 S-BONE CARGO SHORTS タイガーカモ
36546 CSABBAT13 RYPT LOGO TEE WHITE
36547 SABBAT13 CRYPT LOGO TEE BLACK
36548 SABBAT13 HALF DEATH TEE WHITE
36549 SABBAT13 HALF DEATH TEE BLACK
36550 SABBAT13 BEAST TEE WHITE
36551 SABBAT13 BEAST TEE BLACK
36552 SABBAT13 666 BIG TEE WHITE
36553 SABBAT13 666 BIG TEE BLACK
37242 SABBAT13 S-BONE EASY DENIM BLACK
37243 SABBAT13 S-BONE EASY DENIM INDIGO
39513 SABBAT13 PATCH MILITARY BIG JKT (CAMO)
39514 SABBAT13 HAND OF GLORY ZIP HOODIE (BK)
39516 SABBAT13 HAND OF GLORY ZIP HOODIE (GY)
39517 SABBAT13 HAND OF GLORY L/S T (BK)
39518 SABBAT13 HAND OF GLORY L/S T (WH)
39519 SABBAT13 HAND OF GLORY L/S T (PK)
39782 SABBAT13 CALL OF THE DEAD L/S T (BK)
39783 SABBAT13 CALL OF THE DEAD L/S T (WH)
39784 SABBAT13 CALL OF THE DEAD L/S T (ORG)
39785 SABBAT13 BLOOD PAINT ANKLE CHINO (BE)
39786 SABBAT13 BLOOD PAINT ANKLE CHINO (BK)
39787 SABBAT13 CALL OF THE DEAD TOTE BAG BLACK
39788 SABBAT13 CALL OF THE DEAD TOTE BAG BEIGE
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)
40428 SABBAT13 CRYPT HOODIE (BK)