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 >= '2024-04-25 23:51:49')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 85)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
17958 ROLLING CRADLE RC THUNDER OX SHIRT / Blue
17959 ROLLING CRADLE RC THUNDER OX SHIRT / Gray
17961 ROLLING CRADLE 90's BIG POLO SHIRTS / Navy
17962 ROLLING CRADLE 90's BIG POLO SHIRTS / Black
17963 ROLLING CRADLE COLORFUL CAMO SHORTS / Green
17964 ROLLING CRADLE COLORFUL CAMO SHORTS / Red
17965 ROLLING CRADLE COLORFUL CAMO SHORTS / Beige
17966 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / White
17967 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / Black
18289 ROLLING CRADLE MARINE BORDER HOODIE / Gray
18292 ROLLING CRADLE 22[TWO-FU] FOOTBALL Tee / Navy
18294 ROLLING CRADLE ROLLCRDL Tee / Green
18295 ROLLING CRADLE ROLLCRDL Tee Black/RED
18298 ROLLING CRADLE COFFEE BRAKE Tee / Burgundy
18299 ROLLING CRADLE ROLL CAKE BRAKE Tee / Pink
18300 ROLLING CRADLE ROLL CAKE BRAKE Tee / Black
18962 ROLLING CRADLE CONVICT BORDER PANTS / Red-Blue
18964 ROLLING CRADLE CONVICT BORDER PANTS / Black
18967 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / White
18968 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / Black
18970 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / White
18971 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / Black
19142 ROLLING CRADLE RC×Mark Gonzales ANGEL White
19161 ROLLING CRADLE RC×Mark Gonzales CLOUD / White
19162 ROLLING CRADLE RC×Mark Gonzales CLOUD / Gray
19163 ROLLING CRADLE RC×Mark Gonzales CLOUD / Black
19164 ROLLING CRADLE RC×Mark Gonzales SKATE / Black
19165 ROLLING CRADLE RC×Mark Gonzales ANGEL / Black
19166 ROLLING CRADLE RC×Mark Gonzales ANGEL / Gray
19167 ROLLING CRADLE STRIPE CAMO BB-SHIRT / Blue
19168 ROLLING CRADLE 6090PICXIE / Black
19901 ROLLING CRADLE RC 3WAY DRUM BAG / Red
19902 ROLLING CRADLE CYCLOPS SHOUT POUCH / Blue
19906 ROLLING CRADLE RC×THRASHER SHORTS / Beige
19921 ROLLING CRADLE TWO COLOR BIG SHIRT / Blue-Black
19922 ROLLING CRADLE TWO COLOR BIG SHIRT / Red-Black
19956 ROLLING CRADLE RCxGREMLINS MOHAWK / White
19957 ROLLING CRADLE RCxGREMLINS MOHAWK / Gray
19958 ROLLING CRADLE RCxGREMLINS MOHAWK / Black
19959 ROLLING CRADLE RCxGREMLINS FLASHER / Black
20011 ROLLING CRADLE FUCK×FUCK SHIRT / White
20012 ROLLING CRADLE FUCK×FUCK SHIRT / Navy
20013 ROLLING CRADLE MEHYADO TANK / Black
20014 ROLLING CRADLE FUCK×FUCK TANK / White-Black
20015 ROLLING CRADLE HALF MAGIC SHORTS / MELA
20016 ROLLING CRADLE HALF MAGIC SHORTS / HYADO
20017 ROLLING CRADLE MEHYADO SHORTS / Black
20018 ROLLING CRADLE FUCK×FUCK SHORTS / White-Navy
20104 ROLLING CRADLE CATTEL MUTILATION BIG Tee / Turquoi
20105 ROLLING CRADLE CATTEL MUTILATION BIG Tee / White
20475 RC×MONSTER ROCK JUST DO WHAT YOU WANT! WHITE
20476 RC×MONSTER ROCK JUST DO WHAT YOU WANT!! BLACK
20569 ROLLING CRADLE WARM UP SWEAT PANTS / Gray
20570 ROLLING CRADLE WARM UP SWEAT PANTS / Blue
21184 ROLLING CRADLE RC REFLECTION HOODIE / Gray
21188 ROLLING CRADLE RC REFLECTION HOODIE / Blue
21189 ROLLING CRADLE RC REFLECTION HOODIE / Burgundy
21190 ROLLING CRADLE RC REFLECTION HOODIE / Black
21191 ROLLING CRADLE MP-LOPS POCTee / Black
21192 ROLLING CRADLE MP-LOPS POCTee / Gray
21193 ROLLING CRADLE MP-LOPS POCTee / White
21226 ROLLING CRADLE×THRASHER 8BIT CYCLOPS-SB HOODIE/GRY
21227 ROLLING CRADLE×THRASHER 8BIT CYCLOPS-SB HOODIE/NVY
21228 ROLLING CRADLE×THRASHER 8BIT CYCLOPS-SB HOODIE/BLK
21229 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Gray
21230 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Navy
21231 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Black
21232 ROLLING CRADLE RC EXPEDITION SWEAT / Black
21298 ROLLING CRADLE ROLLCRDL SWEAT / Red
21299 ROLLING CRADLE ROLLCRDL SWEAT / Black
21300 ROLLING CRADLE ROLLCRDL SWEAT / White
21301 ROLLING CRADLE STONED SWEAT / Black
21302 ROLLING CRADLE STONED SWEAT / White
21418 ROLLING CRADLE CATTLE MUTILATION SHORTS /Black GRN
21419 ROLLING CRADLE CATTLE MUTILATION SHORTS /Black-BLU
21420 ROLLING CRADLE MP-LOPS COACH JKT / Black
21421 ROLLING CRADLE MP-LOPS COACH JKT / Navy
21422 ROLLING CRADLE MP-LOPS COACH JKT / Green
21520 ROLLING CRADLE RAKURAI NEL / Green
21521 ROLLING CRADLE RAKURAI NEL / Blue
21522 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / GRY
21523 ROLLING CRADLE RC×Mark Gonzales ANGEL HOODIE / BLK
21524 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / WHT
21525 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / GRY
21526 ROLLING CRADLE RC×Mark Gonzales SKATE HOODIE / BLK
21527 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / WHT
21528 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / GRY
21529 ROLLING CRADLE RC×Mark Gonzales CLOUD HOODIE / BLK
21530 ROLLING CRADLE ROUGHLY KNIT CAP / White
21531 ROLLING CRADLE ROUGHLY KNIT CAP / Gray
21532 ROLLING CRADLE ROUGHLY KNIT CAP / Red
21533 ROLLING CRADLE ROUGHLY KNIT CAP / Navy
21534 ROLLING CRADLE ROUGHLY KNIT CAP / Black
21535 ROLLING CRADLE BiG CYCLOPS YETI POUCH / White
21536 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Pink
21537 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Green
21538 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Black
21595 ROLLING CRADLE CYCLOPS HAIR BAND RED
21596 ROLLING CRADLE CYCLOPS HAIR BAND BLUE
21597 ROLLING CRADLE CYCLOPS HAIR BAND YELLOW
21598 ROLLING CRADLE CYCLOPS HAIR BAND GREEN
21599 ROLLING CRADLE CYCLOPS HAIR BAND PINK
21600 ROLLING CRADLE CYCLOPS HAIR BAND PURPLE
21601 ROLLING CRADLE CYCLOPS SHOUT GLOVE / Black
21602 ROLLING CRADLE CATTLE MUTILATION HAT / Black-Green
21603 ROLLING CRADLE CATTLE MUTILATION HAT / Black-Blue
21729 ROLLING CRADLE OVERLOUD POCKET SHIRT / White
21730 ROLLING CRADLE OVERLOUD POCKET SHIRT / Turquoise
21731 ROLLING CRADLE OVERLOUD POCKET SHIRT / Black
21732 ROLLING CRADLE WAVELET SHIRT / White
21733 ROLLING CRADLE WAVELET SHIRT / Iceblue
21734 ROLLING CRADLE WAVELET SHIRT / Black
21866 ROLLING CRADLE CYCLOPS SHOUT KNIT / Blue
21867 ROLLING CRADLE CYCLOPS SHOUT KNIT / Navy
21868 ROLLING CRADLE THUNDER GATE DENIM 1st type /Indigo
21894 ROLLING CRADLE MP-LOPS N3B JKT / Camo
21895 ROLLING CRADLE RAKURAI LONG NEL / Blue
21896 ROLLING CRADLE RAKURAI LONG NEL / Red
21897 ROLLING CRADLE SUKA-JERSEY:TIGER / Red
21980 ROLLING CRADLE SHOUT STADIUM JUMPER / Black