$query1 = "SELECT jos_users.email
				, jos_users.id
				, jos_users.usertype
				, jos_users.block
				, jos_comprofiler.firstname
				, jos_comprofiler.lastname
				, jos_comprofiler.user_id
				, jos_comprofiler.approved
				, jos_comprofiler.confirmed
				, jos_comprofiler.banned
				, jos_comprofiler.cb_address1
				, jos_comprofiler.cb_city
				, jos_comprofiler.cb_state
				, jos_comprofiler.cb_zip
				, jos_comprofiler.phone
				, jos_comprofiler.fax
				, jos_comprofiler.cb_country
				, jos_comprofiler.cb_primaryresponsibility
				, jos_cbsubs_subscriptions.user_id AS sub_ID
				, jos_cbsubs_subscriptions.plan_id
				, jos_cbsubs_subscriptions.status
				, jos_cbsubs_subscriptions.expiry_date
				, jos_cbsubs_subscriptions.subscription_date
				, jos_cbsubs_subscriptions.last_renewed_date
				, jos_cbsubs_payment_baskets.payment_status
				, jos_cbsubs_payment_baskets.user_id
			FROM jos_users 
		INNER
			JOIN jos_comprofiler
				ON jos_comprofiler.user_id = jos_users.id
		INNER
			JOIN jos_cbsubs_subscriptions
				ON jos_cbsubs_subscriptions.user_id = jos_users.id
					WHERE 
				jos_cbsubs_subscriptions.plan_id = 4 AND (jos_cbsubs_subscriptions.status = 'A' OR jos_cbsubs_subscriptions.status = 'C')	
		LEFT 
			JOIN jos_cbsubs_payment_baskets 
				ON jos_cbsubs_payment_baskets.user_id = jos_users.id 
			";