SELECT pa.art_num, sm.name_ru, sma.name_ru
FROM yii_doc.order_cars  AS oc
LEFT JOIN yii_doc.order_product AS op ON op.car_id=oc.id
LEFT JOIN yii_doc.orders AS o ON o.id=oc.order_id
LEFT JOIN yii_doc.prices_all AS pa ON pa.id=op.price_all_id
INNER JOIN yii_doc.PA_SM_DR psd ON psd.psd_pa_id = pa.id
INNER JOIN yii_doc.seo_izdelie si ON psd.psd_dr_id = si.dok_razdel_id
INNER JOIN yii_doc.seo_model sm ON psd.psd_sm_id = sm.id
INNER JOIN yii_doc.seo_marki sma ON sm.parent_id = sma.id
INNER JOIN yii_doc.dok_ga dg ON psd.psd_ga_id = dg.GA_ID
WHERE o.date_create BETWEEN '2017-06-01' AND '2017-06-02'
AND o.order_status_id=5
AND o.domain_id=3
LIMIT 10