Dreamweaver recordsets are very picky when it comes to hand coding. The tiniest update can make it not found. In your case it is the extra space character before the semicolon on line 201.
You have:
LEFT JOIN media ON media.id = customer_ads.media_id" ;
It should be:
LEFT JOIN media ON media.id = customer_ads.media_id";
Removing the space makes the recordset display in the server behaviors window.