string(2058) "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.*,
DPC.classcategory_id1,
SUM(DPC.fav_count) AS fav_count,
MAX(stock) AS max_stock,
MIN(stock) AS min_stock,
MAX(price01) AS max_price01,
MIN(price01) AS min_price01,
MAX(price02) AS max_price02,
MIN(price02) AS min_price02,
MAX(COALESCE(DPC.price, DPC.price02)) AS max_fix_price,
MIN(COALESCE(DPC.price, DPC.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.sort_rank,
in_stock
FROM dtb_products WHERE dtb_products.status IN (?) AND del_flg = 0 AND dtb_products.product_id IN (?,?,?,?,?,?,?,?) ORDER BY in_stock DESC, sort_rank DESC, product_id DESC LIMIT 0) as DP
INNER JOIN ( SELECT
dtb_products_class.*,sp.price
FROM
dtb_products_class
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) as DPC ON DPC.product_id = DP.product_id GROUP BY DPC.product_id ORDER BY FIELD(DP.product_id,825231,825276,825225,825280,825255,825278,825224,825177) LIMIT 48) as T3"
【公式】アンティーク家具ラフジュ工房商品詳細ページアンティーク 古い木味のガラス戸2枚セット(引き戸)
string(2049) "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.*,
DPC.classcategory_id1,
SUM(DPC.fav_count) AS fav_count,
MAX(stock) AS max_stock,
MIN(stock) AS min_stock,
MAX(price01) AS max_price01,
MIN(price01) AS min_price01,
MAX(price02) AS max_price02,
MIN(price02) AS min_price02,
MAX(COALESCE(DPC.price, DPC.price02)) AS max_fix_price,
MIN(COALESCE(DPC.price, DPC.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.sort_rank,
in_stock
FROM dtb_products WHERE dtb_products.status IN (?) AND del_flg = 0 AND dtb_products.product_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) as DP
INNER JOIN ( SELECT
dtb_products_class.*,sp.price
FROM
dtb_products_class
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) as DPC ON DPC.product_id = DP.product_id GROUP BY DPC.product_id ORDER BY FIELD(DP.product_id,22148,19858,32797,21971,21735,21731,21837,32482,19784,19736,19365,21441,32358,32626,19731,32642) LIMIT 0) as T3"
