WHERE conditie zorgt voor 0 resultaten

<?php
		$sql = "
			SELECT 
				$relation.menuid,
				$food_table.name foodname, 
				$food_table.price foodprice, 
 			   $food_table.foodorder foodorder, 
				$food_table.veget foodveget,
				$food_table.vegan foodvegan,
				$groups_table.catorder,
				GROUP_CONCAT($groups_table.catname ORDER BY $groups_table.catname SEPARATOR ', ') foodcats 
			FROM 
				$relation
			JOIN $food_table ON $relation.menuid = $food_table.id 
			JOIN $groups_table ON $relation.groupid = $groups_table.id 
			GROUP BY $relation.menuid
			ORDER BY $groups_table.catorder, $groups_table.catname, foodorder, foodname
//deze regel heb ik toegevoegd
			WHERE $groups_table.type=1
		";
?>