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-01-17 03:17:10')
AND pc.stock > 0
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
55893 SALUTE FLOWER ANARCHY BRACELET
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
57244 mnml(ミニマル) TRACK PANTS RED
57179 acOlaSia Camphell's コーチジャケット RED
57189 acOlaSia SMILE MOON BEANIE RED
57194 acOlaSia LOGO BEANIE RED
57197 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE RED
56326 NineMicrophones NM/CS S/S BURGUNDY
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
56895 SALUTE CACTUS PRINTER HOODIE
57069 SALUTE CACTUS PRINTER JEANS
56942 TRAVAS TOKYO Print check shirts Red
56927 SLEEPING TABLET SAD [ HOODED SWEAT ] RED
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
54917 PUNK DRUNKERS [PDSxキン肉マン]超人総柄ハイブリットタオル - RED
56105 ROLLING CRADLE BOUCLE TURTLE NECK / PINK
47466 MUSIC SAVED MY LIFE (MSML) M1K1T-AC02 ZIP LEATHER WALLET RED
56089 ROLLING CRADLE COMBI VEST / RED
54234 Subciety BANDANA QUILTING JKT BLACK/RED
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
55625 SABBAT13 PENNYWISE HOODIE レッド
56204 Anti Social Social Club Headrush All Over White Hoodie
56206 Anti Social Social Club Don’t Red Hoodie
56213 Anti Social Social Club Headrush All Over White Tee
56215 Anti Social Social Club Headrush Cap
56201 CIVARIZE【シヴァーライズ】フェザーヤーンプルオーバーロングニット Black×Red
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
55816 PUNK DRUNKERS PDS総柄マスク / 常夏 - 常夏
55878 GoneR GR26ZP001 Rose Photo Zip Parka Burgundy
55034 Zephyren(ゼファレン)KNIT CHECK
54978 Zephyren(ゼファレン)COACH JACKET - fiat lux - BURGUNDY
56029 RUDIE'S PHAT CHECK SHIRTS RED
32491 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BARGUNDY
55988 ROLLING CRADLE ICEE SWEAT / RED
55982 MISHKA(ミシカ) 91344 LED LAMP
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
54761 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS RED
55632 Anti Social Social Club FRANTIC RED FLANNEL
54168 GoneR Day of the Dead Tank-Top Black/Red
55548 PUNK DRUNKERS 切替イージーパンツ RED/BLACK
55553 PUNK DRUNKERS はんかち / 顔文字 RED
53249 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE / BURGUNDY
44093 mnml(ミニマル) WEB BELT RED
49865 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK 3 RED
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
41693 Subciety BANDANNA SHORTS RED
52620 RUDIE'S MIGHTY SHOWER SANDAL RED
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
48520 GoneR GR21CT002 Grave Rose T-Shirts Red
36638 GoneR New Logo Bucket Hat RED
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
11625 KILL STAR CLOTHING KAWAII LEGGINGS
12222 ROLLING CRADLE LAUNDRY CAN BADGE
13187 VANS APPAREL MARITIME19 SURF SHORTS BLUE
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
14305 MISHKA (ミシカ) DEATH ADDER NEW ERA BURGUNDY
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15511 WE CAME AS ROMANS Conquer Maroon
17971 KILLSWITCH ENGAGE DRAGON ZOMBIE WALLET
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19868 SQUARE FLOWER TANKTOP RED
20193 KEYTALK ボーダーTシャツ赤
21134 BEFORE MY LIFE FAILS Sunglasses Division Point
21220 ATTILA RageAholics Red - T-Shirt
21478 アーバンギャルド 水玉ショルダーバッグ レッド
21681 FAMOUS STARS AND STRAPS F YOU YOU F MENS TEE RED
22171 FAMOUS STARS AND STRAPS VERNON BOYS TEE RED
22707 ザ・チャレンジ ラバーバンド ユニフォームロゴVer. RANDOM
22869 RUDIE'S DRAWING COACH JKT BURGUNDY
22953 ROLLING CRADLE BOX BOX FOAM LOGO HOODIE / Red
23300 ANIMALIA SW03 Logo#001 RED
23457 HER NAME IN BLOOD WRISTBAND Red/Black Marble x White
23739 ROLLING CRADLE FREAK OUT LONG Tee / Red
23864 MISHKA (ミシカ) KEEP WATCH BOX LOGO PULLOVER HOODIE BLACK
23887 ROLLING CRADLE FLUFFY HALF HOODIE / Red
24141 【限定デザイン】グッドモーニングアメリカ 缶バッジセットB
24142 グッドモーニングアメリカ ☆バスタオル レッド
24153 グッドモーニングアメリカ 時計パーカー(バーガンディ)
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24634 Xmas Eileen ニットキャップ RED
24668 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Tank Top RED
24724 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BURGUNDY
24727 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- RED
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
24907 ANIMALIA 49in Back-Pack
25121 Zephyren (ゼファレン) STRIPE SHIRT -PAISLEY- BURGUNDY
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25449 MAYDAY PARADE Pom Beanie
25572 Subciety EMBLEM SHIRT HOODY RED
25902 Subciety BOWLAR HAT BURGUNDY
26379 Zephyren (ゼファレン) CHECK SHIRT S/S -Resolve- RED
26419 モーモールルギャバン 復活ツアーTシャツ ウーマン ピンク
26436 モーモールルギャバン 2014 トートバッグ レッド
26547 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) EFFIN FAMOUS TEE RED
27383 アーバンギャルド スタンドミラー
27384 アーバンギャルド マスクケース
27414 激ロック Reversible Rubber Bracelet marble RED/WHT/BLK
27591 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) PAISLEY BOH RED
27735 ANIMALIA AN16A-AC12 Cigarette Pouch RED
28146 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [BLOOD]
28215 REBEL8 WOMENS BUFFALO STANCE COAT
28395 THRASHER TH8101 MAG LOGO TEE BRG
29173 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- RED
29529 Artemis Classic ストーンカレッジペンダントRD[ACP0286]
29894 REBEL8 MAKERS AND BREAKERS BURGUNDY TEE
29939 PUNK DRUNKERS ロング丈でかPスタジャン BLUE
32308 VIRGO Variable change shirts 切り替えチェックシャツ RED
32332 REBEL8 DEAD ASLEEP TEE BURGUNDY
32532 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) COMIC F Tee RED
33428 VIRGO Airship dolmania BURGANDY
34088 Zephyren(ゼファレン) ZIP PARKA -melt hand- BURGUNDY
34154 Xmas Eileen Xmas Eileen カレッジTシャツ BURGUNDY
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[color] => 7
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&color=7
--------
mb_parse_str
Array
(
[work] => new_arrival
[color] => 7
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&color=7