select u.oli_id, u.form_type,u.price,ps.service_provided FROM users as u JOIN payment_detail as p ON u.oli_id = p.u_oli_id JOIN package_services as ps ON u.form_type = ps.service_code LEFT JOIN planed_users as pu ON u.oli_id = pu.oli_id where pu.oli_id IS NULL AND( (u.form_type IN('PCR','OPC','SEC8','LLP') AND ps.package_name = 'Mega' AND p.p_ammount='35399.00') OR (u.form_type IN('PCR','OPC','SEC8','LLP') AND ps.package_name = 'Start' AND p.p_ammount='3539.00') OR (u.form_type IN('PCR','OPC','SEC8','LLP') AND ps.package_name = 'Basic' AND p.p_ammount='9439.00') OR (u.form_type IN('PCR','OPC','SEC8','LLP') AND ps.package_name = 'Smart' AND p.p_ammount='20059.00') )