SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 >= '2024-05-14 18:16:26')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.classcategory_id1 IN( 11)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
AND `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 120, 120
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
70557 SUM41 UNISEX T-SHIRT: REAPER
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71501 MOTIONLESS IN WHITE UNISEX T-SHIRT: SPLIT SCREEN
71503 NINE INCH NAILS UNISEX T-SHIRT: DOWNWARD SPIRAL (BACK PRINT)
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
71505 SYSTEM OF A DOWN UNISEX T-SHIRT: DOVE OVERCOME
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
49846 DISTURBED LOST SOULS
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35502 SLIPKNOT Blocks T-Shirt
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
39163 BLACK SABBATH LOTW white Tee
17973 UNEARTH SKATE RAGE
Twitter
Instagram
Map
Blog
ブラック
グレー
ホワイト
ブラウン
カーキ
ベージュ
レッド
ピンク
オレンジ
イエロー
パープル
グリーン
ネイビー
ブルー
ゴールド
シルバー
カモ
ペイズリー
アニマル
タイダイ
チェック
ドット
ストライプ
イラスト
