Facebook Twitter Youtube MYhpi
Browse by Brand:
HPI Wants you! Introducing MYhpi, Everyone has a chance to win BIG! Register now for HPI's new VIP experience! This could be yours!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND mProducts.catId!='BULK' AND hpiUK.mProducts.classID Not Like' at line 7
	SELECT DISTINCT mProducts.catId, mProducts.subCatId, mCatagories.name AS mainCat, mSubCatagories.name AS subCat
					FROM hpiUK.mProducts
					LEFT JOIN hpiUK.mCatagories ON (mProducts.catId = mCatagories.id)
					LEFT JOIN hpiUK.mSubCatagories ON (mProducts.subCatId = mSubCatagories.subCatId)
					WHERE mSubCatagories.name != '' AND mSubCatagories.name IS NOT NULL

						AND ()
						AND mProducts.catId!='BULK'
						AND hpiUK.mProducts.classID Not Like '%-DISC'

					ORDER BY mCatagories.name ASC, mSubCatagories.name ASC