# # #Date: 2016-04-13 07:24:18 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2016-04-13 07:24:18 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2016-04-13 07:24:18 0 [QUERY] SELECT csvi_log_id FROM 1234_csvi_logs ORDER BY csvi_log_id 2016-04-13 07:24:19 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2016-04-13 07:24:19 0 [QUERY] SELECT csvi_log_id FROM 1234_csvi_logs ORDER BY csvi_log_id 2016-04-13 07:24:19 0 [DEBUG] CSVI Pro Version: 6.5.6 2016-04-13 07:24:19 0 [DEBUG] Joomla! version: 3.4.8 2016-04-13 07:24:19 0 [DEBUG] PHP version: 5.4.43 2016-04-13 07:24:19 0 [DEBUG] ========================= 2016-04-13 07:24:19 0 [DEBUG] action: export 2016-04-13 07:24:19 0 [DEBUG] component: com_virtuemart 2016-04-13 07:24:19 0 [DEBUG] operation: product 2016-04-13 07:24:19 0 [DEBUG] localpath: /var/www/webroot/ 2016-04-13 07:24:19 0 [DEBUG] ftphost: 2016-04-13 07:24:19 0 [DEBUG] ftpport: 2016-04-13 07:24:19 0 [DEBUG] ftproot: 2016-04-13 07:24:19 0 [DEBUG] ftpfile: 2016-04-13 07:24:19 0 [DEBUG] export_email_subject: 2016-04-13 07:24:19 0 [DEBUG] export_email_body: 2016-04-13 07:24:19 0 [DEBUG] export_filename: productfeed-carbags-affiliates.xml 2016-04-13 07:24:19 0 [DEBUG] export_file: xml 2016-04-13 07:24:19 0 [DEBUG] export_site: beslist 2016-04-13 07:24:19 0 [DEBUG] field_delimiter: , 2016-04-13 07:24:19 0 [DEBUG] text_enclosure: 2016-04-13 07:24:19 0 [DEBUG] include_column_headers: No 2016-04-13 07:24:19 0 [DEBUG] signature: No 2016-04-13 07:24:19 0 [DEBUG] publish_state: Yes 2016-04-13 07:24:19 0 [DEBUG] recordstart: 2016-04-13 07:24:19 0 [DEBUG] recordend: 2016-04-13 07:24:19 0 [DEBUG] export_date_format: d/m/Y H:i:s 2016-04-13 07:24:19 0 [DEBUG] export_price_format_decimal: 2 2016-04-13 07:24:19 0 [DEBUG] export_price_format_decsep: , 2016-04-13 07:24:19 0 [DEBUG] export_price_format_thousep: 2016-04-13 07:24:19 0 [DEBUG] header: 2016-04-13 07:24:19 0 [DEBUG] body: 2016-04-13 07:24:19 0 [DEBUG] footer: 2016-04-13 07:24:19 0 [DEBUG] language: nl-NL 2016-04-13 07:24:19 0 [DEBUG] exportsef: Yes 2016-04-13 07:24:19 0 [DEBUG] producturl_suffix: 2016-04-13 07:24:19 0 [DEBUG] vm_itemid: 2016-04-13 07:24:19 0 [DEBUG] picture_limit: Yes 2016-04-13 07:24:19 0 [DEBUG] featured: No 2016-04-13 07:24:19 0 [DEBUG] category_separator: / 2016-04-13 07:24:19 0 [DEBUG] publish_state_categories: Yes 2016-04-13 07:24:19 0 [DEBUG] incl_subcategory: Yes 2016-04-13 07:24:19 0 [DEBUG] parent_only: Yes 2016-04-13 07:24:19 0 [DEBUG] child_only: No 2016-04-13 07:24:19 0 [DEBUG] incl_productskufilter: Yes 2016-04-13 07:24:19 0 [DEBUG] productskufilter: 2016-04-13 07:24:19 0 [DEBUG] stocklevelstart: 2016-04-13 07:24:19 0 [DEBUG] stocklevelend: 2016-04-13 07:24:19 0 [DEBUG] shopper_group_price: none 2016-04-13 07:24:19 0 [DEBUG] priceoperator: gt 2016-04-13 07:24:19 0 [DEBUG] pricefrom: 2016-04-13 07:24:19 0 [DEBUG] priceto: 2016-04-13 07:24:19 0 [DEBUG] price_quantity_start: 2016-04-13 07:24:19 0 [DEBUG] price_quantity_end: 2016-04-13 07:24:19 0 [DEBUG] targetcurrency: 2016-04-13 07:24:19 0 [DEBUG] force_shopper_group_price: none 2016-04-13 07:24:19 0 [DEBUG] groupbyfields: 2016-04-13 07:24:19 0 [DEBUG] sortfields: 2016-04-13 07:24:19 0 [DEBUG] use_system_limits: No 2016-04-13 07:24:19 0 [DEBUG] max_execution_time: 2016-04-13 07:24:19 0 [DEBUG] memory_limit: 2016-04-13 07:24:19 0 [DEBUG] ========================= 2016-04-13 07:24:19 0 [DEBUG] Export field: titel 2016-04-13 07:24:19 0 [DEBUG] Export field: prijs 2016-04-13 07:24:19 0 [DEBUG] Export field: product_url 2016-04-13 07:24:19 0 [DEBUG] Export field: url_productplaatje 2016-04-13 07:24:19 0 [DEBUG] Export field: levertijd 2016-04-13 07:24:19 0 [DEBUG] Export field: verzendkosten 2016-04-13 07:24:19 0 [DEBUG] Export field: ean 2016-04-13 07:24:19 0 [DEBUG] Export field: merk 2016-04-13 07:24:19 0 [DEBUG] Export field: beschrijving 2016-04-13 07:24:19 0 [DEBUG] Export field: sku 2016-04-13 07:24:19 0 [DEBUG] Get all the product IDs in the selected categories 2016-04-13 07:24:19 0 [QUERY] SELECT p.virtuemart_product_id FROM 1234_virtuemart_products p LEFT JOIN 1234_virtuemart_product_categories x ON p.virtuemart_product_id = x.virtuemart_product_id WHERE x.virtuemart_category_id IN (2) AND p.product_parent_id = 0 2016-04-13 07:24:19 0 [DEBUG] Export query SELECT `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_products`.`product_parent_id`, `#__virtuemart_currencies`.`currency_code_3`, `#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`, `#__virtuemart_products`.`product_url`, `product_gtin`, `product_sku` FROM `#__virtuemart_products` LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency` LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id` WHERE `#__virtuemart_product_categories`.`virtuemart_category_id` IN (2) AND #__virtuemart_products.virtuemart_product_id IN (59,60,112,131,138,144,201,204,205,226,264,265,270,271,272,273,290,348,349,393,397,399,416,429,430,454,455,465) AND #__virtuemart_products.published = 1 AND #__virtuemart_product_shoppergroups.virtuemart_shoppergroup_id IN ('0') AND #__virtuemart_manufacturers.virtuemart_manufacturer_id IN ('0') GROUP BY #__virtuemart_products.virtuemart_product_id