Melder en fejl?

Jeg har noget kode hvor der kommer en fejl når man trykker på 'Nulstil' fejlen ser således ud:

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 'ORDER BY cnt DESC' at line 1

------------------------------------------------------------
Og koden således:

Min. antal solgte:
    <input type="text" name="numb" size="5" value="<?php if(isset($_GET["search"])) echo $_GET["numb"]; else echo '50'; ?>">
<br>
<br />
<input type="submit" name="search" value="Hent.." /> (<a href="move_locations1.php">Nulstil</a>)
<br>

</form>

<br>
<br>



<?
$start = mktime(0, 0, 0, $month , $dayOfMonth, $s_year);
$slut = mktime(0, 0, 0, $e_month , $e_dayOfMonth, $e_year);
$numb = $_GET["numb"];
echo $numb;

    $query = mysql_query("select count(orders_products.orders_id) AS cnt, orders_products.products_id, orders.date_purchased, products_name, product_certain_amount from orders_products LEFT JOIN orders ON orders.orders_id = orders_products.orders_id, products WHERE products.products_id = orders_products.products_id AND orders.todaystarted BETWEEN ".$start." AND ".$slut." AND (orders.orders_status != '4' OR orders.orders_status != '0') AND products_status = 1 GROUP BY orders_products.products_id HAVING cnt > ".$numb." ORDER BY cnt DESC") or die(mysql_error());
    echo '<table border="1"><tr><th width="20%">Lokation</th><th width="20%">Varenummer</th><th width="30%">Produkt</th><th width="20%">Antal solgte</th><th width="20%">Alt.&nbsplokali.</th></tr>';
    $x = 0;
    while($row = mysql_fetch_assoc($query))
    {
        $x++;
        $bgcolor = $x % 2 == 0 ? 'ffffff' : 'eeeeee';
        echo '<tr style="background-color:#' . $bgcolor . ';"><td>' . $row["product_certain_amount"] . '&nbsp;</td><td>' . $row["products_id"] . '</td><td>' . $row["products_name"] . '</td><td>' . $row["cnt"] . '</td><td> &nbsp;</td></tr>';
    }
    echo '</table>';
   
?>
-----------------------------------------------------

Nogle forslag??

Mvh.