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 =1
)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 >= '2021-01-16 05:24:05')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
35590 BRING ME THE HORIZON COLOURS T-SHIRTS
45659 BRING ME THE HORIZON AMO SYMBOLS TEE
45950 BRING ME THE HORIZON WONDERFUL LIFE BLACK
45949 BRING ME THE HORIZON HEXAGRAM AMO SMALL YELLOW
45951 BRING ME THE HORIZON PLASMA TEE BLACK
50311 BRING ME THE HORIZON CROOKED YOUNG (APPLIQUE MOTIFS)
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
57217 【予約商品】倉澤雪乃(Aphrodite)×アマツカミ BIRTHDAY記念Tシャツ
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57089 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T BLACK
57090 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T WHITE
55759 【バンドリ!×ゲキクロ 第2弾復刻】KAVANE Clothing×レイヤ コラボ 限定 Tシャツ
55755 【バンドリ!×ゲキクロ 第2弾復刻】acOlaSia×ロック コラボ 限定 Tシャツ
55751 【バンドリ!×ゲキクロ 第2弾復刻】UNUSUAL×マスキング コラボ 限定 Tシャツ
55747 【バンドリ!×ゲキクロ 第2弾復刻】DI:VISION×パレオ コラボ 限定 Tシャツ
55743 【バンドリ!×ゲキクロ 第2弾復刻】RUDIE'S×チュチュ コラボ 限定 Tシャツ
4598 NIRVANA SMILE T-Shirt
10233 METALLICA DORRIS T-Shirt
52713 BABYMETAL LOGO TEE
52908 KORN UNISEX TEE: SCRATCHED TYPE (BACK PRINT)
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
56810 AC/DC UNISEX TEE: ANGUS STATUE
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
56812 AC/DC UNISEX TEE: THOSE ABOUT TO ROCK
56822 BILLIE EILISH UNISEX TEE: SWEET DREAMS
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
56014 アマツカミ 「絶望感」T-shirts Purple
56016 アマツカミ 「永眠」T-shirts Purple
56209 Anti Social Social Club Read Receipts Black Tee
56210 Anti Social Social Club Enrique White Vneck Tee
56213 Anti Social Social Club Headrush All Over White Tee
56240 MAGICAL MOSH MISFITS MxMxM TEE WH/BK
56241 MAGICAL MOSH MISFITS MxMxM TEE BK/WH
56242 MAGICAL MOSH MISFITS MxMxM TEE BK/GRN
56244 MAGICAL MOSH MISFITS MAGICAL MOSH MISFITS TEE WHITE
56245 MAGICAL MOSH MISFITS MAGICAL MOSH MISFITS TEE BLACK
56246 MAGICAL MOSH MISFITS MAGICAL MOSH MISFITS TEE GREEN
56247 MAGICAL MOSH MISFITS MAGICAL MOSH MISFITS TEE PINK
55809 PUNK DRUNKERS 顔コンペTEE'20 - WHITE
55810 PUNK DRUNKERS 顔コンペTEE'20 - SAND.KHAKI
56085 acOlaSia SKULL SKATE tee white
55850 GoneR × MODERNPIRATES Collaboration T-Shirts White
55851 GoneR × MODERNPIRATES Collaboration T-Shirts Black
55321 RUDIE'S x CRAYON SHINCHAN GUITAR-T WHITE
55322 RUDIE'S x CRAYON SHINCHAN GUITAR-T BLACK
56036 SAMURAI CORE SR-TE-002D 遠慮なく外出したいなぁ TEE WHITE
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
56040 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE YELLOW
15221 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- WHT
15222 ZEPHYREN (ゼファレン) TEE S/S -VISIONARY- BLK×WHT
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
15226 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- BLK×WHT
42101 Zephyren(ゼファレン) S/S TEE -BEYOND- STONE
55047 Zephyren(ゼファレン)S/S TEE - VISIONARY - SKY
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
55066 Zephyren(ゼファレン)S/S TEE - fiat lux - WHITE
55067 Zephyren(ゼファレン)S/S TEE - fiat lux - BLACK
28810 RUDIE'S PHAT-T BLK
55999 acOlaSia LOSING MY MIND TEE BLACK
55957 Gluttonous Slaughter (グラトナス・スローター) The Gluttonous Slaughter T-shirt Purple
54569 アマツカミ 棘薔薇/Rose Needle T-Shirts Black
54568 アマツカミ 棘薔薇/Rose Needle T-Shirts White
54574 アマツカミ 牡丹 S/S White
24330 RUDIE'S DRAWING-T WHITE
55847 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO SS TEE WHITE
55554 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE KHAKI
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
55559 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE BLACK
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54479 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 Tシャツ
54484 【バンドリ!×ゲキクロ第1弾復刻】RIP DESIGN WORXX×市ヶ谷有咲コラボ 限定 Tシャツ
55805 SUBLIME×SULLEN TRIPPIN STANDARD Tee
55806 SUBLIME×SULLEN LIVIN DIZZY STANDARD Tee
55735 Anti Social Social Club ASHTON BLACK TEE
55717 AC/DC UNISEX TEE: LOGO (RETAIL PACK)
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55719 ALL TIME LOW UNISEX TEE: DA BOMB (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
55720 BLACK SABBATH UNISEX TEE: WAVY LOGO VINTAGE (RETAIL PACK)
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
13970 CHILDREN OF BODOM DEATH WANTS YOU T-Shirt
37811 ALL TIME LOW UNISEX TEE: SCRATCH
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
52902 MY CHEMICAL ROMANCE UNISEX TEE: RACEWAY
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
54742 EVANESCENCE UNISEX TEE: CLASSIC LOGO
55728 NIRVANA UNISEX TEE: YELLOW SMILEY
55730 OASIS UNISEX TEE: DECCA LOGO WHITE
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
55702 RIP DESIGN WORXX ラウダーロゴビッグプリントTシャツ WHITE
55704 RIP DESIGN WORXX ラウダーロゴビッグプリントTシャツ ALL BLACK
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
55674 RIP DESIGN WORXX ディスグースマスクTシャツ BLACK
55675 RIP DESIGN WORXX ディスグースマスクTシャツ GRAY
55677 RIP DESIGN WORXX ディスグースマスクTシャツ GREEN
55678 RIP DESIGN WORXX ディスグースマスクTシャツ YELLOW
55679 RIP DESIGN WORXX アンノウンクラウンTシャツ BLACK
55680 RIP DESIGN WORXX アンノウンクラウンTシャツ WHITE
55681 RIP DESIGN WORXX シャドウイーグルTシャツ BLACK
52912 FILA × STAPLE FM9889 T-SHIRTS BLACK
52913 FILA × STAPLE FM9889 T-SHIRTS WHITE
46885 mnml(ミニマル) STRIPED DROP TEE BLACK/WHITE
49872 PSYCHOLOGICAL METAMORPHOSIS PLMP BOX TEE YELLOW
48520 GoneR GR21CT002 Grave Rose T-Shirts Red
47642 SANTA CRUZ CLASSIC DOT REGULAR S/S T-SHIRT WHITE
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
15922 BLACK CRAFT Protection Moth
18048 AUGUST BURNS RED HEARTS FILLED
34513 IRON MAIDEN New YorkT-Shirt
35288 SLIPKNOT Antennas to Hell
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 1
[size] => 2XL
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=1&size=2XL
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 1
[size] => 2XL
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=1&size=2XL