VbzCart/queries/qryCbx Orders

About

 * Requires:
 * Used by: various forms, I think
 * Fields:
 * ID_Pull and WhenNeeded are needed for

SQL
CREATE OR REPLACE VIEW qryCbx_Orders AS SELECT ID, CONCAT_WS(' due ',CAST(Number AS CHAR),DATE_FORMAT(WhenNeeded,'%Y-%m-%d')) AS Descr, ID_Pull, WhenNeeded FROM core_orders ORDER BY CONCAT(IFNULL(SortPfx,''),Number) DESC;