SELECT ...
FROM `acu_cart`
INNER JOIN `acu_country` sc ON sc.`country_id` = `acu_cart`.`shipping_country_id`
INNER JOIN `acu_country` cc ON cc.`country_id` = `acu_cart`.`card_country_id`
LEFT JOIN `acu_creditcard_type` ct ON ct.`creditcard_type_id` = `acu_cart`.`card_type_id`
LEFT JOIN `acu_user` u ON u.`user_id` = `acu_cart`.`user_id`
...
There's actually a lot more than that (9 joins in fact). If you're going to be doing lots of them make sure you've got indexes defined for tables that'll have loads of records if you're not joining on the primary key otherwise it'll be hellishly slow.