23/09/2022 08:46:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '608984' , '2022-09-21' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.44' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.55' , '118.55' , NOW() , NOW() ) 23/09/2022 08:46:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61919' 23/09/2022 08:46:23 am >> DELETE FROM ps_document_detail WHERE id_document = '61919' 23/09/2022 08:46:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61919' , '19685' , 'AMEN - OTT 2022' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 23/09/2022 08:46:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '7' 23/09/2022 08:46:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '7' , '1' ) 23/09/2022 08:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61919' , '12897' , 'SIGNOR PARROCO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 23/09/2022 08:46:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12897' AND id_supplier = '7' 23/09/2022 08:46:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12897' , '7' , '1' ) 23/09/2022 08:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61919' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33' , '26.1300' ) 23/09/2022 08:46:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '1671' AND id_supplier = '7' 23/09/2022 08:46:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1671' , '7' , '1' ) 23/09/2022 08:46:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61919' , '1114' , 'BIBBIA DEGLI SPOSI' , '6' , '6' , '4' , '18.50' , '18.5' , '0' , '33' , '74.3700' ) 23/09/2022 08:46:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '1114' AND id_supplier = '7' 23/09/2022 08:46:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1114' , '7' , '1' ) 23/09/2022 09:19:15 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 23/09/2022 09:19:15 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '166' , '1' ) 23/09/2022 09:19:15 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '166' , '1' ) 23/09/2022 09:19:15 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '166' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 23/09/2022 09:22:52 am >> UPDATE ps_address SET id_state = '138', lastname = 'DEMI ART KG DI MICHAEL DEMETZ & CO. ', address1 = 'VIA PALUA 10', address2 = '', postcode = '39047', dni = '', vat_number = '00632290219', city = 'S. CRISTINA VAL GARDENA', phone = '0471793468', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '166' 23/09/2022 09:22:52 am >> UPDATE ps_supplier SET email = 'info@demi-art.com', name = 'DEMI ART KG DI MICHAEL DEMETZ & CO. ', date_upd = NOW() WHERE id_supplier = '166' 23/09/2022 09:22:52 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '166' 23/09/2022 09:23:20 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 23/09/2022 09:23:21 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '503' , '1' ) 23/09/2022 09:23:21 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '503' , '2' ) 23/09/2022 09:23:21 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '503' , '3' ) 23/09/2022 09:23:21 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '503' , '1' , 'DEMI ART' , LOWER('DEMI-ART') ) 23/09/2022 09:23:21 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '503' , '1' , '0' ) 23/09/2022 09:48:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 09:48:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2819' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 23/09/2022 09:48:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61920' 23/09/2022 09:48:18 am >> DELETE FROM ps_document_detail WHERE id_document = '61920' 23/09/2022 09:48:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61920' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 23/09/2022 09:48:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 23/09/2022 09:48:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 23/09/2022 10:26:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 10:26:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2820' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.50' , '29.33' , NOW() , NOW() ) 23/09/2022 10:26:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61921' 23/09/2022 10:26:10 am >> DELETE FROM ps_document_detail WHERE id_document = '61921' 23/09/2022 10:26:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61921' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 23/09/2022 10:26:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/09/2022 10:26:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/09/2022 10:26:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61921' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 23/09/2022 10:26:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/09/2022 10:26:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/09/2022 10:35:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 10:35:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2821' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 23/09/2022 10:35:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61922' 23/09/2022 10:35:26 am >> DELETE FROM ps_document_detail WHERE id_document = '61922' 23/09/2022 10:35:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61922' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 23/09/2022 10:35:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/09/2022 10:35:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/09/2022 10:44:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 10:44:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2822' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 23/09/2022 10:44:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61923' 23/09/2022 10:44:32 am >> DELETE FROM ps_document_detail WHERE id_document = '61923' 23/09/2022 10:44:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61923' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 23/09/2022 10:44:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '15096' AND id_supplier = '' 23/09/2022 10:44:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15096' , '' , '1' ) 23/09/2022 10:44:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61923' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/09/2022 10:44:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 23/09/2022 10:44:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 23/09/2022 11:05:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 11:05:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2823' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.70' , '13.05' , NOW() , NOW() ) 23/09/2022 11:05:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61924' 23/09/2022 11:05:10 am >> DELETE FROM ps_document_detail WHERE id_document = '61924' 23/09/2022 11:05:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61924' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 23/09/2022 11:05:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '' 23/09/2022 11:05:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '' , '1' ) 23/09/2022 11:05:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61924' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 23/09/2022 11:05:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 23/09/2022 11:05:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 23/09/2022 12:29:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 12:29:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2824' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 23/09/2022 12:29:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61925' 23/09/2022 12:29:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '61925' 23/09/2022 12:29:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61925' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 23/09/2022 12:29:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 23/09/2022 12:29:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 23/09/2022 02:41:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2816' AND id_document != '61916' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-22') 23/09/2022 02:41:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2816', document_date = '2022-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.50', price_tax_excluded = '33.20', date_upd = NOW() WHERE id_document = '61916' 23/09/2022 02:41:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61916' 23/09/2022 02:41:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '61916' 23/09/2022 02:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61916' , '13363' , 'CORONA MM 6 ' , '15' , '-15' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '40.50' ) 23/09/2022 02:41:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 23/09/2022 02:41:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 23/09/2022 03:05:28 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/09/2022 03:05:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20006' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:05:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20006' , '1' , '1' , '2' , NOW() , NOW() ) 23/09/2022 03:05:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20006' , '0' , '1' , '0' , '0' ) 23/09/2022 03:06:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576938' AND id_product != '20006' AND ean13 != '' 23/09/2022 03:06:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788873576938', date_upd = NOW() WHERE id_product = '20006' 23/09/2022 03:06:59 pm >> UPDATE ps_product_lang SET name = 'FASCINO DEL MALE - G. CUCCI', description = '' WHERE id_product = '20006' 23/09/2022 03:06:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20006' 23/09/2022 03:06:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20006' 23/09/2022 03:06:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '20006' 23/09/2022 03:07:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20006' 23/09/2022 03:07:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20007' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:07:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20007' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20006' 23/09/2022 03:07:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20007' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20006' 23/09/2022 03:07:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576952' AND id_product != '20007' AND ean13 != '' 23/09/2022 03:07:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788873576952', date_upd = NOW() WHERE id_product = '20007' 23/09/2022 03:07:44 pm >> UPDATE ps_product_lang SET name = 'VIRTU\' CARDINALI - G. CUCCI', description = '' WHERE id_product = '20007' 23/09/2022 03:07:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20007' 23/09/2022 03:07:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20007' 23/09/2022 03:07:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '20007' 23/09/2022 03:07:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20007' 23/09/2022 03:07:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20008' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:07:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20008' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20007' 23/09/2022 03:07:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20008' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20007' 23/09/2022 03:08:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873672999' AND id_product != '20008' AND ean13 != '' 23/09/2022 03:08:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788873672999', date_upd = NOW() WHERE id_product = '20008' 23/09/2022 03:08:36 pm >> UPDATE ps_product_lang SET name = 'FRANCESCO DI SALES - L. NUOVO', description = '' WHERE id_product = '20008' 23/09/2022 03:08:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20008' 23/09/2022 03:08:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '380', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20008' 23/09/2022 03:08:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '20008' 23/09/2022 03:08:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20008' 23/09/2022 03:08:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20009' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:08:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20009' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20008' 23/09/2022 03:08:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20009' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20008' 23/09/2022 03:10:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872571224' AND id_product != '20009' AND ean13 != '' 23/09/2022 03:10:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788872571224', date_upd = NOW() WHERE id_product = '20009' 23/09/2022 03:10:17 pm >> UPDATE ps_product_lang SET name = 'E\' IL SIGNORE! - V. BATTAGLIA', description = '' WHERE id_product = '20009' 23/09/2022 03:10:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20009' 23/09/2022 03:10:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '492', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20009' 23/09/2022 03:10:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20009' 23/09/2022 03:10:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20009' 23/09/2022 03:10:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20010' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:10:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20010' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20009' 23/09/2022 03:10:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20010' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20009' 23/09/2022 03:12:02 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 23/09/2022 03:12:02 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '504' , '1' ) 23/09/2022 03:12:02 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '504' , '2' ) 23/09/2022 03:12:02 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '504' , '3' ) 23/09/2022 03:12:02 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '504' , '1' , 'EDEN EDIZIONI' , LOWER('EDEN-EDIZIONI') ) 23/09/2022 03:12:02 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '504' , '1' , '0' ) 23/09/2022 03:12:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280061089' AND id_product != '20010' AND ean13 != '' 23/09/2022 03:12:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '8/1', ean13 = '9791280061089', date_upd = NOW() WHERE id_product = '20010' 23/09/2022 03:12:11 pm >> UPDATE ps_product_lang SET name = 'E LO ADORARONO - S. SAVAGLIA', description = '' WHERE id_product = '20010' 23/09/2022 03:12:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '20010' 23/09/2022 03:12:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '504', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20010' 23/09/2022 03:12:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20010' 23/09/2022 03:12:12 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20010' 23/09/2022 03:12:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20011' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:12:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20011' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20010' 23/09/2022 03:12:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20011' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20010' 23/09/2022 03:13:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573325' AND id_product != '20011' AND ean13 != '' 23/09/2022 03:13:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788898573325', date_upd = NOW() WHERE id_product = '20011' 23/09/2022 03:13:17 pm >> UPDATE ps_product_lang SET name = 'UOMO PER L\'UOMO - NOVENA A S. MASSIMILIANO KOLBE - A. CALZORARO', description = '' WHERE id_product = '20011' 23/09/2022 03:13:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20011' 23/09/2022 03:13:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20011' 23/09/2022 03:13:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20011' 23/09/2022 03:13:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20011' 23/09/2022 03:13:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20012' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:13:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20012' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20011' 23/09/2022 03:13:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20012' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20011' 23/09/2022 03:14:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898573332' AND id_product != '20012' AND ean13 != '' 23/09/2022 03:14:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788898573332', date_upd = NOW() WHERE id_product = '20012' 23/09/2022 03:14:42 pm >> UPDATE ps_product_lang SET name = 'MARIA L\'IMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO', description = '' WHERE id_product = '20012' 23/09/2022 03:14:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20012' 23/09/2022 03:14:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '419', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20012' 23/09/2022 03:14:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20012' 23/09/2022 03:15:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/09/2022 03:15:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20013' , '1' , '' , 'nuovo-prodotto' ) 23/09/2022 03:15:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20013' , '1' , '1' , '2' , NOW() , NOW() ) 23/09/2022 03:15:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20013' , '0' , '1' , '0' , '0' ) 23/09/2022 03:16:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881991792' AND id_product != '20013' AND ean13 != '' 23/09/2022 03:16:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788881991792', date_upd = NOW() WHERE id_product = '20013' 23/09/2022 03:16:12 pm >> UPDATE ps_product_lang SET name = 'CALENDARIO FRATE INDOVINO 2023', description = '' WHERE id_product = '20013' 23/09/2022 03:16:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '20013' 23/09/2022 03:16:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '219', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20013' 23/09/2022 03:16:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20013' 23/09/2022 03:20:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '4906' , '2022-09-22' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '162.52' , '162.52' , NOW() , NOW() ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61926' 23/09/2022 03:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '61926' 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20007' , 'VIRTU CARDINALI - G. CUCCI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20007' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20007' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20006' , 'FASCINO DEL MALE - G. CUCCI' , '1' , '1' , '4' , '19.00' , '19' , '0' , '35' , '12.3500' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20006' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20006' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20009' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20009' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20008' , 'FRANCESCO DI SALES - L. NUOVO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20008' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20008' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20010' , 'E LO ADORARONO - S. SAVAGLIA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '35' , '24.7000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20010' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20010' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20013' , 'CALENDARIO FRATE INDOVINO 2023' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20013' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20013' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '3' , '3' , '4' , '4.00' , '4' , '0' , '35' , '7.8000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '20011' , 'UOMO PER LUOMO - NOVENA A S. MASSIMILIANO KOLBE - A. CALZORARO' , '2' , '2' , '4' , '4.00' , '4' , '0' , '35' , '5.2000' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20011' AND id_supplier = '107' 23/09/2022 03:20:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20011' , '107' , '1' ) 23/09/2022 03:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 23/09/2022 03:20:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 23/09/2022 03:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 23/09/2022 03:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '24' , '24' , '4' , '1.20' , '1.2' , '0' , '35' , '18.7200' ) 23/09/2022 03:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 23/09/2022 03:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 23/09/2022 03:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '1' , '4' , '27.00' , '27' , '0' , '35' , '17.5500' ) 23/09/2022 03:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18311' AND id_supplier = '107' 23/09/2022 03:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18311' , '107' , '1' ) 23/09/2022 03:20:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61926' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '2' , '2' , '4' , '10.00' , '10' , '0' , '35' , '13.0000' ) 23/09/2022 03:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 23/09/2022 03:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 23/09/2022 04:09:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 04:09:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2825' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 23/09/2022 04:09:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61927' 23/09/2022 04:09:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '61927' 23/09/2022 04:09:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61927' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 23/09/2022 04:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 23/09/2022 04:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 23/09/2022 04:09:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61927' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 23/09/2022 04:09:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 23/09/2022 04:09:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 23/09/2022 04:11:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2716' AND id_document != '61775' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-13') 23/09/2022 04:11:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2716', document_date = '2022-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '197.70', price_tax_excluded = '167.37', date_upd = NOW() WHERE id_document = '61775' 23/09/2022 04:11:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61775' 23/09/2022 04:11:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '61775' 23/09/2022 04:11:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 23/09/2022 04:11:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 23/09/2022 04:11:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '25' , '-25' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '50.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '7202' , 'ARTICOLI RELIGIOSI' , '25' , '-25' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '8.75' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.8500' , '2.85' , '0' , '0' , '2.85' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 23/09/2022 04:11:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61775' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 23/09/2022 04:11:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 23/09/2022 04:11:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 23/09/2022 04:47:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '161' 23/09/2022 04:47:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '161' , '10' , '145' , 'PARR. SANT\'ANDREA AP. IN SANTA MARIA CAPUA VETERE' , 'IODICE ' , 'DON GENNARO' , 'VIA G. MAZZINI VICO III, 8' , '' , '81047' , 'MACERATA CAMPANIA' , 'SPEDIRE ALL\'INDIRIZZO SOPRA CHE E\' QUELLO DI CASA' , '3319872191' , '' , '' , '94000610611' , NOW() , NOW() ) 23/09/2022 04:47:19 pm >> UPDATE ps_customer SET email = 'gennaro0404@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '161' 23/09/2022 05:21:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 05:21:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2826' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 23/09/2022 05:21:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61928' 23/09/2022 05:21:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '61928' 23/09/2022 05:21:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61928' , '5598' , 'LECTIO DIVINA OGNI GIORNO - 8' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 23/09/2022 05:21:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5598' AND id_supplier = '' 23/09/2022 05:21:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5598' , '' , '1' ) 23/09/2022 05:54:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 05:54:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '62' , '2022-09-23' , '' , '1429' , '0' , '4670225' , 'VIA CASA POLITO, 3 80075 PANZA DI ISCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 23/09/2022 05:54:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6340' 23/09/2022 05:54:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '6340' 23/09/2022 05:54:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6340' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 23/09/2022 05:59:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '63' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 05:59:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '63' , '2022-09-23' , '' , '3451' , '0' , '4670177' , 'VIA CRESPI, 42 28100 NOVARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 23/09/2022 05:59:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6341' 23/09/2022 05:59:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '6341' 23/09/2022 05:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6341' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 23/09/2022 06:02:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '64' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:02:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '64' , '2022-09-23' , '' , '2116' , '0' , '4670255' , 'VIA ALESSANDRIA 10 27100 PAVIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 23/09/2022 06:02:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6342' 23/09/2022 06:02:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '6342' 23/09/2022 06:02:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6342' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 23/09/2022 06:04:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '65' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:04:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '65' , '2022-09-23' , '' , '3519' , '0' , '4670246' , 'VIA LOMBARDIA 50 92100 VILLAGGIO MOSE\\\'' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '54.20' , '54.20' , NOW() , NOW() ) 23/09/2022 06:04:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6343' 23/09/2022 06:04:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '6343' 23/09/2022 06:04:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6343' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 23/09/2022 06:04:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6343' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 23/09/2022 06:06:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '66' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:06:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '66' , '2022-09-23' , '' , '3433' , '0' , '4670247' , 'P.ZZA MATTEOTTI 18 06038 SPELLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '102.60' , '102.60' , NOW() , NOW() ) 23/09/2022 06:06:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6344' 23/09/2022 06:06:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '6344' 23/09/2022 06:06:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6344' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '6' , '-6' , '4' , '18.00' , '18' , '0' , '5' , '102.60' ) 23/09/2022 06:09:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '67' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:09:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '67' , '2022-09-23' , '' , '935' , '0' , '4670136' , 'VIA SOPRANA, 11 57031 CAPOLIVERI-IS.ELBA' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '56.20' , '56.20' , NOW() , NOW() ) 23/09/2022 06:09:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6345' 23/09/2022 06:09:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '6345' 23/09/2022 06:09:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6345' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 23/09/2022 06:10:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:10:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '68' , '2022-09-23' , '' , '3474' , '0' , '4670135' , 'PIAZZA N.S. DI GUADALUPE, 12 00135 ROMA' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.10' , '39.10' , NOW() , NOW() ) 23/09/2022 06:10:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6346' 23/09/2022 06:10:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '6346' 23/09/2022 06:10:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6346' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 23/09/2022 06:12:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '69' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:12:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '69' , '2022-09-23' , '' , '3375' , '0' , '4670253' , 'VIA PIER TRAVERSARI, 10 48121 RAVENNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 23/09/2022 06:12:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6347' 23/09/2022 06:12:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '6347' 23/09/2022 06:12:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6347' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.00' , '18' , '0' , '5' , '51.30' ) 23/09/2022 06:15:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:15:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '70' , '2022-09-23' , '' , '161' , '0' , '79347648' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '85.50' , '85.50' , NOW() , NOW() ) 23/09/2022 06:15:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6348' 23/09/2022 06:15:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '6348' 23/09/2022 06:15:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6348' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '-5' , '4' , '18.00' , '18' , '0' , '5' , '85.50' ) 23/09/2022 06:22:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:22:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2827' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 23/09/2022 06:22:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61929' 23/09/2022 06:22:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '61929' 23/09/2022 06:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61929' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 23/09/2022 06:22:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4696' AND id_supplier = '' 23/09/2022 06:22:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4696' , '' , '1' ) 23/09/2022 06:24:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:24:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '71' , '2022-09-23' , '' , '3529' , '0' , '4670266' , 'VIA MICHELE ROSI 186 - ARA NOVA 00054 FIUMICINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 23/09/2022 06:24:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6349' 23/09/2022 06:24:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '6349' 23/09/2022 06:24:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6349' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 23/09/2022 06:28:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:28:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '72' , '2022-09-23' , '' , '3535' , '0' , '4670276' , 'VIA CHIESA 9 86031 CASTELMAURO' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 23/09/2022 06:28:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6350' 23/09/2022 06:28:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '6350' 23/09/2022 06:28:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6350' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/09/2022 06:30:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:30:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '73' , '2022-09-23' , '' , '3457' , '0' , '4670111' , 'P. ZZA S. METODIO, 1 96100 SIRACUSA' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 23/09/2022 06:30:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6351' 23/09/2022 06:30:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '6351' 23/09/2022 06:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6351' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/09/2022 06:31:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '74' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:31:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '74' , '2022-09-23' , '' , '3382' , '0' , '4670283' , 'VIA ARTENA, 48 00038 VALMONTONE' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.10' , '39.10' , NOW() , NOW() ) 23/09/2022 06:31:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6352' 23/09/2022 06:31:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '6352' 23/09/2022 06:31:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6352' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 23/09/2022 06:46:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '61878' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-20') 23/09/2022 06:46:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2022-09-20', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.10', price_tax_excluded = '53.93', date_upd = NOW() WHERE id_document = '61878' 23/09/2022 06:46:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61878' 23/09/2022 06:46:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '61878' 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '8.40' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 23/09/2022 06:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61878' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/09/2022 06:46:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 23/09/2022 06:46:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 23/09/2022 06:52:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-23') 23/09/2022 06:52:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2828' , '2022-09-23' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.41' , NOW() , NOW() ) 23/09/2022 06:52:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61930' 23/09/2022 06:52:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '61930' 23/09/2022 06:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61930' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '25.00' ) 23/09/2022 06:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 23/09/2022 06:52:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 23/09/2022 06:52:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61930' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/09/2022 06:52:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 23/09/2022 06:52:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 23/09/2022 06:56:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1429' 23/09/2022 06:56:10 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1429' , '10' , '183' , '' , 'CASTALDI ' , 'DON GIOACCHINO' , 'VIA CASA POLITO, 3' , '' , '80075' , 'PANZA DI ISCHIA' , '' , '3395303421' , '' , '' , '' , NOW() , NOW() ) 23/09/2022 06:56:10 pm >> UPDATE ps_customer SET email = 'dongioacchino@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1429'