|
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 from items left join discounts on discounts.itemnum = items.itemnum and discounts.year = items.year inner join be_items_sub_cat on be_items_sub_cat.itemnum = items.itemnum and be_items_sub_cat.catyear = 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 where be_items_category.cat_id = and be_items_sub_cat.sc_id = 201 and items.year = 2018 and status = 1 order by items.itemnum, vendor; |
| |