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 17:09:32')
AND pc.classcategory_id1 IN( 14,61,35)
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 0, 120
70129 ROLLING CRADLE (ローリングクレイドル) THUNDER GATE WIDE COLOR DENIM INDIGO
66708 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR THUNDER GATE BAGGY DENIM
60550 ROLLING CRADLE THUNDER GATE BAGGY DENIM -2nd- / INDIGO
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
58312 ROLLING CRADLE BIG CHECK SHORTS / BEIGE
58313 ROLLING CRADLE BIG CHECK SHORTS / BLACK
58121 ROLLING CRADLE THUNDER GATE BAGGY DENIM / INDIGO
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
56800 ROLLING CRADLE SUEDE TRACK PANTS BLACK
56801 ROLLING CRADLE SUEDE TRACK PANTS BEIGE
54525 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 パーカー
54479 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 Tシャツ
7015 ROLLING CRADLE D●O●T● SHIRT Navy
9072 ROLLING CRADLE MOKOMOKO SHORTS Black
10535 ROLLING CRADLE UNREASONABLE MONSTER White
10536 ROLLING CRADLE UNREASONABLE MONSTER Indigo
10537 ROLLING CRADLE UNREASONABLE MONSTER Black
10539 ROLLING CRADLE Pillkn NEVER DIE Tee Black
11153 ROLLING CRADLE RC PAINTER CAMO PANTS Camo
11475 ROLLING CRADLE FLAMINGO SHORTS Blue
11858 ROLLING CRADLE BiG CHIDORI SHIRT Red×Blue
11859 ROLLING CRADLE BiG CHIDORI SHIRT Black×Blue
11860 ROLLING CRADLE STREET RC FIGHTERS XV White
12081 ROLLING CRADLE I’LL PAINT IT White
12082 ROLLING CRADLE I’LL PAINT IT Gray
12083 ROLLING CRADLE I’LL PAINT IT Black
12084 ROLLING CRADLE SUMMER FEELING White
12085 ROLLING CRADLE SUMMER FEELING Blue
12086 ROLLING CRADLE SUMMER FEELING Black
12088 ROLLING CRADLE HOUSE ROCKIN’ Pink
12089 ROLLING CRADLE HOUSE ROCKIN’ Black
12096 RC x MONSTER ROCK x MONSTER ENERGY T-Shirt
12213 ROLLING CRADLE BiG CYCLOPS-Dr.J- Blue
12351 ROLLING CRADLE STOP! CYCLO-KN Lightblue
12368 ROLLING CRADLE MISSILE Pillkn Gray
12370 ROLLING CRADLE MISSILE Pillkn Black
12630 ROLLING CRADLE ROLICLE BASE BALL-SHIRT Yellow
12641 ROLLING CRADLE RC-BA TANK Lightblue×Red
12642 ROLLING CRADLE RC-BA TANK Red×Blue
12683 ROLLING CRADLE RC-BA TANK White×Black
12830 ROLLING CRADLE FINGER PLAY SHIRT Black
12838 ROLLING CRADLE TACO TACO SHORTS Turquoise
12915 ROLLING CRADLE THE UMA COMPLETE TANK
12916 ROLLING CRADLE LAUNDRY SHIRT White
12917 ROLLING CRADLE LAUNDRY SHORTS White
12918 ROLLING CRADLE LAUNDRY TANK White
13051 ROLLING CRADLE DOT×DOT WORK SHORTS Black
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
13720 ROLLING CRADLE MASTER CYCLOPS BLUE
13721 ROLLING CRADLE MASTER CYCLOPS OLIEVE
13722 ROLLING CRADLE MASTER CYCLOPS RED
13888 ROLLING CRADLE SWITCHING CHECK SHIRT RED
13890 ROLLING CRADLE MANEATERS LONG T-SHIRT GRAY
13891 ROLLING CRADLE RC OFFICIAL T-MONSTER-WHITE
13892 ROLLING CRADLE RC OFFICIAL T-MONSTER-BLACK
14287 ROLLING CRADLE BiG CYCLOPS-SB HOODIE / Gray
14295 ROLLING CRADLE CHIPS SWEAT WHITE
14297 ROLLING CRADLE CHIPS SWEAT NAVY
14482 ROLLING CRADLE HANHAN PANTS /Brown
14587 ROLLING CRADLE FAT STRIPE SLIM SHIRT /Blue
14588 ROLLING CRADLE FAT STRIPE SLIM SHIRT /Black
14601 ROLLING CRADLE HALF COACH JKT / Indigo
14697 ROLLING CRADLE TURTLES-COWABUNGA- Black
14709 ROLLING CRADLE BIG TURTLOPS-MICHELANGELO-
14719 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Black
14720 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Navy
14721 ROLLING CRADLE PYRAMID POWER FLEECE JKT / Beige
14722 ROLLING CRADLE MYSTERIOUS PATTERN HOODIE / Black
14723 ROLLING CRADLE MYSTERIOUS PATTERN HOODIE / COSMO
14724 ROLLING CRADLE MYSTERIOUS PATTERN JKT / Black
14725 ROLLING CRADLE MYSTERIOUS PATTERN JKT / Cosmo
14727 ROLLING CRADLE THE UMA COMPLETE DOWN JKT / Black
15149 ROLLING CRADLE ROLLING THUNDER!? JKT / Olive
15150 ROLLING CRADLE ROLLING THUNDER!? JKT / Navy
15366 ROLLING CRADLE FAT STRIPE SLIM PANTS /Black
15780 ROLLING CRADLE CYCLOPS SHOUT COACH JKT / Red
15781 ROLLING CRADLE CYCLOPS SHOUT COACH JKT / Beige
15789 ROLLING CRADLE SD ROLICLE HOODIE / Black
15790 ROLLING CRADLE SD ROLICLE HOODIE / Gray
15791 ROLLING CRADLE SD ROLICLE HOODIE / White
15793 ROLLING CRADLE FAT STRIPE SLIM PANTS /Indigo
15842 ROLLING CRADLE SWALLOW TAIL SHIRTL / Gray/Red
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
15844 ROLLING CRADLE RAKURAI LONG NEL / Red
15847 ROLLING CRADLE BALANCE FOOD HOODIE / Black
16368 ROLLING CRADLE HOLSTEIN YADOKU HOODIE / Blue
16370 ROLLING CRADLE HOLSTEIN YADOKU HOODIE / Black
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
16664 ROLLING CRADLE POP-ART CRAZY SHIRT / SmallCrazy
16665 ROLLING CRADLE RC JOGGER PANTS /StaghornCamo
16666 ROLLING CRADLE RC JOGGER PANTS /KinokoCamo
16667 ROLLING CRADLE POP-ART LONG T-SHIRT / Black
16668 ROLLING CRADLE POP-ART LONG T-SHIRT / White
17370 ROLLING CRADLE ROLLCRDL Tee / White
17372 ROLLING CRADLE ROLLCRDL Tee / Yellow
17373 ROLLING CRADLE ROLLCRDL Tee / Red
17375 ROLLING CRADLE ROLLCRDL Tee / Black
17376 ROLLING CRADLE Pill-kn MIXER Tee / White
17377 ROLLING CRADLE Pill-kn MIXER Tee / Gray
17378 ROLLING CRADLE Pill-kn MIXER Tee / Blue
17379 ROLLING CRADLE Pill-kn MIXER Tee / Black
17597 ROLLING CRADLE RAKURAI NEL / Yellow
17600 ROLLING CRADLE CHAMBER BORDER SHORTS / Black
17601 ROLLING CRADLE POP-ART Tee / White
17602 ROLLING CRADLE POP-ART Tee / Black
17857 ROLLING CRADLE BiG CYCLOPS-SB / White
17858 ROLLING CRADLE BiG CYCLOPS-SB / Black
17859 ROLLING CRADLE CYCLOPS SKATE IN THE DARKNESS / WHT
17862 ROLLING CRADLE RC×STETCH ROCKAWAY BEACHERS / Black
17865 ROLLING CRADLE KO-RI KO-RI Tee / White
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