# # #Date: 2023-03-24 11:53:42 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2023-03-24 11:53:42 0 [DEBUG] Clean up old logs. Found 13 logs and threshold is 25 logs 2023-03-24 11:53:42 0 [DEBUG] Clean up old logs. Found 13 logs and threshold is 25 logs 2023-03-24 11:53:42 0 [DEBUG] RO CSVI Version: 8.7.0 2023-03-24 11:53:42 0 [DEBUG] Joomla! version: 3.10.11 2023-03-24 11:53:42 0 [DEBUG] PHP version: 7.4.33 2023-03-24 11:53:42 0 [DEBUG] ========================= 2023-03-24 11:53:42 0 [DEBUG] action: export 2023-03-24 11:53:42 0 [DEBUG] component: com_virtuemart 2023-03-24 11:53:42 0 [DEBUG] operation: product 2023-03-24 11:53:42 0 [DEBUG] override: 2023-03-24 11:53:42 0 [DEBUG] 0: todownload 2023-03-24 11:53:42 0 [DEBUG] output_empty_file: Nein 2023-03-24 11:53:42 0 [DEBUG] localpath: /var/www/virtual/bollig-wein.de/htdocs 2023-03-24 11:53:42 0 [DEBUG] ftphost: 2023-03-24 11:53:42 0 [DEBUG] ftpport: 2023-03-24 11:53:42 0 [DEBUG] sftp: Nein 2023-03-24 11:53:42 0 [DEBUG] ftproot: 2023-03-24 11:53:42 0 [DEBUG] ftpfile: 2023-03-24 11:53:42 0 [DEBUG] export_email_subject: 2023-03-24 11:53:42 0 [DEBUG] export_email_body: 2023-03-24 11:53:42 0 [DEBUG] database_username: 2023-03-24 11:53:42 0 [DEBUG] database_host: 2023-03-24 11:53:42 0 [DEBUG] database_portno: 2023-03-24 11:53:42 0 [DEBUG] database_name: 2023-03-24 11:53:42 0 [DEBUG] database_table: 2023-03-24 11:53:42 0 [DEBUG] primary_key_source: NAME 2023-03-24 11:53:42 0 [DEBUG] primary_key_target: id 2023-03-24 11:53:42 0 [DEBUG] create_new_columns: Ja 2023-03-24 11:53:42 0 [DEBUG] empty_table: Nein 2023-03-24 11:53:42 0 [DEBUG] clientid: 2023-03-24 11:53:42 0 [DEBUG] clientsecret: 2023-03-24 11:53:42 0 [DEBUG] spreadsheetid: 2023-03-24 11:53:42 0 [DEBUG] sheetname: 2023-03-24 11:53:42 0 [DEBUG] range_from: 2023-03-24 11:53:42 0 [DEBUG] range_to: 2023-03-24 11:53:42 0 [DEBUG] valueInputOption: RAW 2023-03-24 11:53:42 0 [DEBUG] export_filename: bollig_produktfeed.xml 2023-03-24 11:53:42 0 [DEBUG] export_file: xml 2023-03-24 11:53:42 0 [DEBUG] sheet_name: Sheet 1 2023-03-24 11:53:42 0 [DEBUG] export_site: custom 2023-03-24 11:53:42 0 [DEBUG] field_delimiter: , 2023-03-24 11:53:42 0 [DEBUG] text_enclosure: 2023-03-24 11:53:42 0 [DEBUG] include_column_headers: Ja 2023-03-24 11:53:42 0 [DEBUG] include_empty_nodes: Ja 2023-03-24 11:53:42 0 [DEBUG] signature: Nein 2023-03-24 11:53:42 0 [DEBUG] use_excel_date: Nein 2023-03-24 11:53:42 0 [DEBUG] publish_state: Ja 2023-03-24 11:53:42 0 [DEBUG] recordstart: 2023-03-24 11:53:42 0 [DEBUG] recordend: 2023-03-24 11:53:42 0 [DEBUG] export_date_format: d/m/Y H:i:s 2023-03-24 11:53:42 0 [DEBUG] export_price_format_decimal: 2 2023-03-24 11:53:42 0 [DEBUG] export_price_format_decsep: , 2023-03-24 11:53:42 0 [DEBUG] export_price_format_thousep: . 2023-03-24 11:53:42 0 [DEBUG] header: 2023-03-24 11:53:42 0 [DEBUG] body: 2023-03-24 11:53:42 0 [DEBUG] footer: 2023-03-24 11:53:42 0 [DEBUG] language: de-DE 2023-03-24 11:53:42 0 [DEBUG] use_parent_values: Nein 2023-03-24 11:53:42 0 [DEBUG] exportsef: Ja 2023-03-24 11:53:42 0 [DEBUG] cachesefurls: Ja 2023-03-24 11:53:42 0 [DEBUG] emptysefcache: Nein 2023-03-24 11:53:42 0 [DEBUG] producturl_suffix: 2023-03-24 11:53:42 0 [DEBUG] use_canonical: Nein 2023-03-24 11:53:42 0 [DEBUG] vm_itemid: 2023-03-24 11:53:42 0 [DEBUG] picture_limit: Ja 2023-03-24 11:53:42 0 [DEBUG] featured: Nein 2023-03-24 11:53:42 0 [DEBUG] category_separator: / 2023-03-24 11:53:42 0 [DEBUG] incl_productcategories: Ja 2023-03-24 11:53:42 0 [DEBUG] 0: Ja 2023-03-24 11:53:42 0 [DEBUG] publish_state_categories: -1 2023-03-24 11:53:42 0 [DEBUG] incl_subcategory: Nein 2023-03-24 11:53:42 0 [DEBUG] parent_only: Nein 2023-03-24 11:53:42 0 [DEBUG] child_only: Nein 2023-03-24 11:53:42 0 [DEBUG] 0: 2023-03-24 11:53:42 0 [DEBUG] incl_productskufilter: Nein 2023-03-24 11:53:42 0 [DEBUG] productskufilter: G1 2023-03-24 11:53:42 0 [DEBUG] stocklevelstart: Ja 2023-03-24 11:53:42 0 [DEBUG] stocklevelend: 2023-03-24 11:53:42 0 [DEBUG] 0: none 2023-03-24 11:53:42 0 [DEBUG] 0: none 2023-03-24 11:53:42 0 [DEBUG] shopper_group_price: none 2023-03-24 11:53:42 0 [DEBUG] priceoperator: gt 2023-03-24 11:53:42 0 [DEBUG] pricefrom: 2023-03-24 11:53:42 0 [DEBUG] priceto: 2023-03-24 11:53:42 0 [DEBUG] price_quantity_start: 2023-03-24 11:53:42 0 [DEBUG] price_quantity_end: 2023-03-24 11:53:42 0 [DEBUG] targetcurrency: 2023-03-24 11:53:42 0 [DEBUG] force_shopper_group_price: none 2023-03-24 11:53:42 0 [DEBUG] globalrules: 2023-03-24 11:53:42 0 [DEBUG] groupbyfields: 2023-03-24 11:53:42 0 [DEBUG] sortfields: 2023-03-24 11:53:42 0 [DEBUG] use_system_limits: Nein 2023-03-24 11:53:42 0 [DEBUG] max_execution_time: 2023-03-24 11:53:42 0 [DEBUG] memory_limit: 2023-03-24 11:53:42 0 [DEBUG] ========================= 2023-03-24 11:53:42 0 [DEBUG] Export field: NAME 2023-03-24 11:53:42 0 [DEBUG] Export field: BESCHREIBUNG 2023-03-24 11:53:42 0 [DEBUG] Export field: PREIS 2023-03-24 11:53:42 0 [DEBUG] Export field: FLASCHENGROESSE 2023-03-24 11:53:42 0 [DEBUG] Export field: JAHRGANG 2023-03-24 11:53:42 0 [DEBUG] Export field: URL 2023-03-24 11:53:42 0 [DEBUG] Export field: ALKOHOL 2023-03-24 11:53:42 0 [DEBUG] Export field: PRODUKT-ID 2023-03-24 11:53:42 0 [DEBUG] Export field: BILD 2023-03-24 11:53:42 0 [DEBUG] Export field: HERSTELLER 2023-03-24 11:53:42 0 [DEBUG] Export field: HERSTELLUNGSLAND 2023-03-24 11:53:42 0 [DEBUG] Export field: HERSTELLUNGSREGION 2023-03-24 11:53:42 0 [DEBUG] Export query 2023-03-24 11:53:42 0 [QUERY] SELECT `p`.`virtuemart_product_id` FROM `wman_virtuemart_products` AS `p` LEFT JOIN `wman_virtuemart_product_categories` AS `pc` ON `pc`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `pc`.`virtuemart_category_id` IN ('1') 2023-03-24 11:53:42 0 [DEBUG] Export query 2023-03-24 11:53:42 0 [QUERY] SELECT `p`.`virtuemart_product_id` FROM `wman_virtuemart_products` AS `p` WHERE `p`.`product_parent_id` IN ('10','11','12','13','14','15','22','23','24','25','26','27','28','29','31','33','35','37','38','40','41','42','44','45','47','48','49','50','51','52','53') 2023-03-24 11:53:42 0 [DEBUG] Export querySELECT `wman_virtuemart_products`.`virtuemart_product_id`, `wman_virtuemart_products`.`product_parent_id`, `wman_virtuemart_currencies`.`currency_code_3`, `wman_virtuemart_product_prices`.`virtuemart_shoppergroup_id`, `wman_virtuemart_product_prices`.`price_quantity_start`, `product_packaging`, `wman_virtuemart_products`.`product_url`, `wman_virtuemart_products`.`product_sku` FROM `wman_virtuemart_products` LEFT JOIN `wman_virtuemart_product_prices` ON `wman_virtuemart_products`.`virtuemart_product_id` = `wman_virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `wman_virtuemart_product_manufacturers` ON `wman_virtuemart_products`.`virtuemart_product_id` = `wman_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `wman_virtuemart_manufacturers` ON `wman_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `wman_virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `wman_virtuemart_manufacturers_de_de` ON `wman_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `wman_virtuemart_manufacturers_de_de`.`virtuemart_manufacturer_id` LEFT JOIN `wman_virtuemart_product_categories` ON `wman_virtuemart_products`.`virtuemart_product_id` = `wman_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `wman_virtuemart_currencies` ON `wman_virtuemart_currencies`.`virtuemart_currency_id` = `wman_virtuemart_product_prices`.`product_currency` LEFT JOIN `wman_virtuemart_product_shoppergroups` ON `wman_virtuemart_product_shoppergroups`.`virtuemart_product_id` = `wman_virtuemart_products`.`virtuemart_product_id` WHERE wman_virtuemart_products.virtuemart_product_id IN (10,11,12,13,14,15,22,23,24,25,26,27,28,29,31,33,35,37,38,40,41,42,44,45,47,48,49,50,51,52,53,17,43,32,34,36,39) AND wman_virtuemart_products.published = 1 AND (`wman_virtuemart_products`.`product_sku` NOT IN ('G1')) AND wman_virtuemart_products.product_in_stock >= 1 GROUP BY wman_virtuemart_products.virtuemart_product_id 2023-03-24 11:53:42 1 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 1 [QUERY] SELECT c.* FROM wman_virtuemart_calcs as c LEFT JOIN wman_virtuemart_calc_shoppergroups as cs ON cs.virtuemart_calc_id=c.virtuemart_calc_id LEFT JOIN wman_virtuemart_calc_countries as cc ON cc.virtuemart_calc_id=c.virtuemart_calc_id WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' ) AND `published`="1" AND (`virtuemart_vendor_id`="1" OR `shared`="1" ) AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-03-24 11:53:42" ) AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-24 11:53:42" ) AND ( virtuemart_shoppergroup_id = 2 OR (virtuemart_shoppergroup_id) IS NULL) AND ( virtuemart_country_id = "81" OR (virtuemart_country_id) IS NULL) 2023-03-24 11:53:42 1 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=11&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 1 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 11 LIMIT 1 2023-03-24 11:53:42 1 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/riesling-alte-reben 2023-03-24 11:53:42 1 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=11&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 1 [DEBUG] Custom field query 2023-03-24 11:53:42 1 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 11 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 2 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 2 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 12 2023-03-24 11:53:42 2 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=12&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 2 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 12 LIMIT 1 2023-03-24 11:53:42 2 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-riesling-trocken 2023-03-24 11:53:42 2 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=12&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 2 [DEBUG] Custom field query 2023-03-24 11:53:42 2 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 12 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 3 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 3 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 13 2023-03-24 11:53:42 3 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=13&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 3 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13 LIMIT 1 2023-03-24 11:53:42 3 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-apotheke-gg-riesling 2023-03-24 11:53:42 3 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=13&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 3 [DEBUG] Custom field query 2023-03-24 11:53:42 3 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 13 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 4 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 4 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 14 2023-03-24 11:53:42 4 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 4 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 14 LIMIT 1 2023-03-24 11:53:42 4 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/weissburgunder-reserve 2023-03-24 11:53:42 4 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 4 [DEBUG] Custom field query 2023-03-24 11:53:42 4 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 14 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 5 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 5 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 15 2023-03-24 11:53:42 5 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=15&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 5 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 15 LIMIT 1 2023-03-24 11:53:42 5 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/pinot-brut 2023-03-24 11:53:42 5 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=15&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 5 [DEBUG] Custom field query 2023-03-24 11:53:42 5 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 15 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 6 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 6 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 17 OR `virtuemart_product_id` = 13 2023-03-24 11:53:42 6 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=17&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 6 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13 LIMIT 1 2023-03-24 11:53:42 6 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-apotheke-gg-riesling-1 2023-03-24 11:53:42 6 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=17&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 6 [DEBUG] Custom field query 2023-03-24 11:53:42 6 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 17 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 7 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 7 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 22 2023-03-24 11:53:42 7 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=22&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 7 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 22 LIMIT 1 2023-03-24 11:53:42 7 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/buntes-b-cuvee-weiss 2023-03-24 11:53:42 7 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=22&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 7 [DEBUG] Custom field query 2023-03-24 11:53:42 7 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 22 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 8 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 8 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 23 2023-03-24 11:53:42 8 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=23&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 8 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 23 LIMIT 1 2023-03-24 11:53:42 8 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/weissburgunder 2023-03-24 11:53:42 8 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=23&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 8 [DEBUG] Custom field query 2023-03-24 11:53:42 8 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 23 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 9 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 9 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 24 2023-03-24 11:53:42 9 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=24&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 9 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 24 LIMIT 1 2023-03-24 11:53:42 9 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/blanc-de-noir 2023-03-24 11:53:42 9 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=24&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 9 [DEBUG] Custom field query 2023-03-24 11:53:42 9 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 24 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 10 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 10 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 25 2023-03-24 11:53:42 10 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=25&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 10 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 25 LIMIT 1 2023-03-24 11:53:42 10 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/rose 2023-03-24 11:53:42 10 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=25&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 10 [DEBUG] Custom field query 2023-03-24 11:53:42 10 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 25 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 11 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 11 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 26 2023-03-24 11:53:42 11 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=26&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 11 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26 LIMIT 1 2023-03-24 11:53:42 11 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/dhroner-riesling 2023-03-24 11:53:42 11 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=26&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 11 [DEBUG] Custom field query 2023-03-24 11:53:42 11 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 26 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 12 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 12 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 27 2023-03-24 11:53:42 12 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=27&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 12 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 27 LIMIT 1 2023-03-24 11:53:42 12 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-riesling-feinherb 2023-03-24 11:53:42 12 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=27&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 12 [DEBUG] Custom field query 2023-03-24 11:53:42 12 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 27 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 13 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 13 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 28 2023-03-24 11:53:42 13 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=28&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 13 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 28 LIMIT 1 2023-03-24 11:53:42 13 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/piesporter-riesling 2023-03-24 11:53:42 13 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=28&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 13 [DEBUG] Custom field query 2023-03-24 11:53:42 13 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 28 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 14 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 14 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 29 2023-03-24 11:53:42 14 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=29&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 14 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 29 LIMIT 1 2023-03-24 11:53:42 14 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-riesling-kabinett 2023-03-24 11:53:42 14 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=29&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 14 [DEBUG] Custom field query 2023-03-24 11:53:42 14 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 29 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 15 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 15 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 31 2023-03-24 11:53:42 15 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=31&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 15 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 31 LIMIT 1 2023-03-24 11:53:42 15 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/dhroner-hofberg-gg 2023-03-24 11:53:42 15 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=31&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 15 [DEBUG] Custom field query 2023-03-24 11:53:42 15 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 31 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 16 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 16 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 32 OR `virtuemart_product_id` = 31 2023-03-24 11:53:42 16 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=32&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 16 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 31 LIMIT 1 2023-03-24 11:53:42 16 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/dhroner-hofberg-gg-1 2023-03-24 11:53:42 16 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=32&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 16 [DEBUG] Custom field query 2023-03-24 11:53:42 16 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 32 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 17 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 17 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 33 2023-03-24 11:53:42 17 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=33&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 17 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33 LIMIT 1 2023-03-24 11:53:42 17 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/dhroner-hofberg-in-der-saengerei 2023-03-24 11:53:42 17 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=33&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 17 [DEBUG] Custom field query 2023-03-24 11:53:42 17 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 33 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 18 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 18 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 34 OR `virtuemart_product_id` = 33 2023-03-24 11:53:42 18 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=34&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 18 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 33 LIMIT 1 2023-03-24 11:53:42 18 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/dhroner-hofberg-in-der-saengerei-1 2023-03-24 11:53:42 18 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=34&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 18 [DEBUG] Custom field query 2023-03-24 11:53:42 18 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 34 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 19 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 19 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 35 2023-03-24 11:53:42 19 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=35&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 19 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 35 LIMIT 1 2023-03-24 11:53:42 19 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-apotheke-in-den-sonnteilen 2023-03-24 11:53:42 19 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=35&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 19 [DEBUG] Custom field query 2023-03-24 11:53:42 19 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 35 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id` 2023-03-24 11:53:42 20 [DEBUG] Use shopper group ID: 0 2023-03-24 11:53:42 20 [QUERY] SELECT `product_desc`,`virtuemart_product_id` FROM `wman_virtuemart_products_de_de` WHERE `virtuemart_product_id` = 36 OR `virtuemart_product_id` = 35 2023-03-24 11:53:42 20 [DEBUG] Process non-SEF URL: index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=36&virtuemart_category_id=1&lang=de 2023-03-24 11:53:42 20 [QUERY] SELECT `virtuemart_category_id` FROM `wman_virtuemart_product_categories` WHERE `virtuemart_product_id` = 35 LIMIT 1 2023-03-24 11:53:42 20 [DEBUG] Loaded SEF URL: https://bollighoch2.de/shop/trittenheimer-apotheke-in-den-sonnteilen-1 2023-03-24 11:53:42 20 [QUERY] SELECT `sefurl` FROM `wman_csvi_sefurls` WHERE `plainurl` = 'index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=36&virtuemart_category_id=1&lang=de' 2023-03-24 11:53:42 20 [DEBUG] Custom field query 2023-03-24 11:53:42 20 [QUERY] SELECT `customfield_value`,`cf`.`virtuemart_customfield_id`,`cf`.`virtuemart_custom_id`,`cf`.`customfield_params`,`c`.`field_type`,`c`.`custom_element` FROM `wman_virtuemart_product_customfields` AS `cf` LEFT JOIN `wman_virtuemart_customs` AS `c` ON `c`.`virtuemart_custom_id` = `cf`.`virtuemart_custom_id` WHERE `cf`.`virtuemart_product_id` = 36 AND `c`.`field_type` NOT IN ('R', 'Z', 'G') ORDER BY `cf`.`ordering`,`cf`.`virtuemart_custom_id`