Runtime: 0.01849
0.015288exception127/home/imeda/public_html_files/imeda/libraries/services/base/db.phpDB query error: 42S22, 1054, Unknown column 'dvd_eshop_item__i_eshop_items.value' in 'field list' - query: SELECT (SELECT cm.text FROM content_multilang cm WHERE cm.table = 'i_seminars' AND cm.col_name = 'event_name' AND cm.table_id = i_seminars.id AND cm.id_langs = 3) AS event_name, i_seminars.event_date AS event_date, i_seminars.event_id AS event_id, venue_name__i_venues.id AS `venue_name__id`,venue_name__i_venues.venue_id AS venue_name__venue_id,venue_name__i_venues.venue_name AS venue_name__venue_name,venue_name__i_venues.venue_room_name AS venue_name__venue_room_name,venue_name__i_venues.venue_street AS venue_name__venue_street,venue_name__i_venues.venue_province AS venue_name__venue_province,venue_name__i_venues.venue_city AS venue_name__venue_city,(SELECT i_taxes_venue_tax_region.region_name FROM i_taxes i_taxes_venue_tax_region WHERE i_taxes_venue_tax_region.id = venue_name__i_venues.id_i_taxes) AS `venue_name__venue_tax_region`,venue_name__i_venues.venue_zip AS venue_name__venue_zip,venue_name__i_venues.venue_gmap_link AS venue_name__venue_gmap_link,venue_name__i_venues.venue_capacity AS venue_name__venue_capacity,venue_name__i_venues.venue_contact_firstname AS venue_name__venue_contact_firstname,venue_name__i_venues.venue_contact_lastname AS venue_name__venue_contact_lastname,venue_name__i_venues.venue_contact_phone AS venue_name__venue_contact_phone,venue_name__i_venues.venue_contact_cell AS venue_name__venue_contact_cell,venue_name__i_venues.venue_contact_fax AS venue_name__venue_contact_fax,venue_name__i_venues.venue_contact_email AS venue_name__venue_contact_email,(SELECT COUNT(i_venue_room_costs.id) FROM i_venue_room_costs WHERE i_venue_room_costs.id_i_venues = venue_name__i_venues.id) AS venue_name__venue_room_cost,venue_name__i_venues.venue_catering AS venue_name__venue_catering,venue_name__i_venues.venue_catering_cost_pp AS venue_name__venue_catering_cost_pp,venue_name__i_venues.venue_av AS venue_name__venue_av,venue_name__i_venues.venue_av_cost AS venue_name__venue_av_cost,venue_name__i_venues.venue_webcast AS venue_name__venue_webcast,venue_name__i_venues.venue_webcast_cost AS venue_name__venue_webcast_cost,venue_name__i_venues.venue_webcast_capacity AS venue_name__venue_webcast_capacity,(SELECT cm.text FROM content_multilang cm WHERE cm.table = 'i_venues' AND cm.col_name = 'venue_notes' AND cm.table_id = venue_name__i_venues.id AND cm.id_langs = 3) AS venue_name__venue_notes, (SELECT GROUP_CONCAT(i_seminars_i_speakers.id_i_speakers SEPARATOR ', ') FROM i_seminars_i_speakers WHERE i_seminars_i_speakers.id_i_seminars = i_seminars.id) AS speaker_name, (SELECT CONCAT(staff_firstname, " ", staff_lastname) FROM i_staff WHERE i_staff.id = i_seminars.id_i_staff) AS `staff_name`, (SELECT cmb.text FROM content_multilang_big cmb WHERE cmb.table = 'i_seminars' AND cmb.col_name = 'event_description' AND cmb.table_id = i_seminars.id AND cmb.id_langs = 3) AS event_description, i_seminars.cost_nonmembers AS cost_nonmembers, (SELECT GROUP_CONCAT(i_seminars_i_attendance_types.id_i_attendance_types SEPARATOR '##$$##') FROM i_seminars_i_attendance_types WHERE i_seminars_i_attendance_types.id_i_seminars = i_seminars.id) AS attendance, (SELECT i_timezones_event_date_timezone_shortcut.shortcut FROM i_timezones i_timezones_event_date_timezone_shortcut WHERE i_timezones_event_date_timezone_shortcut.id = i_seminars.id_i_timezones) AS `event_date_timezone_shortcut`, i_seminars.active AS active, i_seminars.duration AS duration, i_seminars.seo_url_en AS seo_url_en, i_seminars.seo_url_fr AS seo_url_fr, i_seminars.video_html AS video_html, i_seminars.video_pass AS video_pass, venue_name__i_venues.id AS `venue_name__id`,venue_name__i_venues.venue_id AS venue_name__venue_id,venue_name__i_venues.venue_name AS venue_name__venue_name,venue_name__i_venues.venue_room_name AS venue_name__venue_room_name,venue_name__i_venues.venue_street AS venue_name__venue_street,venue_name__i_venues.venue_province AS venue_name__venue_province,venue_name__i_venues.venue_city AS venue_name__venue_city,(SELECT i_taxes_venue_tax_region.region_name FROM i_taxes i_taxes_venue_tax_region WHERE i_taxes_venue_tax_region.id = venue_name__i_venues.id_i_taxes) AS `venue_name__venue_tax_region`,venue_name__i_venues.venue_zip AS venue_name__venue_zip,venue_name__i_venues.venue_gmap_link AS venue_name__venue_gmap_link,venue_name__i_venues.venue_capacity AS venue_name__venue_capacity,venue_name__i_venues.venue_contact_firstname AS venue_name__venue_contact_firstname,venue_name__i_venues.venue_contact_lastname AS venue_name__venue_contact_lastname,venue_name__i_venues.venue_contact_phone AS venue_name__venue_contact_phone,venue_name__i_venues.venue_contact_cell AS venue_name__venue_contact_cell,venue_name__i_venues.venue_contact_fax AS venue_name__venue_contact_fax,venue_name__i_venues.venue_contact_email AS venue_name__venue_contact_email,(SELECT COUNT(i_venue_room_costs.id) FROM i_venue_room_costs WHERE i_venue_room_costs.id_i_venues = venue_name__i_venues.id) AS venue_name__venue_room_cost,venue_name__i_venues.venue_catering AS venue_name__venue_catering,venue_name__i_venues.venue_catering_cost_pp AS venue_name__venue_catering_cost_pp,venue_name__i_venues.venue_av AS venue_name__venue_av,venue_name__i_venues.venue_av_cost AS venue_name__venue_av_cost,venue_name__i_venues.venue_webcast AS venue_name__venue_webcast,venue_name__i_venues.venue_webcast_cost AS venue_name__venue_webcast_cost,venue_name__i_venues.venue_webcast_capacity AS venue_name__venue_webcast_capacity,(SELECT cm.text FROM content_multilang cm WHERE cm.table = 'i_venues' AND cm.col_name = 'venue_notes' AND cm.table_id = venue_name__i_venues.id AND cm.id_langs = 3) AS venue_name__venue_notes,dvd_eshop_item__i_eshop_items.id AS `dvd_eshop_item__id`,(SELECT cm.text FROM content_multilang cm WHERE cm.table = 'i_eshop_items' AND cm.col_name = 'name' AND cm.table_id = dvd_eshop_item__i_eshop_items.id AND cm.id_langs = 3) AS dvd_eshop_item__name,dvd_eshop_item__i_eshop_items.price AS dvd_eshop_item__price,dvd_eshop_item__i_eshop_items.value AS dvd_eshop_item__value,dvd_eshop_item__i_eshop_items.type AS dvd_eshop_item__type,(SELECT (SELECT cm.text FROM content_multilang cm WHERE cm.table = 'i_seminars' AND cm.col_name = 'event_name' AND cm.table_id = i_seminars.id AND cm.id_langs = 3) FROM i_seminars WHERE i_seminars.id = dvd_eshop_item__i_eshop_items.id_i_seminars) AS dvd_eshop_item__id_i_seminars,dvd_eshop_item__i_eshop_items.id_images AS dvd_eshop_item__id_images,dvd_eshop_item__i_eshop_items.id_images_fr AS dvd_eshop_item__id_images_fr,dvd_eshop_item__i_eshop_items.show_description AS dvd_eshop_item__show_description,dvd_eshop_item__i_eshop_items.featured AS dvd_eshop_item__featured,dvd_eshop_item__i_eshop_items.hidden AS dvd_eshop_item__hidden,dvd_eshop_item__i_eshop_items.is_show AS dvd_eshop_item__is_show,(SELECT cmb.text FROM content_multilang_big cmb WHERE cmb.table = 'dvd_eshop_item__i_eshop_items' AND cmb.col_name = 'description' AND cmb.table_id = dvd_eshop_item__i_eshop_items.id AND cmb.id_langs = 3) AS dvd_eshop_item__description,(SELECT COUNT(i_orders_eshop_items.id) FROM i_orders_eshop_items WHERE i_orders_eshop_items.id_i_eshop_items = dvd_eshop_item__i_eshop_items.id) AS dvd_eshop_item__ordered_items, (SELECT i_venues_venue_province.id_i_taxes FROM i_venues i_venues_venue_province WHERE i_venues_venue_province.id = i_seminars.id_i_venues) AS `venue_province`, i_seminars.free AS free, i_seminars.lang AS lang, i_seminars.id FROM i_seminars LEFT JOIN i_venues venue_name__i_venues ON i_seminars.id_i_venues = venue_name__i_venues.id LEFT JOIN i_eshop_items dvd_eshop_item__i_eshop_items ON i_seminars.id_i_eshop_items = dvd_eshop_item__i_eshop_items.id WHERE (i_seminars.seo_url_en = 'how-not-to-lose-permanent-residence') ORDER BY i_seminars.id DESC