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 (
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-04-25 14:02:42')
AND pc.stock > 0
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 `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
28663 DEMON HUNTER BASIC
28694 AUGUST BURNS RED DOVE
28710 SOILWORK ANCHOR
35602 DISTURBED FIRE BEHIND T-SHIRTS
35603 DISTURBED Up Your Fist T-Shirts
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
35619 GUNS N' ROSES 30th Photo T-Shrts
35690 NIRVANA Bleach Cassette Photo T-shirt
36238 SLAYER No Mercy-Black T-shirt
36537 FIVE FINGER DEATH PUNCH Purgatory 2014 Tour-
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36662 GUNS N' ROSES BULLET CLASSIC GRAY
36668 IRON MAIDEN BOOK OF SOULS EDDIE
36670 IRON MAIDEN HIGHWAY
36673 JUDAS PRIEST PAINKILLER SOLO
36695 SLAYER LARGE BLACK EAGLE
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36829 DISTURBED Ravens Jumbo Print-White t-shirt
36878 DISTURBED Up Your Fist T-Shirts RED
37032 PANTERA Reinventing Band
37034 PANTERA Band Flames T-Shirt
39163 BLACK SABBATH LOTW white Tee
49846 DISTURBED LOST SOULS
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask