test

SELECT * from pms_product where product_attribute_category_id=1 ;
SELECT * from pms_sku_stock where product_id=26;
SELECT * from pms_product_attribute_value  where product_id=26;
SELECT * from pms_product_attribute  where product_attribute_category_id=3;
SELECT * from pms_product_attribute where id in (SELECT product_attribute_id from pms_product_attribute_value  where product_id=26);
SELECT * from pms_product_category_attribute_relation where product_attribute_id in (SELECT product_attribute_id from pms_product_attribute_value  where product_id=26);;

SELECT * from pms_product_attribute_category where id =3;
SELECT * from pms_product_category where id=19;

SELECT * from pms_product_full_reduction where product_id=26;
SELECT * from pms_product_ladder where product_id=26;
SELECT * from pms_product_operate_log where product_id=26;
SELECT * from pms_product_vertify_record where product_id=26;

SELECT * from pms_product_attribute ;
SELECT * from pms_product_attribute_category;

SELECT * from ums_member ;
SELECT * from sms_home_advertise;
SELECT * from ums_member_receive_address ;

select * from oms_cart_item where member_id=17;
select * from oms_order where member_id=17;
select * from oms_order_item where order_id=51;
SELECT * from sms_coupon;
SELECT * from sms_coupon_history;
SELECT * from sms_coupon_product_relation;
SELECT * from sms_coupon_product_category_relation;

SELECT * from oms_order_setting;