Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT GROUP_CONCAT(dac.id) dac_id
- , yac2.id yac_id
- , yac2.city_ukr
- , dac.name_ua
- , r.name_ua
- , ar.ua
- , obl.name_ua
- , a_obl.ru
- , yac2.nova_poshta_type
- FROM dok_cities.all_cities dac
- INNER JOIN dok_cities.regions r ON r.id = dac.region_id
- INNER JOIN dok_cities.oblast obl ON obl.id = dac.oblast_id
- #INNER JOIN dok_cities.all_warehouses daw ON daw.city_id = dac.id
- INNER JOIN yii_doc.all_cities yac2 ON dac.name_ua = yac2.city_ukr
- INNER JOIN yii_doc.all_regions ar ON ar.id = yac2.region_id
- INNER JOIN yii_doc.all_oblast a_obl ON a_obl.id = yac2.oblast_id
- WHERE 1=1
- AND dac.city_analytics_id IS NULL
- AND REPLACE(obl.name_ua, 'область','') = a_obl.ua
- AND r.name_ua = ar.ua
- GROUP BY yac2.id
- # GROUP BY dac.id
- HAVING 1 = 1
- AND COUNT(yac2.id) = 1
- AND COUNT(DISTINCT dac.id) = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement