SELECT
product_info.product_id,
product_info.product_sku,
p_ebay_category.ge_category1,
pitem_specify.specify_name,
pitem_specify.specify_value
FROM product_info,p_ebay_category,pitem_specify
where product_info.product_id = p_ebay_category.product_id
and p_ebay_category.product_id = pitem_specify.product_id
and product_info.delete_status=0
product_info.product_id,
product_info.product_sku,
p_ebay_category.ge_category1,
pitem_specify.specify_name,
pitem_specify.specify_value
FROM product_info,p_ebay_category,pitem_specify
where product_info.product_id = p_ebay_category.product_id
and p_ebay_category.product_id = pitem_specify.product_id
and product_info.delete_status=0