OK, so I have got
<?php
$Products = new WA_MySQLi_RS("Products",$DBConnection,0);
$Products->setQuery("SELECT products.*, productcategories.* FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID WHERE products.ProductLive = 1 ORDER BY products.ProductOrder ASC");
$Products->execute();
?>
Not sure how I now filter by CatPermlink based on the url
Cheers