Advertisement
campocreek

Untitled

Jan 23rd, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT
  2. pd.*
  3. ,pa.avalaible_gen
  4. ,pa.price_torg
  5. ,IF (@rn % 12 = 0, @gn:=@gn+1, @gn) AS 'group_num'
  6. ,@rn:=@rn+1
  7. FROM migrate.PA_DR pd
  8. LEFT JOIN prices_all pa ON pd.pd_pa_id = pa.id
  9. LEFT JOIN seo_available_razdel sr ON pd.pd_dr_id = sr.dok_razdel_id
  10. WHERE 1
  11. AND pa.price_torg >= sr.min_available_price
  12. AND pd.pd_dr_id = 242
  13. AND pa.avalaible_gen = 1
  14. ORDER BY pa.price_torg ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement