Problem z subquery Opcje

[escaflowne]

Zainstalowałem ostatnio freeside i mam problem. Skrypt próbuje wykonać takie oto zapytanie:
[sql:1:ff16c9a585]SELECT * FROM part_pkg WHERE ( disabled IS NULL OR disabled = "" ) AND 0 < ( SELECT COUNT(*) FROM type_pkgs WHERE typenum = 1 AND type_pkgs.pkgpart = part_pkg.pkgpart )[/sql:1:ff16c9a585]
jednak MySQL zwraca błąd:

Kod

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 'SELECT COUNT(*) FROM type_pkgs WHERE typenum = 1

Co jest nie tak? Czy to zapytanie powinno wyglądać tak?
[sql:1:ff16c9a585]SELECT * FROM part_pkg WHERE ( disabled IS NULL OR disabled = "" ) AND 0 < ( SELECT COUNT(*) FROM type_pkgs WHERE (typenum = 1 AND type_pkgs.pkgpart = part_pkg.pkgpart) )[/sql:1:ff16c9a585]

Baza MySQL to: 4.0.16-log.