SELECT * FROM products 
						LEFT JOIN user ON billing_user_id = prod_user_id 
						LEFT JOIN billing ON billing_user_id = user_id 
						LEFT JOIN categories ON prod_cat_id = cat_id 
						WHERE billing_active = 1 AND billing_expires > NOW() AND prod_active = 1 AND prod_price < 50 
						GROUP BY prod_id ORDER BY prod_date DESC