SELECT
					deals.dealname,
					deals.dealshortdesc,
					deals.retailersku,
					deals.network,
					deals.dataspeed,
					deals.inclusivedata,
					deals.dealterm,
					deals.dealmonthlyprice,
					deals.dealurl,
					retailers.retailername
				FROM
					shoplaptop.deals
				INNER JOIN
					shoplaptop.retailers
				ON
					(retailers.idretailers = deals.idretailers)
				WHERE
					deals.idcategories = '1014'
				AND
					retailers.active = '1'
				 AND deals.dealterm > 0
				AND REPLACE(LOWER(deals.network), ' ', '-') = 't-mobile'
				ORDER BY