SELECT p.product_id, p.description, p.price, b.basket_id, b.username, b.number_ordered
FROM products p, baskets b
WHERE p.product_id = b.product_id
AND <TABLE name>.username = admin
AND <TABLE name>.basket_id = 15043413