Energyshop.com - Energy for your home
Electricity Natural Gas Conservation Contact Us Site Map
Energyshop
Residential Services
 
Natural Gas, Electricity for Business Customers
CDM for LDC Professionals

  

Natural Gas Choices for Your Home

Deregulated Natural Gas Supply Rates 
Commodity prices in ¢/m³  
Supplier

show suppliers alphabetically
1 Yr.
Fixed


show 1 year fixed prices in ascending order first
3 Yr.
Fixed


show 3 year fixed prices in ascending order first
5 Yr.
Fixed


show 5 year fixed prices in ascending order first
Features

Sort
Signup
arrow
MyRate Energy 10.49 -- 15.8 Fixed Price Protection Program view offer or sign-up online
Just Energy 16.9 24.9 -- 3 year Price Protection Program with 100% Green 19.9 /m + 5.0/m Green view offer or sign-up online
RiteRate 15.9 15.7 15.5 Plus 4.6406/m3 transportation --

By default, the suppliers are sorted by the number of customers signed on this site.

  • No signup fees apply. Prices include utility administrative and compressor fuel charges.
  • Take note of differences in automatic renewal in the Term clauses.
  • Transportation Note: Transportation is usually provided by Enbridge at their regulated long haul rate. If you are not on a contract now, or if you allow at least 1 month between the expiry of your current contract and the new contract, you will be charged either the long haul rate or the short haul rate regulated Enbridge rate. If you move directly from one marketer to another, or stay on a current contract, there may be a different rate based on that marketer's contract terms and conditions.
  • Enbridge Regulated Transport Rates are as follows:

  • Transportation Charge - From Empress: 4.980 c/m3 (this is the long haul rate)
  • Transportation - From Dawn: 1.040 c/m3 (this is the short haul rate)

  • When comparing rates make sure you compare the commodity rate plus the transport rate that your marketer says you will be paying to the utility. You normaly only pay one of the above gas transportation rates and not both.

    .

    Ontario Carbon Taxes:

  • Cap and Trade Customer Related Charge 3.3181 c/m3 (buried in the distribution charge)
  • Cap and Trade Facility Related Charge 0.0337 c/m3 (buried in the distribution charge)
  • Disclaimer: Energyshop provides prices on best efforts basis and is not responsible for errors.

    Notes:

    Companies above are licensed by the Ontario Energy Board.

    Questions? Go to our FAQs or post a question on the Ontario Natural Gas Price discussion forum.

    If you have a business or a group of related business using more than 50,000 m3 per year:  deregulated natural gas for your business.

    If you have been on a contract with a marketer that is coming to an end, make sure that you formally notify the marketer by responding to the renewal notice sent to you, or by sending a letter to the marketer! If you don't, you will likely be renewed automatically. More

    Regulated Enbridge Gas Distribution Inc. Rates

     
    Regulated Residential Rates based on 3,100 m³/ year
    Rate type Gas Supply
    ¢
    Adjust.
    ¢
    Delivery Chg
    ¢
    Transportation
    ¢
    Total
    ¢/m³
    Monthly
    Fee
    Estimated
    Bill
    Residential 1st April 2018 - Rate 1 9.45 0.21 10.02 4.75 24.43 $20.00 $997.42
    Enbridge Gas Distribution Inc. rates approved effective: April 1, 2018



    *Note: The Gas Supply Charge is what will change when you contract with a gas marketer. Gas marketers now have the option to control the charge for Transportation instead of allowing the utility to charge this item. Not all marketers have taken over this charge.

    The Adjust. column represents adjustments to the gas supply charge made by the utility (also known as a rate rider). It is usually due to the utility charging more or less than it cost them to buy the gas. This creates a surplus or deficit that has to be either paid back to customers, or collected as a surcharge.

    Unlike fixed rates from a gas marketer, when you purchase gas from the utility the rate is subject to change at any time by the utility and can change retroactively in an annual balancing calculation. In the tables above the Estimated Bill is the total that a customer would pay over a full year for the volume shown. To see how your bill will change with a fixed rate from a gas marketer, select a rate from the table at top and insert this rate into the light blue box above.

    Comparing and deciding among the various offers

    There are 2 decisions. The first is whether to continue with the utility's variable rate, which changes every 3 months and may have retroactive charges, or a fixed term rate with a marketer of 1-5 years. You can choose to lock in for a long period at a fixed rate, or choose totally variable rates and take your chances that rates won't go up. This decision depends on your budget and what you expect gas prices to do over the next few years. You can see the utility's current rate in the chart above.

    If you decide to go with a fixed price contract, your second decision is between marketers. Use our price chart to compare prices and features, and view the terms and conditions from each supplier.

    Learn more about deregulated gas markets and marketers.

    Regulated rates are not fixed rates, nor can they be

    In Ontario, the Ontario Energy Board (OEB) regulates utility rates. When market prices go up, utilities apply to the OEB to change rates. This is for future rates, but can they can also apply to make a retroactive charge! They can't offer fixed contracts. When you sign up with an energy marketer, you can avoid these unexpected rate changes. As you can see from the previous chart, marketers can offer you an arrangement to fit your situation.

    What's included in retail gas prices

    If you choose to buy from a gas marketer, your gas delivery won't change. You will still get a bill from your distribution utility which will indicate a Delivery charge and a Transportation Charge (usually the responsibility of your utility) - about 1/3 of your bill that goes to the utility, and a Gas Supply Charge - the remaining 2/3 that goes to the competitive gas supplier you chose. If you have rental equipment or a service contract, these will appear as well. The transportation charge is set by the marketer in Union Gas South territory and can also be the responsibility of the marketer in the Enbridge territory, depending on your contract with the marketer.

    Remember this split when comparing costs. Gas marketers offer rates on your Gas Supply charge, which is about 2/3 of your bill.

    Your utilities distribution rates are regulated by the Ontario Energy Board. As a result, when a promotional message claims a 10% saving, it is referring to 10% of the 2/3 controlled by the competitive supplier.

    Example: A typical annual gas bill is $1,200. One third of that, $400, is a regulated transportation and delivery charge. The remaining $800 is the gas supply charge. A competitive gas supplier is offering a 10% saving is offering a saving of $80, which is 10% of the $800 gas supply charge.

    Energyshop.com provides unbiased natural gas price and electricity cost comparisons. This is valuable information and education for home and commercial, house and business. It's insurance against paying too much on current utility rates. We have historical data, supplier information, home heating calculations, natural gas price charts, maps to help you find your utility area, links to solar energy, green power and wind power sites.

    There are many suppliers with consumer energy rates, natural gas prices and electricity costs in Canada including Direct Energy, Just Energy, Superior (SEM), Planet, Summitt, Firefly, Tetra, Epcor, Enmax, Constellation NewEnergy (CNE), Transalta, Universal Energy and RiteRate. This information on electricity suppliers and open market rates is valid for Ontario, Alberta, Quebec, Manitoba, Saskatchewan, and BC (British Columbia). It covers gas distributed by Enbridge, Union, Kitchener utilities, Kingston, ATCO, Direct Energy Regulated Services, Teresen, Epcor ENMAX and GazMet. Canadian natural gas prices are available for deregulated provinces.

    Some US states are deregulated and several have quite active markets. Georgia, Texas, Pennsylvania, Illinois and Ohio are active in 2007 and have the longest history. The most active marketers in Georgia are MX Energy, Georgia Natural Gas, Coweta-Fayette EMC, Gas South, GasKey, Infinite Energy, SCANA, Vectren and Walton EMC.

    This price comparison search helps you find the cheapest electricity and cheapest natural gas among Canadian energy companies. While energy price information does not have the sex appeal of TV and electronics, it actually saves you much more money in your personal budget. If you sign a contract for 1 cent less per M3 (27 cents/GJ), you will save about $30 per year. The difference between the highest and lowest price in Ontario is usually 8 cents, so signing with the lowest cost provider will save you $ 240 per year. Think about this when the door to door marketers and telemarketers talk to you.

    We also provide educational information and links on such issues as Nox and Sox and CO2 reduction (Nitrous Oxide and Sulphur Dioxide and Carbon Dioxide). We are a consumer report on the energy industry. Real estate professionals like the information we provide on utility bills, cost history, on heating system conversion costs, and energy price forecasts to help their clients manage expenses and cost of living.

    Links to the Hourly Ontario Energy Price HOEP are also available to guage the Ontario power industry. The HOEP is also referred to as the spot market for electricity, and the open market rate. We are working on links to the Alberta electricity power pool

    Business customers have many more options for buying natural gas and electricity. They can buy full requirements gas contracts with all of the delivery and compressor fuel charges added, or they can buy naked price contracts based on NYMEX quotes, and pay all of the other charges quoted separately. Electricity can be either a fixed price for every kWh used regardless of timing, or a business can buy a block of electricity to best match their time of use. Business customers can buy from companies such as Coral (Shell Trading), Sempra, CNE, Direct Energy,




Debugging Information
ColdFusion Server Standard 11,0,14,307976
Template /es/prices/ON/gasON.cfm
Time Stamp 24-Jun-18 12:51 AM
Locale English (Canadian)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.145.103.69
Host Name 54.145.103.69


Execution Time

Total Time Avg Time Count Template
78 ms 78 ms 1 C:/inetpub/wwwroot/es/prices/on/gason-content.cfm
78 ms 78 ms 1 top level C:\inetpub\wwwroot\es\prices\on\gason.cfm
47 ms 47 ms 1 CFC[ C:/inetpub/Scripts/components/PriceTable.cfc | getConsumerPriceTable(argumentCollection = [complex value]) ] from C:/inetpub/Scripts/components/PriceTable.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/Scripts/components/RateRider.cfc | GetAlertMessage(2) ] from C:/inetpub/Scripts/components/RateRider.cfc
0 ms 0 ms 1 C:/inetpub/Scripts/newldcgas.cfm
0 ms 0 ms 1 C:/inetpub/Scripts/rateengine.cfm
0 ms 0 ms 1 C:/inetpub/Scripts/setServerAreas.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/anti-sql-injection.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/es/Application.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/es/prices/on/openwindow.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/copyright-notice.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/fb-script-rec.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/fb-widget-rec.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/navigation/mainmenu.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/navigation/residential-left-menu.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/other-links-gas-table.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/esfw/page_headers/header-residential.cfm
0 ms 0 ms 1 CFC[ C:/inetpub/Scripts/components/ContactForm.cfc | setKey() ] from C:/inetpub/Scripts/components/ContactForm.cfc
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
94 ms  TOTAL EXECUTION TIME
red = over 500 ms average execution time


SQL Queries

getprov (Datasource=M3Direct, Time=0ms, Records=78) in C:\inetpub\wwwroot\es\prices\on\gason-content.cfm @ 00:51:16.016
Select province, province_code from province
getLdcName (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\wwwroot\es\prices\on\gason-content.cfm @ 00:51:16.016
SELECT L.ldc_id, L.ldc_name, U.units, L.volume_res
FROM   ldc L INNER JOIN units U on L.units_id = U.units_id
WHERE  ldc_id=2 
qryLDC (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:51:16.016
SELECT LTRIM(RTRIM(ldc_name)) AS [Name]
FROM   ldc
WHERE  (ldc_id = 2)
qryPrice (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:51:16.016
SELECT     P.gassupply as Price, P.rate_rider as Rider, P.ldcgas_startdate as StartDate, P.ldcgas_enddate as EndDate, P.ldc_id, RTRIM(LTRIM(P.ldcgas_numonic)) as Numonic, RTRIM(LTRIM(ldcGas)) as sRate, 0 as Total, '' as sValue
FROM         ldcgas P 
WHERE     (P.ldcgas_enddate >= GETDATE()) AND (P.ldc_id = 2) AND (P.ldcgasclass = 'residential')
ORDER BY StartDate, Numonic
qryUnits (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\RateRider.cfc @ 00:51:16.016
SELECT     RTRIM(LTRIM(U.units)) as Units
FROM       ldc L
INNER JOIN units U ON L.units_id = U.units_id
WHERE     (L.ldc_id = 2)
qryLDC (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT RTRIM(ldc_name) AS ldc_name, ldc_id, RTRIM(ldc_units) AS ldc_units, units_id, RTRIM(Province_code) AS Province, RTRIM(enertype) AS enertype, volume_res, volume_scom
FROM   LDC
WHERE (ldc_id = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

qryLDCs (Datasource=M3Direct, Time=0ms, Records=6) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT RTRIM(ldc_name) AS ldc_name, ldc_id, RTRIM(U.units) AS ldc_units, L.units_id, RTRIM(Province_code) as Province, volume_res, volume_scom
FROM   LDC L INNER JOIN units U ON L.units_id = U.units_id
WHERE (Province_code = 'ON') AND (enertype = 'gas') AND NOT (ldc_id IN (3,6,18,356,359,393,385))  AND ldc_active='y'
ORDER BY ldc_name
getLdc (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT volume_res as Volume
FROM ldc
WHERE (ldc_id=2)
qryExcludedSuppliers (Datasource=M3Direct, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT supplier_id as ID
		FROM   supplieroema
		WHERE  (nameofsupplier LIKE 'Direct%Energy%Business%')
		
qryPrice (Datasource=M3Direct, Time=0ms, Records=7) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT DISTINCT 
P.supplier_id, RTRIM(P.nameofsupplier) AS nameofsupplier, P.oemaprice_id, RTRIM(P.pricetype) AS pricetype, P.priceenddate, RTRIM(P.billingtype) AS billingtype, RTRIM(P.priceterm) AS priceterm, RTRIM(P.priceterm) + '<br>' + RTRIM(P.pricetype) AS priceclass, RTRIM(P.bonus) AS bonus, RTRIM(P.feature) AS bonusdesc, P.priceyear1, P.priceyear2, P.priceyear3, P.priceyear4, P.priceyear5, P.oemaprice_dstamp, ISNULL(p.lowvolumelimit,0) as lowvolumelimit, p.highvolumelimit, RTRIM(S.nameofsupplier) as SupplierName, ISNULL(S.energyshop,'no') as energyshop, P.isGreen, P.isCarbonNeutral, P.pricewords
FROM       oemaprice P
INNER JOIN price_ldc PL ON P.oemaprice_id = PL.oemaprice_id
INNER JOIN supplieroema S ON P.supplier_id = S.supplier_id
WHERE
(GETDATE() BETWEEN P.pricestart_dstamp AND P.priceenddate)

AND (P.show_on_eshp = 'y' OR P.show_on_eshp IS NULL)
AND (P.supplier_id <> '') AND (PL.ldc_id = 2)
AND (P.lowvolumelimit <= 3100) AND (P.isCommercialOnly = 0) 
AND (ISNULL(S.residential,'no') = 'yes') AND (P.onChart = 1)
ORDER BY RTRIM(P.nameofsupplier), RTRIM(P.priceterm)
qryUniquePrices (Datasource=, Time=0ms, Records=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT DISTINCT priceclass
FROM   qry
ORDER BY months,priceclass
qrySupplierBase (Datasource=, Time=0ms, Records=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT DISTINCT nameofsupplier, supplier_ID as ID, energyshop as Online
			FROM   strQueries.qryPrices
			ORDER BY energyshop DESC, nameofsupplier
			
qrySignupOnly (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT *
			FROM   qrySupplierBase
			WHERE  (online = 'yes')
			
qryTopSellers (Datasource=M3Direct, Time=0ms, Records=100) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT     TOP 100 R.quote_request_id, RP.oemaprice_id, RS.supplier_id
			FROM         quote_request R INNER JOIN
                      quote_price RP ON R.quote_request_id = RP.quote_request_id INNER JOIN
                      quote_supplier RS ON R.quote_request_id = RS.quote_request_id INNER JOIN
                      ldc L ON R.quote_ldc = L.ldc_name
			WHERE     (R.quote_proc_dstamp IS NOT NULL) AND (NOT (R.quote_name LIKE '%test%')) AND (RP.oemaprice_id NOT IN
                          (SELECT     p.oemaprice_id
                            FROM          supplieroema s INNER JOIN
                                                   oemaprice p ON s.supplier_id = p.supplier_id
                            WHERE      (s.nameofsupplier LIKE 'energyshop%') OR
                                                   (s.nameofsupplier LIKE 'm3%')))
			AND (L.ldc_id = 2)
			
			AND (RS.supplier_id IN (382,397))
			ORDER BY R.quote_request_id DESC
			
qryTopSellers (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT supplier_id as ID, COUNT(supplier_id) as Total
			FROM   qryTopSellers
			GROUP BY ID
			ORDER BY Total DESC, ID
			
qryWhoWasExcluded (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
				SELECT DISTINCT ID, Online
				FROM   qrySupplierBase
				WHERE  (ID NOT IN (397,382))
				ORDER BY Online DESC, nameofsupplier
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 397)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 382)
				
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
				SELECT *
				FROM   qrySupplierBase
				WHERE  (ID = 272)
				
qrySorted (Datasource=, Time=15ms, Records=7) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT   *
			FROM     strQueries.qryPrices
			ORDER BY supplier_id
			
qrySupplierNames (Datasource=, Time=0ms, Records=3) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
			SELECT *
			FROM qrySupplierNames
			WHERE (nameOfSupplier <> '') OR (ID <> 0)
			
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 397) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=2) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 397)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 397) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 397)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=0) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 382) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 382)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 382) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 382)
	
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '1 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '3 Year<br>Fixed Price')
		
qrySingleSupplier (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT *
		FROM qrySorted
		WHERE (supplier_id = 272) AND (priceclass = '5 Year<br>Fixed Price')
		
qryBonus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT bonus
	FROM qrySorted
	WHERE (supplier_id = 272)
	ORDER by bonus DESC
	
qryBonusTxt (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
		SELECT DISTINCT bonusdesc
		FROM qrySorted
		WHERE (supplier_id = 272) AND (bonusdesc <> '')
		
qrySignupStatus (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
	SELECT DISTINCT energyshop
	FROM   qrySorted
	WHERE  (supplier_id = 272)
	
getPriceDate (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\components\PriceTable.cfc @ 00:51:16.016
SELECT MAX(oemaprice_dstamp) as LastChange
FROM   strQueries.qryPrices
getldcgas (Datasource=M3Direct, Time=0ms, Records=1) in C:\inetpub\Scripts\newldcgas.cfm @ 00:51:16.016
	Select distinct
	ldcgasclass, gassupply, ldcgas, ldcgas_startdate, ldcgas_numonic, ldcgasadmin, volume_max, volume_default, ldcgasfuel, monthlycharge, dist_wstep1, dist_wstep2, dist_wstep3, dist_wstep4, dist_wstep5, dist_wstep6, dist_wstep7, dist_sstep1, dist_sstep2, dist_sstep3, dist_sstep4, dist_sstep5, dist_sstep6, dist_sstep7, transp_sstep1, transp_sstep2, transp_sstep3, transp_sstep4, transp_sstep5, transp_wstep1, transp_wstep2, transp_wstep3, transp_wstep4, transp_wstep5, dist_vol1, dist_vol2, dist_vol3, dist_vol4, dist_vol5, dist_vol6, dist_vol7, transp_vol1, transp_vol2, transp_vol3, transp_vol4, transp_vol5, rate_rider
	from ldcgas where
	ldc_id = ?
	and ldcgas_enddate > GETDATE()
	and ldcgasclass = 'residential'
	order by ldcgas_numonic
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

qryCheckForRiders (Datasource=, Time=0ms, Records=1) in C:\inetpub\Scripts\newldcgas.cfm @ 00:51:16.016
SELECT rate_rider
FROM  getldcgas 
WHERE  (rate_rider <> 0)


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\es\prices\on\gason.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energyshop.com
HTTP_REFERER=
HTTP_URL=/es/prices/ON/gasON.cfm?ldc_id=2
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=209.250.137.194
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\es\prices\on\gason.cfm
QUERY_STRING=ldc_id=2
REMOTE_ADDR=54.145.103.69
REMOTE_HOST=54.145.103.69
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/es/prices/ON/gasON.cfm
SERVER_NAME=www.energyshop.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=
Cookie Variables:
CFID=10918716
CFTOKEN=9947cd82e62cb0f-E14DCF39-F0A5-D502-0AF8F8442E02BFB1
Session Variables:
bremovebusiness=false
rateclass=res
scontactkey=B3L4VQFO64cJEw
sessionid=BBA00081552E15CC053C410B5607F452.cfusion
urltoken=CFID=10918716&CFTOKEN=9947cd82e62cb0f-E14DCF39-F0A5-D502-0AF8F8442E02BFB1&jsessionid=BBA00081552E15CC053C410B5607F452.cfusion
URL Parameters:
ldc_id=2
Debug Rendering Time: 0 ms