Warning (512): Cache not configured properly. Please check Cache::config(); in APP/config/core.php [CORE/cake/libs/configure.php, line 663]
Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE/cake/libs/configure.php, line 684]
Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE/cake/libs/configure.php, line 691]
Frequently Asked Questions - Great Trade Solutions, Inc. - A Charlotte Barter and Trade Exchange
Login

Frequently Asked Questions

1. Are there any tax advantages to bartering?
2. How will my business profit from barter?
3. How does Barter work with a trade exchange?
4. What companies are involved in barter?
5. What does it cost to get started?
6. What if everyone wants my products and services and I can't find enough to buy?
7. What if I need to make a purchase before I've earned trade dollars in the system?
8. How should I price my products and services?
9. How can I barter outside of my own city?


1. Are there any tax advantages to bartering?
Barter income is treated the same as cash income. There are no tax advantages or disadvantages to bartering. Great Trade Solutions, Inc. provides a 1099B at the end of the year for sales your business has consummated. Barter purchases for the business, like cash purchases, are tax deductible as business expenses.

2. How will my business profit from barter?
Barter produces new business generated by Great Trade Solutions, Inc. marketing efforts thus expanding your market and still maintain your cash-paying customers. Barter increases cash flow retention. For example, if you owned a magazine and needed a new copy machine priced at $1,000. Great Trade Solutions, Inc. would sell advertising of $1,000 in your magazine and you would purchase the needed copy machine.

3. How does Barter work with a trade exchange?
Great Trade Solutions, Inc. eliminates the problem of one-on-one trading where each business must want what the other has to offer. Great Trade Solutions, Inc. associated businesses have access to purchasing published items and services on the Great Trade Solutions, Inc. website or work with their assigned Trade Broker for additional options.

4. How many companies are involved in barter?
Globally, over 470,000 businesses are involved in Barter. It is estimated that 65% of Fortune 500 companies engage in barter to one degree or another.

5. What does it cost to get started?
Great Trade Solutions, Inc. does not charge a registration or yearly fee to establish your business account. Transaction and modest monthly fees cover accounting, marketing, promotions and member services.

6. What if everyone wants my products and services and I can't find enough to buy?
Your Great Trade Solutions, Inc. Trade Broker is trained to assist you in every aspect of account management. This means your company sales and purchases will stay within specific limits set by your business and Great Trade Solutions, Inc. Your Trade Broker will work closely with you to maximize your companies benefit from your barter participation.

7. What if I need to make a purchase before I've earned trade dollars in the system?
Great Trade Solutions, Inc. may extend a line of credit. Request a Line of Credit from your Trade Broker and he will process your request for approval.

8. How should I price my products and services?
Prices quoted are your normal retail or cash price.

9. How can I barter outside of my own city?
Great Trade Solutions, Inc. participates in worldwide reciprocal trade relationships with other exchanges offering a multitude of additional barter opportunities. We fulfill our members' barter and travel requests via our vast Global Network.

Unread Messages
[close]
(default) 51 queries took 524 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`19191
2DESCRIBE `permissions`551
3DESCRIBE `users_permissions`330
4DESCRIBE `businesses`92922
5DESCRIBE `exchanges`74742
6DESCRIBE `regions`35351
7DESCRIBE `currencies`441
8DESCRIBE `processors`551
9DESCRIBE `notes`8810
10DESCRIBE `categories`3310
11DESCRIBE `businesses_users`221
12DESCRIBE `businesses_categories`220
13DESCRIBE `banlist`226
14SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1002
15SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 11117
16SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC 1111
17SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 11124
18SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC 111
19SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC 11114
20SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC 2213
21SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1 54541
22 select concat(p.parent,'.',p.name) from users as u inner join roles_permissions as rp on u.role_id = rp.role_id inner join permissions as p on p.id = rp.permission_id where u.id = 1 000
23 select concat(parent,'.',name), value from users_permissions inner join permissions on permission_id = id where user_id = 1 004
24DESCRIBE `items`242449
25DESCRIBE `photos`774
26DESCRIBE `items_photos`332
27DESCRIBE `items_categories`221
28DESCRIBE `items_primary`661
29DESCRIBE `items_secondary`663
30DESCRIBE `items_leftrail`661
31SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.242' LIMIT 1000
32SELECT `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Owner`.`id`, `Owner`.`name`, `Owner`.`owner` FROM `exchanges` AS `Exchange` LEFT JOIN `businesses` AS `Owner` ON (`Exchange`.`owner` = `Owner`.`id`) WHERE `Exchange`.`shortname` = 'gts' LIMIT 111113
33SELECT `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy` FROM `regions` AS `Region` WHERE `Region`.`exchange_id` = (41) ORDER BY `name` ASC 111
34SELECT `Business`.`id`, `Business`.`display_id`, `Business`.`created`, `Business`.`modified`, `Business`.`active`, `Business`.`visible`, `Business`.`local_sell`, `Business`.`local_buy`, `Business`.`buy_hold`, `Business`.`sell_hold`, `Business`.`broker_managed`, `Business`.`reciprocal_account`, `Business`.`process_annual_fees`, `Business`.`spend_down`, `Business`.`name`, `Business`.`region_id`, `Business`.`photo_id`, `Business`.`exchange_id`, `Business`.`broker`, `Business`.`salesperson`, `Business`.`owner`, `Business`.`contact`, `Business`.`shortname`, `Business`.`description`, `Business`.`comment`, `Business`.`cash_credit`, `Business`.`credit`, `Business`.`credit_limit`, `Business`.`balance`, `Business`.`cash_due`, `Business`.`past_due`, `Business`.`monthly_cash`, `Business`.`monthly_barter`, `Business`.`annual_cash`, `Business`.`annual_barter`, `Business`.`ein`, `Business`.`ssn`, `Business`.`payment_method`, `Business`.`credit_card_type`, `Business`.`credit_card_number`, `Business`.`credit_card_expiration`, `Business`.`credit_card_security_code`, `Business`.`credit_card_security_code_backup`, `Business`.`echeck_checkname`, `Business`.`echeck_routing_number`, `Business`.`echeck_account_number`, `Business`.`echeck_account_class`, `Business`.`echeck_account_type`, `Business`.`echeck_bank_name`, `Business`.`billing_firstname`, `Business`.`billing_lastname`, `Business`.`billing_address1`, `Business`.`billing_city`, `Business`.`billing_state`, `Business`.`billing_zip`, `Business`.`billing_country`, `Business`.`billing_email`, `Business`.`barter_buyer_fee`, `Business`.`barter_seller_fee`, `Business`.`cash_buyer_fee`, `Business`.`cash_seller_fee`, `Business`.`email`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`zipcode`, `Business`.`country`, `Business`.`phone1`, `Business`.`phone2`, `Business`.`fax1`, `Business`.`fax2`, `Business`.`url`, `Business`.`referral`, `Business`.`w9_name`, `Business`.`w9_business_name`, `Business`.`w9_business_type`, `Business`.`w9_address1`, `Business`.`w9_address2`, `Business`.`w9_country`, `Business`.`w9_city`, `Business`.`w9_state`, `Business`.`w9_zipcode`, `Business`.`w9_id`, `Business`.`w9_remote_info`, `Business`.`mailing_address1`, `Business`.`mailing_address2`, `Business`.`mailing_country`, `Business`.`mailing_city`, `Business`.`mailing_state`, `Business`.`mailing_zipcode`, `Business`.`phone3`, `Exchange`.`id`, `Exchange`.`name`, `Exchange`.`shortname`, `Exchange`.`status`, `Exchange`.`httpd`, `Exchange`.`emails`, `Exchange`.`messenger`, `Exchange`.`daily_emails`, `Exchange`.`monthly_fees`, `Exchange`.`annual_fees`, `Exchange`.`monthly_statements`, `Exchange`.`monthly_backups`, `Exchange`.`past_due`, `Exchange`.`late_fees`, `Exchange`.`description`, `Exchange`.`created`, `Exchange`.`network`, `Exchange`.`domain`, `Exchange`.`domain_aliases`, `Exchange`.`messenger_reply`, `Exchange`.`page_title_suffix`, `Exchange`.`page_description`, `Exchange`.`credit`, `Exchange`.`credit_limit`, `Exchange`.`balance`, `Exchange`.`barter21_cash_fee`, `Exchange`.`barter21_barter_fee`, `Exchange`.`barter21_monthly_fee_max`, `Exchange`.`barter21_monthly_fee_min`, `Exchange`.`barter21_monthly_barter_fee_max`, `Exchange`.`barter21_monthly_barter_fee_min`, `Exchange`.`barter21_buyer_fee`, `Exchange`.`barter21_seller_fee`, `Exchange`.`default_currency`, `Exchange`.`default_business_seller_cash_fee`, `Exchange`.`default_business_seller_barter_fee`, `Exchange`.`default_business_buyer_cash_fee`, `Exchange`.`default_business_buyer_barter_fee`, `Exchange`.`default_business_credit_limit`, `Exchange`.`collections_minimum`, `Exchange`.`barter_fee_tax`, `Exchange`.`cash_fee_tax`, `Exchange`.`signup_cash_fee`, `Exchange`.`signup_barter_fee`, `Exchange`.`monthly_admin_cash_fee`, `Exchange`.`monthly_admin_barter_fee`, `Exchange`.`annual_renewal_cash_fee`, `Exchange`.`annual_renewal_barter_fee`, `Exchange`.`statement_grace_period`, `Exchange`.`late_fee`, `Exchange`.`late_fee_grace_period`, `Exchange`.`late_fee_minimum`, `Exchange`.`owner`, `Exchange`.`reconcile`, `Exchange`.`timezone`, `Exchange`.`language`, `Exchange`.`locale`, `Exchange`.`google_analytics_account`, `Exchange`.`skin`, `Exchange`.`theme`, `Exchange`.`theme_params`, `Exchange`.`tax_rate`, `Exchange`.`annual_fee_setting`, `Exchange`.`monlthy_fee_setting`, `Exchange`.`mailchimp_api_key`, `Exchange`.`mailchimp_list_id`, `Exchange`.`default_trading_floor_view`, `Exchange`.`default_daily_email_view`, `Exchange`.`default_role_id`, `Exchange`.`required_ein`, `Exchange`.`required_payment`, `Exchange`.`accepts_eft`, `Exchange`.`accepts_cc`, `Exchange`.`allowable_credit_card_types`, `Region`.`id`, `Region`.`name`, `Region`.`shortname`, `Region`.`description`, `Region`.`exchange_id`, `Region`.`timezone`, `Region`.`language`, `Region`.`locale`, `Region`.`currency_id`, `Region`.`processor_currency`, `Region`.`domain`, `Region`.`theme`, `Region`.`skin`, `Region`.`theme_params`, `Region`.`cash_fee_tax`, `Region`.`barter_fee_tax`, `Region`.`collections_minimum`, `Region`.`signup_cash_fee`, `Region`.`signup_barter_fee`, `Region`.`monthly_admin_cash_fee`, `Region`.`monthly_admin_barter_fee`, `Region`.`annual_renewal_cash_fee`, `Region`.`annual_renewal_barter_fee`, `Region`.`statement_grace_period`, `Region`.`late_fee`, `Region`.`late_fee_minimum`, `Region`.`late_fee_grace_period`, `Region`.`default_business_seller_cash_fee`, `Region`.`default_business_seller_barter_fee`, `Region`.`default_business_buyer_cash_fee`, `Region`.`default_business_buyer_barter_fee`, `Region`.`default_business_credit_limit`, `Region`.`operations_account`, `Region`.`store_approval`, `Region`.`store_autobuy`, `Owner`.`id`, `Owner`.`username`, `Owner`.`password`, `Owner`.`role_id`, `Owner`.`status`, `Owner`.`firstname`, `Owner`.`lastname`, `Owner`.`email`, `Owner`.`address1`, `Owner`.`address2`, `Owner`.`city`, `Owner`.`state`, `Owner`.`zipcode`, `Owner`.`phone1`, `Owner`.`phone2`, `Owner`.`fax1`, `Owner`.`fax2`, `Owner`.`lastlogin_remote_info`, `Owner`.`apikey`, `Contact`.`id`, `Contact`.`username`, `Contact`.`password`, `Contact`.`role_id`, `Contact`.`status`, `Contact`.`firstname`, `Contact`.`lastname`, `Contact`.`email`, `Contact`.`address1`, `Contact`.`address2`, `Contact`.`city`, `Contact`.`state`, `Contact`.`zipcode`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`fax1`, `Contact`.`fax2`, `Contact`.`lastlogin_remote_info`, `Contact`.`apikey`, `Salesperson`.`id`, `Salesperson`.`username`, `Salesperson`.`password`, `Salesperson`.`role_id`, `Salesperson`.`status`, `Salesperson`.`firstname`, `Salesperson`.`lastname`, `Salesperson`.`email`, `Salesperson`.`address1`, `Salesperson`.`address2`, `Salesperson`.`city`, `Salesperson`.`state`, `Salesperson`.`zipcode`, `Salesperson`.`phone1`, `Salesperson`.`phone2`, `Salesperson`.`fax1`, `Salesperson`.`fax2`, `Salesperson`.`lastlogin_remote_info`, `Salesperson`.`apikey`, `Broker`.`id`, `Broker`.`username`, `Broker`.`password`, `Broker`.`role_id`, `Broker`.`status`, `Broker`.`firstname`, `Broker`.`lastname`, `Broker`.`email`, `Broker`.`address1`, `Broker`.`address2`, `Broker`.`city`, `Broker`.`state`, `Broker`.`zipcode`, `Broker`.`phone1`, `Broker`.`phone2`, `Broker`.`fax1`, `Broker`.`fax2`, `Broker`.`lastlogin_remote_info`, `Broker`.`apikey` FROM `businesses` AS `Business` LEFT JOIN `exchanges` AS `Exchange` ON (`Business`.`exchange_id` = `Exchange`.`id`) LEFT JOIN `regions` AS `Region` ON (`Business`.`region_id` = `Region`.`id`) LEFT JOIN `users` AS `Owner` ON (`Business`.`owner` = `Owner`.`id`) LEFT JOIN `users` AS `Contact` ON (`Business`.`contact` = `Contact`.`id`) LEFT JOIN `users` AS `Salesperson` ON (`Business`.`salesperson` = `Salesperson`.`id`) LEFT JOIN `users` AS `Broker` ON (`Business`.`broker` = `Broker`.`id`) WHERE `Business`.`id` = 3251 LIMIT 11158
35SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`business_id`, `Note`.`update_id`, `Note`.`created`, `Note`.`modified`, `Note`.`body`, `Note`.`status` FROM `notes` AS `Note` WHERE `Note`.`business_id` = (3251) ORDER BY created DESC 111
36SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey`, `BusinessesUser`.`business_id`, `BusinessesUser`.`user_id` FROM `users` AS `User` JOIN `businesses_users` AS `BusinessesUser` ON (`BusinessesUser`.`business_id` = 3251 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC 115
37SELECT `Category`.`id`, `Category`.`name`, `Category`.`parent`, `BusinessesCategory`.`business_id`, `BusinessesCategory`.`category_id` FROM `categories` AS `Category` JOIN `businesses_categories` AS `BusinessesCategory` ON (`BusinessesCategory`.`business_id` = 3251 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC 221
38SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1 54540
39SELECT `ItemLeftrail`.`item_id`, `ItemLeftrail`.`exchange_id`, `ItemLeftrail`.`created`, `ItemLeftrail`.`lastupdated`, `ItemLeftrail`.`position`, `ItemLeftrail`.`live`, `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items_leftrail` AS `ItemLeftrail` LEFT JOIN `items` AS `Item` ON (`ItemLeftrail`.`item_id` = `Item`.`id`) WHERE `ItemLeftrail`.`exchange_id` = 41 ORDER BY rand() ASC LIMIT 54430
40SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 9687 110
41SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 2777 1129
42SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 9687 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC 220
43SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 4303 110
44SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 3843 110
45SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4303 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC 220
46SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 4281 111
47SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 3820 110
48SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 4281 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC 330
49SELECT `Item`.`id`, `Item`.`approval`, `Item`.`exchange_id`, `Item`.`currency_id`, `Item`.`stop`, `Item`.`created`, `Item`.`lastmodified`, `Item`.`emailed`, `Item`.`sorted`, `Item`.`name`, `Item`.`shortname`, `Item`.`description`, `Item`.`location`, `Item`.`zip`, `Item`.`barter`, `Item`.`inventory`, `Item`.`business_id`, `Item`.`original_business_id`, `Item`.`user_id`, `Item`.`shippable`, `Item`.`shipping_cost`, `Item`.`shipping_description`, `Item`.`condition`, `Item`.`contact` FROM `items` AS `Item` WHERE `Item`.`id` = 2331 111
50SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role_id`, `User`.`status`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zipcode`, `User`.`phone1`, `User`.`phone2`, `User`.`fax1`, `User`.`fax2`, `User`.`lastlogin_remote_info`, `User`.`apikey` FROM `users` AS `User` WHERE `User`.`id` = 2777 110
51SELECT `Photo`.`id`, `Photo`.`created`, `Photo`.`lastmodified`, `Photo`.`filename`, `Photo`.`protected`, `Photo`.`type`, `Photo`.`mongoid`, `ItemsPhoto`.`item_id`, `ItemsPhoto`.`photo_id`, `ItemsPhoto`.`position` FROM `photos` AS `Photo` JOIN `items_photos` AS `ItemsPhoto` ON (`ItemsPhoto`.`item_id` = 2331 AND `ItemsPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY position ASC 330