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