Hello Wojciech, Tuesday, February 7, 2006, 4:31:23 PM, you wrote: ok this is KOHA problem: http://bugs.mysql.com/bug.php?id=14047 Yes, this is new, but correct behaviour ob 5.0.12 and newer versions. It is documented (http://dev.mysql.com/doc/refman/5.0/en/join.html): "This means that some queries that appeared to work correctly prior to 5.0.12 must be rewritten to comply with the standard. For example, a query of the form SELECT t1.id,t2.id,t3.id FROM t1,t2 LEFT JOIN t3 ON (t3.id=t1.id) WHERE t1.id=t2.id; will be interpreted in MySQL 5.0.12 and later as SELECT t1.id,t2.id,t3.id FROM t1,( t2 LEFT JOIN t3 ON (t3.id=t1.id) ) WHERE t1.id=t2.id; Such a query must now be written like so: SELECT t1.id,t2.id,t3.id FROM (t1,t2) LEFT JOIN t3 ON (t3.id=t1.id) WHERE t1.id=t2.id;" -- <wojciech@zatorski.net> tel. +48 509-855-239; GG: 1500861; Skype: zatorski http://www.Zatorski.Net -- You cannot kill time without injuring eternity. -- Thoreau