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 =324
)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-04-28 22:14:33')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
4313 VESTAL - HIMALAYAS VVHM006
7268 Artemis Classic ACサングラス セカンドBR[ACG003]
7522 Artemis Classic ACサングラス ファーストBR[ACSG0001]
8754 ROLLING CRADLE 6090 GLASSES SERIES-MYAGE- Brown
11053 VANS APPAREL Spicoli 4 Shades CLEAR BROWN
13956 VANS APPAREL Spicoli 4 Shades Pink/Black
13960 VANS APPAREL Spicoli 4 Shades Chartreuse/Blue
14362 Nunettes x MISHKA SUNGLASSES EYE Red
14366 Nunettes x MISHKA SUNGLASSES EYE Purple
14367 Nunettes x MISHKA SUNGLASSES EYE BLACK
14495 BEFORE MY LIFE FAILS Sunglasses "DEAD DUST"
14496 BEFORE MY LIFE FAILS Sunglasses SHEEPS
19842 MISHKA (ミシカ) CONCEALED CYRILLIC SUNGLASSES
19995 LILWHITE. -SYMBOL-SUNGLASS(BLKxBLK)
19996 LILWHITE. -SYMBOL-SUNGLASS(BLKxWHT)
20071 VANS APPAREL SPICOLI 4 SHADES DELSOL
20072 VANS APPAREL SPICOLI 4 SHADES PEACH
20073 VANS APPAREL SPICOLI 4 SHADES FLORAL
20074 VANS APPAREL FOLDABLE SPICOLI SHADES RD TORT
20075 VANS APPAREL SPICOLI 4 SHADES CLEAR BK
20459 SILLENT FROM ME ALEX -Sunglass- BLACK/CLEAR
20460 SILLENT FROM ME ALEX -Sunglass- BLACK/BLACK
20461 SILLENT FROM ME ALEX -Sunglass- WHITE/BLACK
21132 BEFORE MY LIFE FAILS Sunglasses - Transaction
21133 BEFORE MY LIFE FAILS Sunglasses - Solaris
21134 BEFORE MY LIFE FAILS Sunglasses Division Point
21135 BEFORE MY LIFE FAILS Sunglasses Wolves
21136 BEFORE MY LIFE FAILS Sunglasses - Fires
22713 ザ・チャレンジ サングラス RED
22714 ザ・チャレンジ サングラス BLUE
22715 ザ・チャレンジ サングラス PINK
22716 ザ・チャレンジ サングラス PURPLE
22717 ザ・チャレンジ サングラス YELLOW
23420 RUDIE'S PHAT CLEAR SUNGLASSES
23903 RUDIE'S PHAT SUNGLASSES BROWN
23904 RUDIE'S PHAT SUNGLASSES BLACK
24146 グッドモーニングアメリカ たなしんサングラス イエロー
24147 グッドモーニングアメリカ たなしんサングラス グリーン
24283 PUNK DRUNKERS サングラス2016 WOOD
24284 PUNK DRUNKERS サングラス2016 CAMO
24294 THRASHER Toy Glasses DM
24295 THRASHER Toy Glasses BK-SM
24296 THRASHER Toy Glasses BK-RE
24297 THRASHER Toy Glasses Planet DM
24298 THRASHER Toy Glasses Planet BLUE
24299 THRASHER Toy Glasses Planet BK-BL
24894 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-White
24896 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-Black
24897 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Black
25050 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Blue
25051 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Green
25052 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Pink
25053 ROLLING CRADLE 6090 GLASSES SERIES -FOOL- / Yellow
25058 DEADHEARTZ “SUNGRASSE” BLACK
25059 DEADHEARTZ “SUNGRASSE” WHITE
25174 RUDIE'S RUDIE'SxMOGA BASTARD CLEAR SUNGLASSES
25290 PUNK DRUNKERS めがね2016 BLACK
27352 SQUARE PSYCHO SKULL SUNGLASS CAMO
27353 SQUARE PSYCHO SKULL SUNGLASS BLACK
27354 SQUARE PSYCHO SKULL SUNGLASS WHITE
27387 SQUARE (スクエア) CLEAR LENS SUNGLASS
27801 THRASHER BEER GOGGLES BLUE
27802 THRASHER BEER GOGGLES GREEN
27803 THRASHER BEER GOGGLES WHITE
28256 STAY SICK CLOTHING New Script Logo Black
28679 ROLLING CRADLE 6090 GLASSES-DOG OUT- BLACK
28680 ROLLING CRADLE 6090 GLASSES-DOG OUT- BROWN
30023 SQUARE (スクエア) OVAL CLEAR SUNGLASS BLACK
30024 SQUARE (スクエア) OVAL CLEAR SUNGLASS BROWN
32439 RUDIE'S PHAT CLEAR SUNGLASSES BROWN/CLEAR
32440 RUDIE'S PHAT SUNGLASSES BLACK/CLEAR
32478 PUNK DRUNKERS (パンクドランカーズ) まるめがね2017 BLACK
32479 PUNK DRUNKERS (パンクドランカーズ) まるサングラス2017 BLACK
32480 PUNK DRUNKERS (パンクドランカーズ) まるサングラス2017 ベッコウ
32563 RUDIE'S PHAT SUNGLASSES BLACK/BLACK
32564 RUDIE'S PHAT SUNGLASSES BROWN/BROWN
34269 ROLLING CRADLE RC GLASSES -ROMA- / Orange
34270 ROLLING CRADLE RC GLASSES -ROMA- / Blue
34767 Subciety (サブサエティ) SUNGLASS BLACK
34768 Subciety (サブサエティ) SUNGLASS CLEAR
34769 Subciety (サブサエティ) FOX SUNGLASS BLACK
35049 SQUARE BOX LOGO SUNGLASS LEOPRAD
35050 SQUARE BOX LOGO SUNGLASS BLACK
35051 SQUARE BOX LOGO SUNGLASS BLUE
35052 SQUARE BOX LOGO SUNGLASS YELLOW
35053 SQUARE ROUND SUNGLASS BLUE
35054 SQUARE ROUND SUNGLASS YELLOW
35055 SQUARE ROUND SUNGLASS GREEN
35062 SILLENT FROM ME Sunglass
35521 DEADHEARTZ SUNGRASSE WHITE
35522 DEADHEARTZ SUNGRASSE BLACK
35592 SILLENT FROM ME SELMA -Sunglass- BLK/BLK
35593 SILLENT FROM ME SELMA -Sunglass- BLACK/CLEAR
35973 Zephyren (ゼファレン) SUNGLASS-GENIOT- CLEAR
35977 Zephyren (ゼファレン) SUNGLASS-BRIGHTARK- BLACKxCLEAR
35980 Zephyren (ゼファレン) SUNGLASS-BRIGHTARK- BROWNxCLEAR
36061 PUNK DRUNKERS めがね2017サマー SILVER
36062 PUNK DRUNKERS めがね2017サマー BLACK
36063 PUNK DRUNKERS サングラス2017サマー BLACK
36448 SILLENT FROM ME ANTHONY -Sunglass- BLK/GOLD
36451 SILLENT FROM ME ANTHONY -Sunglass- WHITE/BLUE
36460 SILLENT FROM ME ICHABOD -Sunglass-
36706 RUDIE'S PHAT SUNGLASSES BLACK/BLUE
36707 RUDIE'S PHAT CLEAR SUNGLASSES
36710 SILLENT FROM ME DOLAN -Sunglass- BLACK/CLEAR
36711 SILLENT FROM ME DOLAN -Sunglass- BLACK/BLACK
36712 SILLENT FROM ME MATILDA Sunglass- BLACK
36713 SILLENT FROM ME MATILDA Sunglass- CLEAR
36935 RIP DESIGN WORXX サングラス BLACK
36936 RIP DESIGN WORXX サングラス CAMO
36937 RIP DESIGN WORXX サングラス BLUE MIRROR
37077 ROLLING CRADLE 6090 GLASSES -Closer- / Bekko
37078 ROLLING CRADLE 6090 GLASSES -Closer- / Black
37180 ROLLING CRADLE 6090 GLASSES -Lyla- / Black
39551 SILLENT FROM ME MARCIE -Sunglass- CLR
39552 SILLENT FROM ME MARCIE -Sunglass- BLK
39666 Subciety SUNGLASS-James- BLACK
39667 Subciety SUNGLASS-James- CLEAR
39974 RUDIE'S PHAT SUNGLASSES BLACK/PINK
40307 Zephyren SUNGLASS -GENIOT BLUE