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-10 16:20:53')
AND FIND_IN_SET(2, p.color)
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 pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
70557 SUM41 UNISEX T-SHIRT: REAPER
68784 美園 礼音 × LONELY論理 コラボ限定Tシャツ
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35598 BRING ME THE HORIZON Alone & Depressed
52902 MY CHEMICAL ROMANCE UNISEX TEE: RACEWAY
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
7448 ISSUES I Have - Heather Grey
10241 LINKIN PARK GLITCH PORTRAIT T-Shirt
11278 DANGERKIDS CAD Charcoal T-Shirt
11301 ENTER SHIKARI Texas Silver
11424 OF MICE & MEN Restoring Force Album Heather GRY
12062 NIRVANA GALAXY IN UTERO T-Shirt
15333 YELLOWCARD You're The Light Silver
15401 MEMPHIS MAY FIRE Logo Heather Gray
15434 ISSUES Monster Heather Grey
15456 MOTIONLESS IN WHITE Icon Black On Charcoal Heather
15495 PROTEST THE HERO Dino Ice Grey
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15571 OF MICE & MEN Faithfulness Heather Grey
17727 METALLICA Puppet Strings All Over T-Shirt
17728 METALLICA PUSHHEAD BORIS MENS TEE
18027 ALL SKATEROY T-shirts
18028 四星球 シンプルロゴTシャツ Charcoal
18038 四星球 テヘペロTシャツ GREY
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
19127 MOTIONLESS IN WHITE Logo Black On Dark Heather
19133 SLEEPING WITH SIRENS Feather Charcoal Grey T-Shirt
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19801 CHUNK!NO,CAPTAIN CHUNK! Gray Text
19870 CROWN THE EMPIRE Oh, Catastrophe Heather Grey Tee
21115 ISSUES Too Many Moons Heather Tank Top
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
22615 Bentham バットマンT ヘザーパープル
23933 amazarashi amazarashi 5th logo T-shirt
23941 amazarashi nee mama [character T-shirt] 【ヘザーグレイ】
23943 amazarashi higashizm tour T-shirts【グレー】
24306 キバオブアキバ ANUBIS Tシャツ Grey/BGN
24646 NECK DEEP Generic Pop Punk Athletic Heather
24653 PROTEST THE HERO Underbite Dark Heather T-Shirts
24657 GET SCARED Demon Coffin Grey - T-Shirt
24664 ISSUES Black Diamonds Heather Grey - T-Shirt
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24767 NORTHLANE Free Your Mind Charcoal - T-Shirt
24768 NORTHLANE All-Over Print Black - T-Shirt
24776 NORTHLANE Connected Tri-Charcoal - T-Shirt
24780 NORTHLANE Bars Heather Grey - T-Shirt
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25150 WE CAME AS ROMANS Eagle Heather Grey - T-Shirt
25157 WE CAME AS ROMANS Pollen Heather Grey - T-Shirt
25168 AUGUST BURNS RED Flag Heather Grey - T-Shirt
25181 ERRA Deer Skull Heather - T-Shirt
25305 CROWN THE EMPIRE Masks Album Art Grey - T-Shirt
25312 EMAROSA Tattoo Fox Heather - T-Shirt
25314 EMAROSA Red Eye Heather Grey - T-Shirt