[TYPO3-shop] How to use the "sql.where" statement in typoscript?

[Gunnar Jonsson]

In the tt_products documentation under configuration you find the following 
typoscript for calculating discount:

discountprice {
  10.type = count
  10.field = price  10.additive = 1
  10.where =
  10.prod.1 = 4.99
  10.prod.100 = 2.49
  10.prod.1050 = 2.39
  20.type = count
  20.field = price
  20.where =
  20.prod.1 = 6.99
  20.prod.100 = 2.59
  20.prod.1050 = 2.49
}

I also see that some are using "sql.where" in stead of just "where". Does it 
not matter which one you choose?

I have also seen some using and refering to tt_products 2.7.0:
sql.where = color = 'rot'

Does that mean that the "where" statement does not work until tt_products 
2.7.0 is released? I have tried to insert 'rot' in the color field under the 
variant folder for one product in order to make the discountcalculation only 
for that spesific product and not all products. But I could not get that to 
function.

Anyone who has used that "where" statement as a condition for using 
calculation on spesific products?

Regards,
Gunnar Jonsson