SELECT * FROM products, prices WHERE activeproduct = 1 AND (id = productid AND products.storeid = 'betterenergystore' AND (expiration_date > CURRENT_TIMESTAMP OR expiration_date IS NULL));