SQL: select DISTINCT ID as ID,STOCKCODE,STOCKNAME,WEBDESCRIPTION as DESCRIPTION from tempstock where STOCKMAINGROUPID=:STOCKMAINGROUPID and STOCKSECONDGROUPID=:STOCKSECONDGROUPID and ISDELETED=:ISDELETED order by STOCKNAME asc limit 0,27 SQL Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ISDELETED' in 'where clause'
