Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE migrate.seo_available sa
- INNER JOIN (
- SELECT
- 1 as SA_available
- , t.seo_model_id as SA_model_id
- , si.id as SA_izdelie_id
- , COUNT(DISTINCT pa.id) as SA_count_OLD
- ,COUNT(DISTINCT
- IF (IF(t.min_available_price IS NOT NULL, CEIL(t.min_available_price), NULL) IS NOT NULL,
- IF (pa.avalaible_gen = 1, pa.id, NULL),
- pa.id)
- ) AS SA_count
- , IF(t.min_available_price IS NOT NULL, CEIL(t.min_available_price), NULL) as min_price
- FROM (
- SELECT
- ta.dok_razdel_id
- , ta.seo_model_id
- , MIN(IF(pa.avalaible_gen = 1, pa.price_torg, null)) as min_available_price
- , si.id as sid
- FROM tecdoc_art2 ta
- LEFT JOIN prices_all/*_duplicate*/ pa ON ta.art_id = pa.pa_art_id
- INNER JOIN seo_izdelie si ON ta.dok_razdel_id = si.dok_razdel_id
- INNER JOIN seo_model sm ON ta.seo_model_id = sm.id
- LEFT JOIN virtual_seo_models vsm ON ta.seo_model_id = vsm.seo_model_id
- WHERE
- pa.avalaible_gen IN (0, 1)
- AND ta.seo_model_id > 0 -- AND sm.id = 21 AND si.dok_razdel_id = 141
- AND vsm.seo_model_id IS NULL
- AND ta.seo_model_id = 304
- GROUP BY ta.seo_model_id, si.id
- ) t
- LEFT JOIN tecdoc_art2 ta ON t.seo_model_id = ta.seo_model_id AND t.dok_razdel_id = ta.dok_razdel_id
- LEFT JOIN prices_all/*_duplicate*/ pa ON ta.art_id = pa.pa_art_id
- INNER JOIN seo_izdelie si ON t.sid = si.id
- INNER JOIN seo_model sm ON ta.seo_model_id = sm.id
- WHERE
- pa.avalaible_gen IN (0, 1)
- AND pa.price_torg >= IFNULL(t.min_available_price, 0)
- GROUP BY t.seo_model_id, t.sid
- ORDER BY SA_model_id, SA_izdelie_id
- ) t ON sa.SA_model_id = t.SA_model_id AND sa.SA_izdelie_id = t.SA_izdelie_id
- SET
- sa.SA_count = t.SA_count
- , sa.min_price = t.min_price
- , sa.SA_available = t.SA_available
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement