productsCatId = 133 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 133 ORDER BY productsSortOrder
- Offers
productsCatId = 3 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 3 ORDER BY productsSortOrder
- Mobile Phones
productsCatId = 251 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 251 ORDER BY productsSortOrder
- Mobile Apps
productsCatId = 4 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 4 ORDER BY productsSortOrder
- Mobilisation Solutions
productsCatId = 6 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 6 ORDER BY productsSortOrder
- Landlines
productsCatId = 273 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 273 ORDER BY productsSortOrder
- Broadband (O2)
productsCatId = 7 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 7 ORDER BY productsSortOrder
- IT Services (Support)
productsCatId = 2 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 2 ORDER BY productsSortOrder
- Ebusiness (Web Services)
productsCatId = 1 ... SELECT productsId, productsTitle, productsName, productsURL FROM tblproducts WHERE productsParent = 0 AND productsOnline = 1 AND productsCatId = 1 ORDER BY productsSortOrder
- Car Kits & Installs
