$query = 'select ec_pricebook.*, ec_pricebookproductrel.productid, ec_pricebookproductrel.listprice from ec_pricebook inner join ec_pricebookproductrel on ec_pricebookproductrel.pricebookid = ec_pricebook.pricebookid where ec_pricebookproductrel.productid='.$productid.' and deleted=0';