SELECT t.id, t.name, t2.t1, t4.t3
FROM
  (SELECT types.id, types.name FROM types) t,
  (SELECT type_id, COUNT(*) as t1 FROM oborudovanie GROUP BY type_id) t2,
  (SELECT type_id, COUNT(*) as t3 FROM oborudovanie WHERE id_zayavki=0 AND remont=0 AND skrito=0 GROUP BY type_id) t4
WHERE t.id=t2.type_id AND t.id=t4.type_id

#1064 - 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 types.id, types.name FROM types) t, (SELECT type_id, COU