select sizename,defaultprice,[hwproduct_size].id,[price] from ([hwproduct_size] LEFT JOIN ([xunjia_size_price] ON hwproduct_size.id = xunjia_size_price.sizeid) LEFT JOIN xunjia_price_parent ON (xunjia_size_price.parentid=xunjia_price_parent.id and (xunjia_price_parent.coid=10) AND (xunjia_price_parent.forcustomer like '%,1,%'))) where hwproduct_size.parentid=4
defaultprice,
[hwproduct_size].id,
[price]
from ([hwproduct_size]
LEFT JOIN ([xunjia_size_price] ON
hwproduct_size.id = xunjia_size_price.sizeid)
LEFT JOIN xunjia_price_parent ON
(xunjia_size_price.parentid=xunjia_price_parent.id)
and (xunjia_price_parent.coid=10) AND (xunjia_price_parent.forcustomer like '%,1,%')))
and hwproduct_size.parentid=4