$_query = sprintf( 'SELECT tblitems.*, GROUP_CONCAT(tblcat.CatName) AS CatNames, tblloc.LocName AS LocNames FROM items AS tblitems JOIN itemlink AS tbllinks ON (tblitems.ItemID = tbllinks.ItemID AND tbllinks.LocID=%d AND tbllinks.CatID=%s) JOIN categories AS tblcat ON (tblcat.CatID = tbllinks.CatID) JOIN locations AS tblloc ON (tblloc.LocID = tbllinks.LocID) WHERE tblitems.Enabled=1 GROUP BY tblitems.ItemID ORDER BY tblitems.ItemDate DESC LIMIT %d, %d', intval($LocID), (($CatID == 0) ? $this->mClean('%') : intval($CatID)), intval($startAt), intval($MaxItems) );