Advertisement
Guest User

Untitled

a guest
Jan 17th, 2020
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. SELECT GROUP_CONCAT(dac.id) dac_id
  2. , yac2.id yac_id
  3. , yac2.city_ukr
  4. , dac.name_ua
  5. , r.name_ua
  6. , ar.ua
  7. , obl.name_ua
  8. , a_obl.ru
  9. , yac2.nova_poshta_type
  10. FROM dok_cities.all_cities dac
  11. INNER JOIN dok_cities.regions r ON r.id = dac.region_id
  12. INNER JOIN dok_cities.oblast obl ON obl.id = dac.oblast_id
  13. #INNER JOIN dok_cities.all_warehouses daw ON daw.city_id = dac.id
  14. INNER JOIN yii_doc.all_cities yac2 ON dac.name_ua = yac2.city_ukr
  15. INNER JOIN yii_doc.all_regions ar ON ar.id = yac2.region_id
  16. INNER JOIN yii_doc.all_oblast a_obl ON a_obl.id = yac2.oblast_id
  17. WHERE 1=1
  18. AND dac.city_analytics_id IS NULL
  19. AND REPLACE(obl.name_ua, 'область','') = a_obl.ua
  20. AND r.name_ua = ar.ua
  21. GROUP BY yac2.id
  22. # GROUP BY dac.id
  23. HAVING 1 = 1
  24. AND COUNT(yac2.id) = 1
  25. AND COUNT(DISTINCT dac.id) = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement