If you want the where to be contingent upon all the AND statements put them in parens.
eg:
WHERE (
AND a.paksh = b.paksh
AND a.tithi = b.tithi
AND b.date BETWEEN CURdate( )
AND (CURdate( ) +9)...