बिजली की खपत और आकार के अनुसार भारत के दस सबसे अच्छे रेफ्रिजरेटर

WordPress database error: [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 'rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="C' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='FROST FREE' and a.gross_volume>0 and a.gross_volume<=300 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10

WordPress database error: [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 'rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="C' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='FROST FREE' and a.gross_volume>300 and a.gross_volume<=400 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10

WordPress database error: [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 'rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="C' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='FROST FREE' and a.gross_volume>400 and a.gross_volume<=500 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10

WordPress database error: [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 'rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="C' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",NULL as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='FROST FREE' and a.gross_volume>500 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10

WordPress database error: [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 'rank,amazon_link as "buy_amazon",flipkart_link as "buy_flipkart",concat('<ul><li' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",flipkart_link as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='DIRECT COOL' and a.gross_volume<=200 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10

WordPress database error: [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 'rank,amazon_link as "buy_amazon",flipkart_link as "buy_flipkart",concat('<ul><li' at line 1]
select * from (select ff.id,concat(ff.brand,'-',ff.model) as title,NULL as rank,amazon_link as "buy_amazon",flipkart_link as "buy_flipkart",concat('<ul><li class="Capacity">',ff.gross_volume,' lts</li><li class="Electricity-Consumption">',ff.electricity_consumption,' units</li></ul>') as html from (select a.brand,a.model,a.gross_volume,a.electricity_consumption,round((a.electricity_consumption/a.gross_volume),3) as ratio, a.price , @curRank := IF(@prevVal=round((a.electricity_consumption/a.gross_volume),3), @curRank, @curRank+1) AS rank, a.brand as brand_name, @prevVal:=round((a.electricity_consumption/a.gross_volume),3) as prevval, @prevRank:=@curRank as prevrank,a.id,a.amazon_link,NULL as flipkart_link from j25_refrigerators as a,(SELECT @curRank :=0, @prevVal:=null, @prevrank:=null) as r where type='DIRECT COOL' and a.gross_volume>200 and a.electricity_consumption is not null and (a.amazon_link is not null and a.amazon_link<>'') order by 5) as ff where ff.rank<=10) a where buy_amazon is not null limit 10