Products

WordPress database error: [Undeclared variable: 40pages]
SELECT p.product_name, ab.guide_book_id, ab.customers_id, ab.entry_zone_id, ab.entry_city, ab.entry_state, ab.entry_country_id, c.customers_default_address_id, ab.entry_company, ab.entry_firstname, ab.entry_lastname, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, gb.company_url, gb.web_logo_location, gb.published_email_address, gb.published_contact_telephone, gb.company_bio, p.product_model, p.product_manufacturer, p.product_description, p.product_url, p.room_id,pgc.category_name as product_category,pgsc.name as product_subcategory FROM product_search p left join guide_book gb on p.customer_id = gb.customers_id left join address_book ab on ab.customers_id=gb.customers_id left join customers c on c.customers_default_address_id=ab.address_book_id left join product_guide_cat pgc on p.product_guide_cat=pgc.guide_id left join product_guide_subcat pgsc on p.product_subcat=pgsc.subcat_id WHERE p.product_name LIKE 'S%' AND 1=1 and ab.guide_book_id > 0 GROUP BY p.product_name ORDER BY p.product_name ASC LIMIT 40pages=0, 20

Products Search

An Excel Spreadsheet is available for attendees that would like to download a list of all exhibitors, room locations as well as any products the exhibitors have added to our database.