When: Tue, 23 Dec 2014 06:26:21 +1100
                  Remote Addr: 10.125.24.5
                  Forwarded For: 54.234.141.47
                  User Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
                  Host: bank.com.au
                  Query String: 
                  Request URI: /
                  argv[0]: 
                  error: No database selected
                  
			SELECT cc.creditcard_id as credit_card_id,
					i.creditcard_institution_short_name AS institution_short,
					i.creditcard_institution_long_name AS institution_long,
					i.creditcard_institution_path AS institution_path,
					cct.creditcard_type_name as credit_card_type,
					cc.creditcard_path AS credit_card_path,
					cc.creditcard_raw_product_name AS raw_product_name,
					cc.creditcard_full_product_name AS full_product_name,
					cc.creditcard_purchase_rate AS purchase_rate,
					cc.creditcard_cash_advance_rate AS cash_advance_rate,
					cc.creditcard_intro_purchase_rate AS intro_purchase_rate,
					cc.creditcard_intro_purchase_rate_term AS intro_purchase_rate_term,
					cc.creditcard_balance_transfer_rate AS balance_transfer_rate,
					cc.creditcard_balance_transfer_term AS balance_transfer_term,
					cc.creditcard_balance_transfer_conditions AS balance_transfer_conditions,
					cc.creditcard_purchase_interest_free_days AS purchase_interest_free_days,
					cc.creditcard_min_repay AS min_repay,
					cc.creditcard_annual_fee AS annual_fee,
					cc.creditcard_annual_fee_suffix AS annual_fee_suffix,
					cc.creditcard_additional_cards AS additional_cards,
					cc.creditcard_additional_card_fee AS additional_card_fee,
					cc.creditcard_rewards_program AS rewards_program,
					cc.creditcard_rewards_description AS rewards_description,
					cc.creditcard_annual_rewards_fee AS annual_rewards_fee,
					cc.creditcard_late_payment_fee AS late_payment_fee,
					cc.creditcard_interest_charged_from AS interest_charged_from,
					cc.creditcard_small_image AS small_image,
					cc.creditcard_large_image AS large_image,
					cc.creditcard_promo_text AS promo_text,
					cc.creditcard_affiliate_text_link AS affiliate_text_link,
					IF(cc.creditcard_affiliate_active = "yes", 1, 0) AS affiliate_active,
					cc.creditcard_content AS content,
					cc.creditcard_content_banks AS content_banks,
					cc.creditcard_priority AS priority
			FROM co_creditcard AS cc
			LEFT JOIN co_creditcard_institution as i ON i.creditcard_institution_id = cc.creditcard_creditcard_institution_co
			LEFT JOIN co_creditcard_type as cct ON cct.creditcard_type_id = cc.creditcard_creditcard_type_co
			WHERE 
				cc.creditcard_product_active = "yes"
			AND cc.creditcard_creditcard_type_co NOT IN (
				SELECT credit_card_id
				FROM _boomerang_finance.domain_exclude
				WHERE domain_id = 898
			)
			ORDER BY
				cc.creditcard_affiliate_active DESC,
				cc.creditcard_priority ASC,
				i.creditcard_institution_short_name ASC,
				cc.creditcard_raw_product_name ASC