---

Query Error!
   FILE:
       /home/uso1old/public_html/system/DataAccess.MySqli.php
   LINE NUMBER:
       49
   INVALID QUERY:
       SELECT distinct n.node_id, n.node_type_id, n.node_stub as stub, DATE_FORMAT(n.active_date, '%b %d, %y') as date, n.title, n.summary, n.views, n.rating, n.city, v.url, s.name AS state, n.zip, n.thumbnail, u.first_name, u.last_name, u.username, nt.short_name, n.product_id, SUBSTR(x.description, 1, 100) AS description, x.valued_price, x.sale_price FROM node AS n LEFT OUTER JOIN _video AS v ON n.node_id = v.node_id JOIN user AS u JOIN node_type AS nt ON n.node_type_id = nt.node_type_id JOIN AS x ON n.node_id = x.node_id LEFT OUTER JOIN state AS s ON n.state_id = s.state_id WHERE n.user_id = u.user_id AND (n.status_id = 3 OR n.status_id = 7 OR n.status_id = 6 ) AND u.status_id = 3 AND n.approved = 1 ORDER BY n.product_id DESC LIMIT 0, 10
   REASON:
       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 'AS x ON n.node_id = x.node_id LEFT OUTER JOIN state AS s ON n.state_id = s.state' at line 1

---