# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1582816327 -3600
# Node ID c583f446d6ca1ebd712b3bf158fb858198001b5c
# Parent  38b22ccb2bf84c456446e383d4c2081711622558
Changed order of products in production

diff -r 38b22ccb2bf8 -r c583f446d6ca www/includes/db_product.php
--- a/www/includes/db_product.php	Wed Feb 26 21:23:20 2020 +0100
+++ b/www/includes/db_product.php	Thu Feb 27 16:12:07 2020 +0100
@@ -545,7 +545,7 @@
 	 * SELECT, produce a list of products that are not yet Closed.
 	 */
 	if (isset($_GET['select']) && ($_GET['select'] == "inprod")) {
-		$query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY birth,code;";
+		$query = "SELECT record,name,code,birth,stage,brew_date_start,package_date FROM products WHERE stage != '11' ORDER BY stage,code,birth;";
 		$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 			$brews[] = array(