[query: SELECT organiz.*,
                   first.*,
                   status.STATUS,
                   street.STREET, street.STREETTYPE,
                   gorod.CITY, gorod.CODCUNTRY, gorod.CODEMTS, gorod.CITYTYPE,
		   if (isnull(first.company_id), 0, 1) isclient
            FROM       tap_organiz  organiz
             left join tap_first    first    on organiz.KEYMAIN=first.company_id
             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
            WHERE organiz.KEYMAIN = 
            GROUP BY organiz.KEYMAIN <br>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 13<br>
						in file: /home/uralpages.ru_old/html/inc/auto/firm.inc at line: 173]