Sep 24, 2020 04:22 PM|peterthegreat|LINK
The problem with the solution is that both Products and Product_items have the same categoryid column names? so would produce an error.
the sortexpression is related to extra script not included and did not seem relevant while testing for errors.
I have multiple queries in procedure showing same code!! except for where clause. I am hoping to remove all occurances and just execute one statement at bottom,later.