Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- pa.id AS product_id,
- pa.art_num AS product_art_num,
- pa.pa_art_id AS artId,
- pa.price_torg AS price,
- pa.avalaible_gen AS available,
- pa.art_num AS article,
- ba.NAME_BRANDS AS brand_name,
- ba.url AS brand_url,
- dg.name_ru AS product_name,
- dg.GA_ID AS gaId,
- dru.id AS rubricId,
- di.id AS izdelieId,
- dr.id AS razdelId,
- -- IFNULL(a.ART_ARTICLE_NR, pa.art_num) AS
- art_num_customer,
- IFNULL(pa.art_num, NULL) AS art_num_customer,
- NULL AS img_path
- FROM migrate.PA_DR pd
- INNER JOIN yii_doc.prices_all pa ON pd.pd_pa_id = pa.id
- LEFT JOIN yii_doc.dok_ga dg ON pd.pd_ga_id = dg.GA_ID
- LEFT JOIN yii_doc.seo_izdelie si ON pd.pd_dr_id =
- si.dok_razdel_id
- LEFT JOIN yii_doc.brand_all ba ON pa.brand_id = ba.id
- LEFT JOIN yii_doc.dok_razdel dr ON pd.pd_dr_id = dr.id
- LEFT JOIN yii_doc.dok_izdelie di ON dr.parent_id = di.id
- LEFT JOIN yii_doc.dok_rubrika dru ON di.grand_parent_id =
- dru.id
- WHERE
- si.alias = 'rylevoi-nakonechnik-levii-pravii'
- ORDER BY pa.id
- LIMIT 16
- OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment