Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- pd.*
- ,pa.avalaible_gen
- ,pa.price_torg
- ,IF (@rn % 12 = 0, @gn:=@gn+1, @gn) AS 'group_num'
- ,@rn:=@rn+1
- FROM migrate.PA_DR pd
- LEFT JOIN prices_all pa ON pd.pd_pa_id = pa.id
- LEFT JOIN seo_available_razdel sr ON pd.pd_dr_id = sr.dok_razdel_id
- WHERE 1
- AND pa.price_torg >= sr.min_available_price
- AND pd.pd_dr_id = 242
- AND pa.avalaible_gen = 1
- ORDER BY pa.price_torg ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement