Random thoughts:

• Check the results of the prepare() and the execute(), even though you've also got RaiseError=>1
• Dump the results of the built $sql string. Is it reasonable?
• Parenthesize the sub-compares in the WHERE clause.

xoxo,
Andy
--
<megaphone> Throw down the gun and tiara and come out of the float! </megaphone>