SELECT 
      CatItems.__id, 
      CatItems.Category, 
      CatItems.Name, 
      CatItems.Code, 
      CatItems.Price, 
      CatItems.DollarPrice, 
      CatItems.smallImage, 
      CatItems.SmallDesc, 
      CatItems.Parameters, 
      CatItems.isNew, 
      CatItems.isSpec, 
      CatItems.isRack, 
      CatItems.Extra, 
      CatItems.Available, 
      CatItems.Awaiting, 
      CatItems.TemporarilyNotManufactured, 
      CatCategories.Discount, 
      CatCategories.isDollar, 
      CatCategories.DirectoryName, 
      CatCategories.Parent as cparent, 
      CatCategories.Name as cname
    FROM 
      CatItems
    INNER JOIN 
      CatCategories
    ON 
      CatItems.Category = CatCategories.__id
    WHERE  
       CatItems.Category=0 
    AND 
      CatItems.Active=1
    ORDER BY 
      CatItems.Available desc, 
      CatItems.Awaiting desc, 
      CatItems.CustomOrder LIMIT 12