SELECT AL3.country_name, AL2.company_name, AL1.amount_charge 
FROM db1.dbo.history_adjustment AL1, db1.dbo.company AL2, db1.dbo.country AL3 
WHERE (AL1.customer_abbr=AL2.company_abbr AND AL2.country_code=AL3.country_code)  
  AND ((AL1.move_date > cast(@move_date AS DATE) AND AL1.ban NOT IN (0, 12345) 
  AND AL2.country_code<>'GB' AND AL1.charge_code NOT IN ('HJKL', 'HELO') AND AL1.amount_charge<>0))
ORDER BY AL2.company_name ASC, AL1.move_date DESC