user warning: 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 'weight' at line 13
query: SELECT d.* FROM uc_discounts d
LEFT JOIN uc_discounts_products dp ON d.discount_id=dp.discount_id
LEFT JOIN uc_discounts_terms dt ON d.discount_id=dt.discount_id
LEFT JOIN uc_discounts_skus ds ON d.discount_id=ds.discount_id
LEFT JOIN uc_discounts_classes dcl ON d.discount_id=dcl.discount_id
WHERE d.requires_code=0
AND (d.has_role_filter=0 OR d.discount_id IN(SELECT dr.discount_id FROM uc_discounts_roles dr, users_roles ur WHERE (dr.role_id=ur.rid AND ur.uid=0) OR dr.role_id=-1 OR dr.role_id=1))
AND (d.filter_type<>1 OR dp.product_id IN(-1,77))
AND (d.filter_type<>2 OR dt.term_id IN(-1,24))
AND (d.filter_type<>3 OR ds.sku IN('','30decRockClimb'))
AND (d.filter_type<>4 OR dcl.class IN('','product'))
AND (d.has_expiration=0 OR d.expiration>1283947112)
ORDER BY d.1 weight in /home1/computi6/public_html/ubercart/sites/all/modules/uc_discounts_alt/uc_discounts/uc_discounts.module on line 1675.
