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]
AllCity Barter Privacy Policy - AllCity Barter - A Las Vegas Barter and Trade Exchange
Login

Privacy Policy

What information do we collect? 

We collect information from you when you register on our site.

When ordering or registering on our site, as appropriate, you may be asked to enter your: name, e-mail address, mailing address, phone number, credit card information or social security number. You may, however, visit our site anonymously.

Like most websites, we use cookies and/or web beacons to enhance your experience, gather general visitor information, and track visits to our website. Please refer to the 'do we use cookies?' section below for information about cookies and how we use them.

What do we use your information for?

Any of the information we collect from you may be used in one of the following ways:

  • To personalize your experience. (your information helps us to better respond to your individual needs)
  • To improve our website. (we continually strive to improve our website offerings based on the information and feedback we receive from you)
  • To improve customer service. (your information helps us to more effectively respond to your customer service requests and support needs)
  • To process transactions.
    Your information, whether public or private, will not be sold, exchanged, transferred, or given to any other company for any reason whatsoever, without your consent, other than for the express purpose of delivering the purchased product or service requested.
  • To send periodic emails
    The email address you provide for order processing, may be used to send you information and updates pertaining to your order, in addition to receiving occasional company news, updates, related product or service information, etc.

    Note: If at any time you would like to unsubscribe from receiving future emails, we include detailed unsubscribe instructions at the bottom of each email.

How do we protect your information?

We implement a variety of security measures to maintain the safety of your personal information when you place an order or access your personal information.

We offer the use of a secure server. All supplied sensitive/credit information is transmitted via Secure Socket Layer (SSL) technology and then encrypted into our Database to be only accessed by those authorized with special access rights to our systems, and are required to�keep the information confidential.

After a transaction, your private information (credit cards, social security numbers, financials, etc.) will be kept on file for more than 60 days in order to automatically process your fees.

Do we use cookies?

Yes (Cookies are small files that a site or its service provider transfers to your computers hard drive through your Web browser (if you allow) that enables the sites or service providers systems to recognize your browser and capture and remember certain information.

We use cookies to help us remember and process the items in your shopping cart, understand and save your preferences for future visits and compile aggregate data about site traffic and site interaction so that we can offer better site experiences and tools in the future. We may contract with third-party service providers to assist us in better understanding our site visitors. These service providers are not permitted to use the information collected on our behalf except to help us conduct and improve our business.

Do we disclose any information to outside parties?

We do not sell, trade, or otherwise transfer to outside parties your personally identifiable information. This does not include trusted third parties who assist us in operating our website, conducting our business, or servicing you, so long as those parties agree to keep this information confidential. We may also release your information when we believe release is appropriate to comply with the law, enforce our site policies, or protect ours or others rights, property, or safety. However, non-personally identifiable visitor information may be provided to other parties for marketing, advertising, or other uses.

Third party links

Occasionally, at our discretion, we may include or offer third party products or services on our website. These third party sites have separate and independent privacy policies. We therefore have no responsibility or liability for the content and activities of these linked sites. Nonetheless, we seek to protect the integrity of our site and welcome any feedback about these sites.

ALL MERCHANT'S PERSONAL INFORMATION, SOCIAL SECURITY NUMBER, TAX ID NUMBERS AND  CREDIT CARD INFORMATION WILL NOT BE SHARED AND ARE DEEMED CONFIDENTIAL.

Your Consent

By using our site, you consent to our privacy policy.

Changes to our Privacy Policy

If we decide to change our privacy policy, we will post those changes on this page, and/or update the Privacy Policy modification date below.

This policy was last modified on April 10, 2009

Contacting Us

If there are any questions regarding this privacy policy you may contact us using the information below:

AllCity Barter
Steven Lebow
4660 South Eastern Ave., Suite #206
Las Vegas, NV 89119
702-259-0955

Unread Messages
[close]
(default) 43 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `businesses`92922
2DESCRIBE `exchanges`74742
3DESCRIBE `regions`35351
4DESCRIBE `currencies`440
5DESCRIBE `processors`550
6DESCRIBE `users`19191
7DESCRIBE `permissions`551
8DESCRIBE `users_permissions`330
9DESCRIBE `notes`881
10DESCRIBE `categories`330
11DESCRIBE `businesses_users`220
12DESCRIBE `businesses_categories`220
13DESCRIBE `banlist`220
14SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.241' LIMIT 1000
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` = 'allcity' LIMIT 1110
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` = (71) ORDER BY `name` ASC 220
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` = 5871 LIMIT 1111
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` = (5871) ORDER BY created DESC 000
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` = 5871 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC 110
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` = 5871 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC 220
21SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1 54540
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 000
24SELECT `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` = 5871 LIMIT 1111
25SELECT `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` = (5871) ORDER BY created DESC 000
26SELECT `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` = 5871 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC 110
27SELECT `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` = 5871 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC 220
28DESCRIBE `items`24241
29DESCRIBE `photos`771
30DESCRIBE `items_photos`330
31DESCRIBE `items_categories`220
32DESCRIBE `items_primary`661
33DESCRIBE `items_secondary`661
34DESCRIBE `items_leftrail`661
35SELECT `Banlist`.`id`, `Banlist`.`created` FROM `banlist` AS `Banlist` WHERE `Banlist`.`id` = '38.107.179.241' LIMIT 1000
36SELECT `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` = 'allcity' LIMIT 1110
37SELECT `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` = (71) ORDER BY `name` ASC 220
38SELECT `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` = 5871 LIMIT 1111
39SELECT `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` = (5871) ORDER BY created DESC 000
40SELECT `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` = 5871 AND `BusinessesUser`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY username ASC 110
41SELECT `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` = 5871 AND `BusinessesCategory`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY name ASC 220
42SELECT CONCAT(parent,'.',name) FROM `permissions` AS `Permission` WHERE 1 = 1 54540
43SELECT `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` = 71 ORDER BY rand() ASC LIMIT 5001