|
|
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 items.status = 1 order by items.itemnum' at line 1
|
| Select items.itemnum, left(items.itemnum, 1) as vendor, items.image, items.descr, items.price from be_types_items inner join items on items.itemnum = be_types_items.itemnum and items.year = be_types_items.catyear where be_types_items.type_id = 2 and items.year = and items.status = 1 order by items.itemnum; |
| |
