История изменений

Исправление Jaberwock, 15.08.14 17:44 (текущая версия) :

select p1.product from `products_characteristics` p1 join `products_characteristics` p2 on p1.product=p2.product where p1.characteristic = '8' AND p1.value = '12' AND p2.characteristic` = '9' AND p2.value in ( 'Samsung' ,'HTC') limit 1

Исходная версия Jaberwock, 15.08.14 17:42:

select p1.product from from `products_characteristics` p1 join `products_characteristics` p2 on p1.product=p2.product where p1.characteristic = '8' AND p1.value = '12' AND p2.characteristic` = '9' AND p2.value in ( 'Samsung' ,'HTC') limit 1