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-04-23 03:09:25')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
58582 TOY MACHINE SECT EYE MESH CAP ORANGE
58583 TOY MACHINE SECT EYE MESH CAP BLACK
58584 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS PINK
58585 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS KHAKI
58586 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS BLACK
58587 TOY MACHINE OG MONSTER SS WIDE TEE WHITE
58588 TOY MACHINE OG MONSTER SS WIDE TEE BLACK
58589 TOY MACHINE TOYMONSTER EMB SS TEE WHITE
58590 TOY MACHINE TOYMONSTER EMB SS TEE BLACK
58591 TOY MACHINE CHARACTERS SS TEE PINK
58592 TOY MACHINE CHARACTERS SS TEE WHITE
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
56505 STAPLE×Hello Kitty Logos L/S Tee WHITE
52552 DISTURBIA CLOTHING Nihilist Boot
50365 ANIMALIA AN19M-AC02 ROPE-BELT BLACK
56874 SILLENT FROM ME EVIDENCE -Extra Wide Poncho- GRAY
49608 DISTURBIA CLOTHING Molly Jeans
42562 DISTURBIA CLOTHING Lolita Platform Shoes
51650 ANIMALIA AN19W-CP03 BOONIE BERET #005 BLACK
1661 Subciety METAL NECKLACE -Guadalupe- A.SILVER
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
51677 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP WHITE
54451 MISHKA(ミシカ) MSS200906 SHORTS
57406 SALUTE Cactus flower flame necklace
57074 SLIGHTLY NUMB×Kappa shoes BLACK
38581 DISTURBIA CLOTHING NOVA BLOW OUT JEAN
57789 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / BLACK
57795 SALUTE EVAE* X BLACKLUX NECKLACE
51494 MISHKA MSS201002W31 SKIRT INDIGO
57107 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BLACK
56087 FILA F04140125 Barricade XT 97 BLACK
55640 Anti Social Social Club WEIRD CAP BLACK
27889 DISTURBIA CLOTHING (ディスタービア・クロージング) Slay Necklace
56567 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT PURPLE
40957 DISTURBIA CLOTHING Peggy Stud Trousers
45420 DISTURBIA CLOTHING Creep Shoe
56278 RUDIE'S BOTANICAL PHAT HOOD SWEAT WHITE
53878 MISHKA(ミシカ) MSS200904 SHORTS
55645 Anti Social Social Club BROKEN ANKLE WHITE SOCKS
57073 SLIGHTLY NUMB×Kappa shoes WHITE
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
50649 CHORD NUMBER EIGHT CHA1-01K5-AC09 CROSS NECKLACE
56122 N.B.O. BLUE FLARED DENIM PANTS
56323 NineMicrophones Lipsand Microphone S/S GRAY
55403 VIRGO ROCKET LONG SHIRTS - WHITE
58470 【予約商品】やね×GALFY×GEKIROCK CLOTHING やね卍SET UP “ラブ&ピースの使者”
58469 【予約商品】やね×GALFY×GEKIROCK CLOTHING やね卍SET UP “元カノに似てるって言うな”
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
57816 四星球×ゲキクロ 限定コラボ・パーカー グレー
57817 四星球×ゲキクロ 限定コラボ・パーカー ピンク
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
57819 四星球×ゲキクロ 限定コラボ・ネックストラップ&ホルダー
58573 MISHKA(ミシカ) M21000005 T-Shirt
58574 MISHKA(ミシカ) M21000029 T-Shirt
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
58577 MISHKA(ミシカ) M21000072 T-Shirt PURPLE
58578 MISHKA(ミシカ) M21000072 T-Shirt BLACK
58131 MISHKA M21000007 T-Shirt Yellow
58130 MISHKA M21000007 T-Shirt Green
58129 MISHKA M21000007 T-Shirt Black
58128 MISHKA M21000011 T-Shirt White
58127 MISHKA M21000011 T-Shirt Black
58132 MISHKA M21000066 T-Shirt White
58133 MISHKA M21000066 T-Shirt Yellow
57362 MISHKA M21000059 T-Shirt YELLOW
57363 MISHKA M21000059 T-Shirt ORANGE
57361 MISHKA M21000059 T-Shirt BLACK
57359 MISHKA M21000013 T-Shirt WHITE
57360 MISHKA M21000013 T-Shirt GREEN
58126 MISHKA M21000006 T-Shirt Beige
58125 MISHKA M21000006 T-Shirt Black
58579 MISHKA(ミシカ) M21000204 S/S Shirt
58580 MISHKA(ミシカ) M21000208 S/S Shirt
57367 MISHKA M21000205 S/S Shirt
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58571 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE BLACK
58581 MISHKA(ミシカ) M21000836 Shorts
57892 Subciety Robin S/S- WHITE
57893 Subciety Robin S/S- BLACK
57864 Subciety METRO HAT- BLACK
58568 Subciety (サブサエティ) SOCKS WHITE
58567 Subciety (サブサエティ) SOCKS BLACK
52828 Subciety CAUCHO BELT BLACK
56998 VIRGO Dolman cross V WHITE
56999 VIRGO Dolman cross V BLACK
58570 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP NAVY
58569 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP BLACK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57453 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE CHECK
57455 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - NAVY CHECK
57456 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - RED CHECK
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
57468 Zephyren(ゼファレン) DOLMAN BIG TEE S/S WHITE / NEVER say NEVER
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
57496 Zephyren(ゼファレン) SWITCHING TEE BLACK / FLOWER
57495 Zephyren(ゼファレン) SWITCHING TEE BLACK / PYTHON
57494 Zephyren(ゼファレン) SWITCHING TEE BLACK / BORDER
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
57590 Zephyren(ゼファレン) SAROUEL SWEAT SHORTS - 冥 - BLACK
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
35970 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BLACK
58566 【予約商品】SABBAT13 13TALED FOX T パープル
58565 【予約商品】SABBAT13 13TALED FOX T ブラック
58564 【予約商品】SABBAT13 GLUTTONY T ホワイト
58563 【予約商品】SABBAT13 GLUTTONY T ブラック
58562 【予約商品】SABBAT13 LOST PARADISE T サックス
58561 【予約商品】SABBAT13 LOST PARADISE T ブラック
58560 【予約商品】SABBAT13 WIND PRANK T ゴールド
58559 【予約商品】SABBAT13 WIND PRANK T ブラック
58557 【予約商品】SABBAT13 SUPPER T ベージュ
58558 【予約商品】SABBAT13 SUPPER T オリーブ
58556 【予約商品】SABBAT13 SUPPER T ブラック
58554 【予約商品】SABBAT13 MALUS T ホワイト
58555 【予約商品】SABBAT13 MALUS T コーラルベージュ
58553 【予約商品】SABBAT13 MALUS T ブラック
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&