campocreek

Untitled

Nov 21st, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. SELECT
  2. pa.id AS product_id,
  3. pa.art_num AS product_art_num,
  4. pa.pa_art_id AS artId,
  5. pa.price_torg AS price,
  6. pa.avalaible_gen AS available,
  7. pa.art_num AS article,
  8. ba.NAME_BRANDS AS brand_name,
  9. ba.url AS brand_url,
  10. dg.name_ru AS product_name,
  11. dg.GA_ID AS gaId,
  12. dru.id AS rubricId,
  13. di.id AS izdelieId,
  14. dr.id AS razdelId,
  15. -- IFNULL(a.ART_ARTICLE_NR, pa.art_num) AS
  16. art_num_customer,
  17. IFNULL(pa.art_num, NULL) AS art_num_customer,
  18. NULL AS img_path
  19. FROM migrate.PA_DR pd
  20. INNER JOIN yii_doc.prices_all pa ON pd.pd_pa_id = pa.id
  21. LEFT JOIN yii_doc.dok_ga dg ON pd.pd_ga_id = dg.GA_ID
  22. LEFT JOIN yii_doc.seo_izdelie si ON pd.pd_dr_id =
  23. si.dok_razdel_id
  24. LEFT JOIN yii_doc.brand_all ba ON pa.brand_id = ba.id
  25. LEFT JOIN yii_doc.dok_razdel dr ON pd.pd_dr_id = dr.id
  26. LEFT JOIN yii_doc.dok_izdelie di ON dr.parent_id = di.id
  27. LEFT JOIN yii_doc.dok_rubrika dru ON di.grand_parent_id =
  28. dru.id
  29. WHERE
  30. si.alias = 'rylevoi-nakonechnik-levii-pravii'
  31. ORDER BY pa.id
  32. LIMIT 16
  33. OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment