Bug Invaild SQL

Database error in vBulletin 4.2.2:

Invalid SQL:

                SELECT
                        COUNT(*) AS count
                FROM (
                        SELECT
                                COUNT(*) AS count
                        FROM dbtech_classifieds_listing AS l
                        LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
                        LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
                        LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
                        LEFT JOIN user AS u ON u.userid = l.userid
                        WHERE  AND l.enddate > 1401314268
                        AND l.ended = 0
                        AND l.moderated = 0
            AND l.enddate > 1401227868
            AND l.cancelled = 0
            GROUP BY l.listingid
    ) AS total;

MySQL Error   : You have an error in your SQL syntax; check the manual  that corresponds to your MySQL server version for the right syntax to  use near 'AND l.enddate > 1401314268
                        AND l.ended = 0
                        AND l.moderated = 0
            AND l.' at line 11
Error Number  : 1064
Request Date  : Tuesday, May 27th 2014 @ 04:57:48 PM
Error Date    : Tuesday, May 27th 2014 @ 04:57:48 PM
Script        : [URL]http://www.mysite.com/classifieds/[/URL][]=-1&categorychild=1&do=search&dosearch=Search&exactname=1&keywords=1&keywordstype=1&listingtypes[]=-1&orderby=descending&searchdate=1&searchscope=1&securitytoken=guest&sortby=dateline&username=1