: <br><Br>your query is: SELECT  pp.txn_id,iv.payment_id,iv.first_name,iv.receiptsname,iv.last_name,iv.CardHoldersName,iv.total_product_name,iv.total_product,iv.total_amount,iv.product_taken,iv.email as ivemail,iv.payment_status as ivstatus, iv.payment_id as ivAuthid,iv.invoice as ivtxnno, iv.transaction_type, iv.payment_date , iv.id,iv.receiptsname,iv.user_agent  FROM product_bought as iv LEFT JOIN paypal_log as pp ON iv.log_id = pp.id WHERE iv.deleted=0  and iv.user_id =   ORDER BY iv.id DESC