You have a couple of recordsets that seem to be repeated an unused.
I think you can update line 477 from $row_RsSalesCollateral['Headline'] to $row_WADASalesCollateral['Headline'].
Then you can delete lines 174-192.
That isn't the source of your problem, just clean up.
Next add this to the body of the page:
<?php echo($query_WADASalesCollateral); ?>
That will show you the resulting query with the filter and allow you to see why it isn't working.