Problem with if inside mysql

[fatnjazzy]

hi, every time I run this query the server does not respond and kind of crushes:

select agn., ass. ,
AVG(ass.totalRooms) AS totalRoomsAVG,
AVG(TO_DAYS(ass.exclusiveUntil) - TO_DAYS(ass.exclusiveFrom)) as exclusiveAVG,
AVG(ass.saleCommision) as saleCommisionAVG,
COUNT(if((ass.regOfficeId=ass.selOfficeId),1,0)) as regOfficeIdSUM

FROM tblAgentsOffices AS agn
LEFT join tblAssets AS ass on (agn.id=ass.regOfficeId)
inner JOIN tblAssets ON(agn.id=ass.regOfficeId and agn.id=ass.selOfficeId)
group by agn.id limit 0,5

any idea y?
thanks

[bastien]

You have any errors reported back to you via mysql_error()?

[Sxooter]

This part seems a little dodgy:

LEFT join tblAssets AS ass on (agn.id=ass.regOfficeId)
inner JOIN tblAssets ON(agn.id=ass.regOfficeId and agn.id=ass.selOfficeId)

You're joining to the same table two times, and the second time you join to it, the on clause doesn't mention that table, but the previous reference to it. Looks like you've got a cartesian product.