|
There was an Error processing the request. Select discounts.discount, items.itemnum, left(items.itemnum, 1) as item_code, image, descr, price, be_types_items.type_id, item_category.ic_category from items left join discounts on discounts.itemnum = items.itemnum and discounts.year = items.year inner join be_items_category on be_items_category.itemnum = items.itemnum and be_items_category.catyear = items.year inner join be_types_items on be_types_items.itemnum = items.itemnum and be_types_items.catyear = items.year inner join item_category on item_category.ic_id = be_items_category.cat_id where be_items_category.cat_id = and items.year = 2018 and items.status = 1 and items.itemnum != 'A996' order by items.itemnum, vendor; |
| |