- problem: DB Error: syntax error --> SELECT `stock`.`stock_uid`,
`stock`.`stock_name`,
`stock`.`reference`,
`stock`.`period_uid`,
`stock`.`maker_uid`,
`stock`.`place_uid`,
`stock`.`style_uid`,
`stock`.`year`,
`stock`.`circa`,
`stock`.`dimensions`,
`stock`.`weight`,
`stock`.`condition`,
`stock`.`saleprice`,
`stock`.`costprice`,
`stock`.`comment`,
`stock`.`meta_keywords`,
`stock`.`status_uid`,
UNIX_TIMESTAMP(`stock`.`timestamp`) as `timestamp`,
UNIX_TIMESTAMP(`stock`.`created`) as `created`,
UNIX_TIMESTAMP(`stock`.`available`) as `available`,
UNIX_TIMESTAMP(`stock`.`datesold`) as `datesold`
FROM (`stock`) WHERE stock.status_uid IN (1,3,4,6) order by `saleprice`, `available` DESC, `created` DESC LIMIT -1,20 [nativecode=1064 ** 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 '-1,20' at line 22]
|
|
Leopard Antiques |
 |
|