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 =17
)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-25 01:10:07')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
28616 ROLLING STONES 50TH LOGO Cap
28697 METALLICA DISTRESSED LOGO Cap
28729 彼女 IN THE DISPLAY KID CAP
29048 PassCode V//PANEL
29050 PassCode V//CAP(BLACK)
29052 PassCode V//CAP(WHITE)
30124 BAND-MAID ローキャップ(紺)
30125 BAND-MAID ローキャップ(白)
30126 BAND-MAID ローキャップ(デニム)
34426 AA= LOGO SNAPBACK CAP (BK)
36654 BULLET FOR MY VALENTINE 3D LOGO
36671 IRON MAIDEN LOGO Cadet Cap
37750 SUICIDAL TENDENCIES 2HTSTOG SUICIDAL MESH FLIP ST POSSESSED
39169 LINKIN PARK Logo Snapback
41043 OBEY x Misfits Caress Snapback BLACK
41048 OBEY x Misfits Fiend Club 6 Panel Hat BLACK
41762 Survive Said The Prophet LOGO CAP
42625 Bentham コーデュロイ ロゴキャップ
43357 BRING ME THE HORIZON Sempiternal BASEBALL CAP
44973 KILL STAR CLOTHING (キルスター・クロージング) Got Plans Snapback [B]
49857 FIVE FINGER DEATH PUNCH BRASS ENAMEL PIN Cap
50245 MISHKA MAW193223 CAP YELLOW
50246 MISHKA MAW193206 CAP
50247 MISHKA MAW193236 CAP
52934 TOY MACHINE TMP20HW26 CAP BLACK
52935 TOY MACHINE TMP20HW26 CAP NAVY
52991 RUDIE'S SPARK SNAPBACK CAP GALAXY
53157 HEDWiNG HD8-006 Jellyfish Cap Black
53158 HEDWiNG HD8-006 Jellyfish Cap Orange
53159 HEDWiNG HD8-006 Jellyfish Cap Khaki
53164 TOY MACHINE TMS20HW12 BB CAP BLACK
53165 TOY MACHINE TMS20HW12 BB CAP NAVY
53202 MISHKA [ミシカ] MSS203213F99 CAP BLACK
53203 MISHKA [ミシカ] MSS203213F99 CAP INDIGO
54663 MISHKA(ミシカ) MSS203210 CAP
54666 MISHKA(ミシカ) MSS203214 CAP BLUE
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54668 MISHKA(ミシカ) MSS203209 CAP
54669 MISHKA(ミシカ) MSS203202 CAP
52952 Survive Said The Prophet FIRE LOGO CAP
56843 FAMOUS STARS AND STRAPS Fam Grown FF GRAY
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL