string(2426) "WITH picked AS (
SELECT product_class_id, MAX(schedule_num) AS mx
FROM dtb_products_schedule
WHERE schedule_id = 5
AND ? BETWEEN start_date AND finish_date
AND sale_target IN (?)
GROUP BY product_class_id
),
sched_price AS (
SELECT s.product_class_id, s.price
FROM dtb_products_schedule s
JOIN picked p
ON p.product_class_id = s.product_class_id
AND p.mx = s.schedule_num
)SELECT T3.* FROM ( SELECT
DP.*,
dtb_products_class.classcategory_id1,
SUM(dtb_products_class.fav_count) AS fav_count,
MAX(stock) as max_stock,
MIN(stock) as min_stock,
MAX(CASE
WHEN IFNULL(stock, 0) > 0 THEN 1
ELSE 0
END) AS has_stock,
MAX(price01) as max_price01,
MIN(price01) as min_price01,
MAX(price02) as max_price02,
MIN(price02) as min_price02,
MAX(COALESCE(sp.price, dtb_products_class.price02)) AS max_fix_price,
MIN(COALESCE(sp.price, dtb_products_class.price02)) AS min_fix_price,
MAX(item_width) as item_width,
MAX(item_height) as item_height,
MAX(item_depth) as item_depth FROM
( SELECT
dtb_products.product_id,
dtb_products.master_id,
dtb_products.name,
dtb_products.sex_id,
dtb_products.sort_rank,
dtb_products.maker_id,
dtb_products.main_list_image,
dtb_products.status,
dtb_products.weight,
dtb_products.create_date
FROM dtb_products WHERE del_flg = 0 AND dtb_products.product_id IN (?,?,?,?,?,?,?,?) AND dtb_products.status IN (?)) as DP
INNER JOIN dtb_products_class ON dtb_products_class.product_id = DP.product_id
LEFT JOIN sched_price sp ON sp.product_class_id = dtb_products_class.product_class_id
WHERE
dtb_products_class.del_flg = 0 AND product_class_status = 1 GROUP BY dtb_products_class.product_id ORDER BY FIELD(DP.product_id,824687,825364,823351,825355,825350,823785,825082,823354) LIMIT 48) as T3"
array(11) {
[0]=>
string(16) "2025-09-20 17:13"
[1]=>
string(1) "1"
[2]=>
string(6) "824687"
[3]=>
string(6) "825364"
[4]=>
string(6) "823351"
[5]=>
string(6) "825355"
[6]=>
string(6) "825350"
[7]=>
string(6) "823785"
[8]=>
string(6) "825082"
[9]=>
string(6) "823354"
[10]=>
string(1) "1"
}
【公式】アンティーク家具ラフジュ工房（ラフジュコウボウ）商品詳細ページ/ アンティーク雑貨 北海道民芸家具 木製フレームのリメイクミラー(鏡)(2)
string(2363) "WITH picked AS (
SELECT product_class_id, MAX(schedule_num) AS mx
FROM dtb_products_schedule
WHERE schedule_id = 5
AND ? BETWEEN start_date AND finish_date
AND sale_target IN (?)
GROUP BY product_class_id
),
sched_price AS (
SELECT s.product_class_id, s.price
FROM dtb_products_schedule s
JOIN picked p
ON p.product_class_id = s.product_class_id
AND p.mx = s.schedule_num
)SELECT T3.* FROM ( SELECT
DP.*,
dtb_products_class.classcategory_id1,
SUM(dtb_products_class.fav_count) AS fav_count,
MAX(stock) as max_stock,
MIN(stock) as min_stock,
MAX(CASE
WHEN IFNULL(stock, 0) > 0 THEN 1
ELSE 0
END) AS has_stock,
MAX(price01) as max_price01,
MIN(price01) as min_price01,
MAX(price02) as max_price02,
MIN(price02) as min_price02,
MAX(COALESCE(sp.price, dtb_products_class.price02)) AS max_fix_price,
MIN(COALESCE(sp.price, dtb_products_class.price02)) AS min_fix_price,
MAX(item_width) as item_width,
MAX(item_height) as item_height,
MAX(item_depth) as item_depth FROM
( SELECT
dtb_products.product_id,
dtb_products.master_id,
dtb_products.name,
dtb_products.sex_id,
dtb_products.sort_rank,
dtb_products.maker_id,
dtb_products.main_list_image,
dtb_products.status,
dtb_products.weight,
dtb_products.create_date
FROM dtb_products WHERE del_flg = 0 AND dtb_products.product_id IN (?) AND dtb_products.status IN (?)) as DP
INNER JOIN dtb_products_class ON dtb_products_class.product_id = DP.product_id
LEFT JOIN sched_price sp ON sp.product_class_id = dtb_products_class.product_class_id
WHERE
dtb_products_class.del_flg = 0 AND product_class_status = 1 GROUP BY dtb_products_class.product_id ORDER BY FIELD(DP.product_id,805004) LIMIT 48) as T3"
array(4) {
[0]=>
string(16) "2025-09-20 17:13"
[1]=>
string(1) "1"
[2]=>
string(6) "805004"
[3]=>
string(1) "1"
}
