[query: SELECT count(*) cc
FROM tap_organiz organiz
left join tap_first first on organiz.KEYMAIN=first.company_id
join tap_rubric rubric on rubric.KEYRUBRIC=organiz.KEYRUBRIC
join tap_status status on status.KEYSTATUS=organiz.KEYSTATUS
join tap_street street on street.KEYSTREET=organiz.KEYSTREET
join tap_gorod gorod on gorod.KEYCITY=organiz.KEYCITY
left join tap_communic communic on communic.KEYMAIN=organiz.KEYMAIN
and communic.COMTYPE="тел/факс"
WHERE rubric.KEYRUBRIC=
GROUP BY organiz.KEYMAIN
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY organiz.KEYMAIN' at line 12
in file: /home/uralpages.ru_old/html/inc/auto/tap2.inc at line: 627]