select p.id from product p,productattribute a1
where p.productcode=a1.productcode
and p.productcode in
(
select `productcode` from productattribute where productcode in ( select `productcode` from product where model ="Ladies0001")
and `attributevalue`= and `attribute`=1
)
and a1.`attribute`=2 and a1.attributevalue=
Lorem Ipsum is simply dummy text of the printing and type setting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s.
