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 >= '2021-02-28 09:38:18')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35558 BRING ME THE HORIZON BANNER HOODIE
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
57234 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: HEX PHSH COVER
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58066 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT PHOTO
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
56378 Subciety KEY CHAIN BRACELET - SILVER
56342 NineMicrophones NECKLACE-Lips and Microphone-
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58047 【予約商品】XrossOver pullOver
58048 【予約商品】XrossOver BigParka
58050 【予約商品】XrossOverBig SilhouetteT (Black)
58051 【予約商品】XrossOverBig SilhouetteT (White)
58052 【予約商品】XrossOver XOver logoT (Black)
58053 【予約商品】XrossOver XOver logoT (White)
58054 【予約商品】XrossOver Bucket Hat (White)
58055 【予約商品】XrossOver XOver logoBug
58043 ROLLING CRADLE RIP-STOP JACKET BLACK
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
58045 ROLLING CRADLE RIP-STOP PANTS BLUE
58046 ROLLING CRADLE RIP-STOP PANTS BLACK
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
58022 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BEIGE
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
58041 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - ORANGE
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
58039 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - PINK
58040 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - BLACK
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58025 TOY MACHINE ED MONSTER PRINT LONG TEE - WHITE
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58027 TOY MACHINE OG MONSTER PRINT LONG TEE - WHITE
58028 TOY MACHINE OG MONSTER PRINT LONG TEE - BLACK
58029 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - L. PINK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58037 TOY MACHINE BACKET HAT-BLACK
58038 TOY MACHINE BACKET HAT-BLUE
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
58015 ROLLING CRADLE FIRE HOODIE / PURPLE
58016 ROLLING CRADLE FIRE SOX / WHITE
58017 ROLLING CRADLE FIRE SOX / BLACK
58018 THRASHER TH91292 T-Shirt BLACK
58019 THRASHER TH91292 T-Shirt WHITE
58020 THRASHER TH91292 T-Shirt PINK
58021 THRASHER TH91292 T-Shirt GREEN
57994 【予約商品】GoneR GR28LS001 Rainbow Rose L/S T-Shirts Black
57993 【予約商品】GoneR GR28LS001 Rainbow Rose L/S T-Shirts Forest
57991 【予約商品】GoneR GR28LS001 Rainbow Rose L/S T-Shirts Sand
57990 【予約商品】GoneR GR28LS001 Rainbow Rose L/S T-Shirts White
57992 【予約商品】GoneR GR28LS001 Rainbow Rose L/S T-Shirts Safety Green
57980 【予約商品】GoneR GR28CT001 Rose Hand T-Shirts White
57981 【予約商品】GoneR GR28CT001 Rose Hand T-Shirts Vegas Gold
57982 【予約商品】GoneR GR28CT001 Rose Hand T-Shirts Light Pink
57983 【予約商品】GoneR GR28CT001 Rose Hand T-Shirts Dark Chocolate
57984 【予約商品】GoneR GR28CT001 Rose Hand T-Shirts Black
57985 【予約商品】GoneR GR28CT002 Tie-dye Line T-Shirts White
57986 【予約商品】GoneR GR28CT002 Tie-dye Line T-Shirts Vegas Gold
57987 【予約商品】GoneR GR28CT002 Tie-dye Line T-Shirts Light Pink
57988 【予約商品】GoneR GR28CT002 Tie-dye Line T-Shirts Dark Chocolate
57989 【予約商品】GoneR GR28CT002 Tie-dye Line T-Shirts Black
57995 【予約商品】GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts White
57996 【予約商品】GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Sand
57997 【予約商品】GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Safety Green
57998 【予約商品】GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Forest
57999 【予約商品】GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts Black
58000 【予約商品】GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Sand
58004 【予約商品】GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Forest
58005 【予約商品】GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Black
58006 【予約商品】GoneR GR28LS004 Tie-dye Cactus Flower L/S T-Shirts White
58007 【予約商品】GoneR-La Neta- GRL03PK001 Altar Photo Parka Light Pink
58008 【予約商品】GoneR-La Neta- GRL03PK001 Altar Photo Parka Royal Blue
58009 【予約商品】GoneR-La Neta- GRL03PK001 Altar Photo Parka Burgundy
58010 【予約商品】GoneR-La Neta- GRL03PK001 Altar Photo Parka Heather Grey
58011 【予約商品】GoneR-La Neta- GRL03PK001 Altar Photo Parka Black
58012 【予約商品】GoneR GR28AC001 Jacquard Big Bath Towel
57028 VIRGO Perfection 21 (3/4) 「B.S」 BLACK
57026 VIRGO Perfection 21 (3/4) 「B.S」 WHITE
57027 VIRGO Perfection 21 (3/4) 「B.S」 RED
57976 TRAVAS TOKYO【トラバストーキョー】エンジェルハートプルオーバーパーカー BLACK
57977 TRAVAS TOKYO【トラバストーキョー】エンジェルハートプルオーバーパーカー WHITE
57978 TRAVAS TOKYO【トラバストーキョー】ファンシークラゲプリントモアビッグパーカー Black×Red
57979 TRAVAS TOKYO【トラバストーキョー】ファンシークラゲプリントモアビッグパーカー Black×Blue
58001 RUDIE'S GOOD VIBRATION HOOD SWEAT BLACK
58002 RUDIE'S GOOD VIBRATION HOOD SWEAT BLUE
58003 RUDIE'S GOOD VIBRATION HOOD SWEAT PINK
57032 VIRGO Upright zip swt WHITE
57033 VIRGO Upright zip swt NAVY
57034 VIRGO Upright zip swt BLACK
56613 PUNK DRUNKERS [PDSxTEKKEN]吉光JKT - BLACK
56609 PUNK DRUNKERS 大統領TEE - WHITE
56623 PUNK DRUNKERS CAMOカーゴパンツ - KHAKI
57840 【予約商品】ゲキクロ限定カラー DI:VISION HELLOW LS TEE WHITE×PINK
57841 【予約商品】ゲキクロ限定カラー DI:VISION HELLOW LS TEE BLACK×PINK
57830 【予約商品】DI:VISION UNCHAINED MA1 JKT BLACK
57831 【予約商品】DI:VISION UNCHAINED MA1 JKT OLIVE
57832 【予約商品】DI:VISION INFLAME COACH JKT
57833 【予約商品】DI:VISION SMD COACH JKT
57834 【予約商品】DI:VISION UNRAVEL HOODIE BLACK
57835 【予約商品】DI:VISION MYOB HOODIE BLACK
57836 【予約商品】DI:VISION UNRAVEL HOODIE WHITE
57837 【予約商品】DI:VISION MYOB HOODIE WHITE
57838 【予約商品】DI:VISION HELLOW LS TEE BLACK
57839 【予約商品】DI:VISION HELLOW LS TEE WHITE
57842 【予約商品】DI:VISION SMD LS TEE BLACK
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/
--------
mb_parse_str
Array
(
[work] => new_arrival
[/] =>
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&/