03/01/2023 09:00:30 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 09:00:30 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' , '16' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 03/01/2023 09:00:30 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 = '78145' 03/01/2023 09:00:30 am >> DELETE FROM ps_document_detail WHERE id_document = '78145' 03/01/2023 09:00:30 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 ( '78145' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 03/01/2023 09:48:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 09:48:33 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 ( '24' , '1/A' , '2023-01-03' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALE CURTERI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 03/01/2023 09:48:33 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 = '78146' 03/01/2023 09:48:33 am >> DELETE FROM ps_document_detail WHERE id_document = '78146' 03/01/2023 09:48: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 ( '78146' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '' , '90.00' ) 03/01/2023 09:49:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '78146' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 09:49:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2023-01-03', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALE CURTERI', 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 = '92.00', price_tax_excluded = '75.77', date_upd = NOW() WHERE id_document = '78146' 03/01/2023 09:49:07 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 = '78146' 03/01/2023 09:49:07 am >> DELETE FROM ps_document_detail WHERE id_document = '78146' 03/01/2023 09:49:07 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 ( '78146' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '' , '90.00' ) 03/01/2023 09:49:07 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 ( '78146' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 03/01/2023 10:55:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0160682/S' AND id_product != '13049' AND ean13 != '' 03/01/2023 10:55:31 am >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0160682/S', date_upd = NOW() WHERE id_product = '13049' 03/01/2023 10:55:31 am >> UPDATE ps_product_lang SET name = 'LITURGICO ART. 60LT BIANCO SUPER', description = '' WHERE id_product = '13049' 03/01/2023 10:55:31 am >> UPDATE ps_product SET wholesale_price = '1.48', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '13049' 03/01/2023 10:55:31 am >> UPDATE ps_product_shop SET wholesale_price = '1.48', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13049' 03/01/2023 10:55:31 am >> DELETE FROM ps_specific_price WHERE id_product = '13049' 03/01/2023 10:55:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0160681/S' AND id_product != '5903' AND ean13 != '' 03/01/2023 10:55:41 am >> UPDATE ps_product SET id_supplier = '36', reference = '2015', ean13 = '0160681/S', date_upd = NOW() WHERE id_product = '5903' 03/01/2023 10:55:41 am >> UPDATE ps_product_lang SET name = 'LITURGICO ART. 60LT ROSSO SUPER', description = '' WHERE id_product = '5903' 03/01/2023 10:55:41 am >> UPDATE ps_product SET wholesale_price = '1.48', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '5903' 03/01/2023 10:55:41 am >> UPDATE ps_product_shop SET wholesale_price = '1.48', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5903' 03/01/2023 10:55:41 am >> DELETE FROM ps_specific_price WHERE id_product = '5903' 03/01/2023 11:02:58 am >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:02:58 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' , '17' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 03/01/2023 11:02:58 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 = '78147' 03/01/2023 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '78147' 03/01/2023 11:02:58 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 ( '78147' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/01/2023 11:02:58 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 ( '78147' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/01/2023 11:02:58 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 ( '78147' , '20528' , 'AMEN - MAR 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/01/2023 11:02:58 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 ( '78147' , '20527' , 'AMEN - APR 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/01/2023 11:03:33 am >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:03:33 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' , '18' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 03/01/2023 11:03:33 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 = '78148' 03/01/2023 11:03:33 am >> DELETE FROM ps_document_detail WHERE id_document = '78148' 03/01/2023 11:03: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 ( '78148' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 03/01/2023 11:07:54 am >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:07:54 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' , '19' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 03/01/2023 11:07:54 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 = '78149' 03/01/2023 11:07:54 am >> DELETE FROM ps_document_detail WHERE id_document = '78149' 03/01/2023 11:07:54 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 ( '78149' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 03/01/2023 11:11:19 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'xVx6YEnvl8GyCeh8' , NOW() , NOW() ) 03/01/2023 11:11:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3997' , '1' ) 03/01/2023 11:11:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3997' , '2' ) 03/01/2023 11:11:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3997' , '3' ) 03/01/2023 11:14:26 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3997' 03/01/2023 11:14:27 am >> 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 ( '3997' , '10' , '130' , 'PARROCCHIA SANTI DOMENICO E FRANCESCO' , 'GRELLA' , 'DON ALBERICO' , 'VIA RINACITA' , '' , '83055' , 'STURNO' , '' , '' , '3457786097' , '' , '' , NOW() , NOW() ) 03/01/2023 11:14:27 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3997' 03/01/2023 11:14:59 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3997' 03/01/2023 11:14:59 am >> 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 ( '3997' , '10' , '130' , 'PARROCCHIA SANTI DOMENICO E FRANCESCO' , 'GRELLA' , 'DON ALBERICO' , 'VIA RINACITA' , '' , '83055' , 'STURNO' , '' , '' , '3457786097' , '' , '' , NOW() , NOW() ) 03/01/2023 11:14:59 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3997' 03/01/2023 11:15:09 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3997' 03/01/2023 11:15:09 am >> 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 ( '3997' , '10' , '130' , 'PARROCCHIA SANTI DOMENICO E FRANCESCO' , 'GRELLA' , 'DON ALBERICO' , 'VIA RINASCITA' , '' , '83055' , 'STURNO' , '' , '' , '3457786097' , '' , '' , NOW() , NOW() ) 03/01/2023 11:15:09 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3997' 03/01/2023 11:15:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3997' 03/01/2023 11:15:53 am >> 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 ( '3997' , '10' , '130' , 'PARROCCHIA SANTI DOMENICO E FRANCESCO' , 'GRELLA' , 'DON ALBERICO' , 'VIA RINASCITA' , '' , '83055' , 'STURNO' , '' , '' , '3457786097' , '' , '9001870642' , NOW() , NOW() ) 03/01/2023 11:15:53 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3997' 03/01/2023 11:18:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:18:31 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 ( '21' , '1' , '2023-01-03' , '' , '3997' , '0' , '4678088' , 'VIA RINASCITA 83055 STURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.73' , '134.73' , NOW() , NOW() ) 03/01/2023 11:18:31 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 = '78150' 03/01/2023 11:18:31 am >> DELETE FROM ps_document_detail WHERE id_document = '78150' 03/01/2023 11:18:31 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 ( '78150' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.40' , '2.4' , '0' , '15' , '51.00' ) 03/01/2023 11:18:31 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 ( '78150' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 03/01/2023 11:18:31 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 ( '78150' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '15' , '20.40' ) 03/01/2023 11:18:31 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 ( '78150' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '15' , '15.30' ) 03/01/2023 11:18:31 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 ( '78150' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '15' , '20.40' ) 03/01/2023 11:18:31 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 ( '78150' , '9675' , 'SARETE MIEI TESTIMONI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 03/01/2023 11:18:31 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 ( '78150' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:18:31 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 ( '78150' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:18:31 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 ( '78150' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:18:31 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 ( '78150' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 03/01/2023 11:19:17 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:19:17 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' , '20' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.45' , '78.45' , NOW() , NOW() ) 03/01/2023 11:19:17 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 = '78151' 03/01/2023 11:19:17 am >> DELETE FROM ps_document_detail WHERE id_document = '78151' 03/01/2023 11:19:17 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 ( '78151' , '5444' , 'IO SONO CON VOI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 03/01/2023 11:19:17 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 ( '78151' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 03/01/2023 11:19:17 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 ( '78151' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 03/01/2023 11:19:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '78150' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:19:40 am >> UPDATE ps_document SET id_document_type = '21', document_num = '1', document_date = '2023-01-03', document_letter = '', id_customer = '3997', id_supplier = '', id_address = '4678088', address1 = 'VIA RINASCITA 83055 STURNO', 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 = '136.85', price_tax_excluded = '136.85', date_upd = NOW() WHERE id_document = '78150' 03/01/2023 11:19:40 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 = '78150' 03/01/2023 11:19:40 am >> DELETE FROM ps_document_detail WHERE id_document = '78150' 03/01/2023 11:19:40 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 ( '78150' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '15' , '51.00' ) 03/01/2023 11:19:40 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 ( '78150' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 03/01/2023 11:19:40 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 ( '78150' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 03/01/2023 11:19:40 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 ( '78150' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 03/01/2023 11:19:40 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 ( '78150' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 03/01/2023 11:19:40 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 ( '78150' , '9675' , 'SARETE MIEI TESTIMONI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 03/01/2023 11:19:40 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 ( '78150' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:19:40 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 ( '78150' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:19:40 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 ( '78150' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:19:40 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 ( '78150' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 11:21:13 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:21:13 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' , '21' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/01/2023 11:21:13 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 = '78152' 03/01/2023 11:21:13 am >> DELETE FROM ps_document_detail WHERE id_document = '78152' 03/01/2023 11:21:13 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 ( '78152' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/01/2023 11:30:26 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:30: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' , '22' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.50' , '120.70' , NOW() , NOW() ) 03/01/2023 11:30: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 = '78153' 03/01/2023 11:30:26 am >> DELETE FROM ps_document_detail WHERE id_document = '78153' 03/01/2023 11:30: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 ( '78153' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 03/01/2023 11:30: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 ( '78153' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 03/01/2023 11:30: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 ( '78153' , '18984' , 'POLO FELPATO ML ' , '2' , '-2' , '1' , '57.5' , '47.131147540984' , '22' , '0' , '115.00' ) 03/01/2023 11:32:25 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 11:32:25 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' , '23' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 03/01/2023 11:32:25 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 = '78154' 03/01/2023 11:32:25 am >> DELETE FROM ps_document_detail WHERE id_document = '78154' 03/01/2023 11:32:25 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 ( '78154' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 03/01/2023 02:31:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '77489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 03/01/2023 02:31:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4048', document_date = '2022-12-23', 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 = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '77489' 03/01/2023 02:31:51 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 = '77489' 03/01/2023 02:31:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '77489' 03/01/2023 02:31: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 ( '77489' , '19998' , 'GESU\' BAMBINO CM 28 - BJ142-28E' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 03/01/2023 02:31: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 ( '77489' , '15005' , 'PRESEPE LEGNO CON LUCI CM 40 - 31127' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 03/01/2023 02:33:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 03/01/2023 02:33:30 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12 - 100,00 03/23', 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 = '3395.00', price_tax_excluded = '2782.79', date_upd = NOW() WHERE id_document = '56617' 03/01/2023 02:33:30 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 = '56617' 03/01/2023 02:33:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 03/01/2023 02:33:30 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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 03/01/2023 02:33:30 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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 03/01/2023 02:33:30 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 ( '56617' , '18984' , 'POLO FELPATO ML + cardigan' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 03/01/2023 02:33:30 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 ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '-1' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 03/01/2023 02:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3875' AND id_document != '77282' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-15') 03/01/2023 02:51:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3875', document_date = '2022-12-15', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '77282' 03/01/2023 02:51: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 = '77282' 03/01/2023 02:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '77282' 03/01/2023 02:51: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 ( '77282' , '13134' , 'BAMBINO GESU BETLEMME - OCCHI DI VETRO - P514' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/01/2023 02:52:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3930' AND id_document != '77352' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-19') 03/01/2023 02:52:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3930', document_date = '2022-12-19', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '77352' 03/01/2023 02:52:25 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 = '77352' 03/01/2023 02:52:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '77352' 03/01/2023 02:52:25 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 ( '77352' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 03/01/2023 02:52:25 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 ( '77352' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '4' , '-4' , '1' , '15' , '12.295081967213' , '22' , '0' , '60.00' ) 03/01/2023 02:52:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3921' AND id_document != '77342' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 03/01/2023 02:52:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3921', document_date = '2022-12-17', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '77342' 03/01/2023 02:52: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 = '77342' 03/01/2023 02:52:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '77342' 03/01/2023 02:52:50 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 ( '77342' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 03/01/2023 02:52:50 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 ( '77342' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 03/01/2023 03:01:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '332' AND id_document != '76681' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-09') 03/01/2023 03:01:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '332', document_date = '2022-12-09', document_letter = '', id_customer = '3979', id_supplier = '', id_address = '4677354', address1 = 'Via Serrenti , 23 09030 Samassi ', address2 = '', note = '', price_shipping = '5.76', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '24.00', date_upd = NOW() WHERE id_document = '76681' 03/01/2023 03:01:41 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 = '76681' 03/01/2023 03:01:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '76681' 03/01/2023 03:01:41 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 ( '76681' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '8' , '-8' , '4' , '2.4000' , '2.4' , '0' , '5' , '18.24' ) 03/01/2023 03:06:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 03/01/2023 03:06:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 50,00', 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 = '790.00', price_tax_excluded = '753.93', date_upd = NOW() WHERE id_document = '59768' 03/01/2023 03: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 = '59768' 03/01/2023 03:06:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '59768' 03/01/2023 03:06:36 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 ( '59768' , '0' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485.0000' , '485' , '0' , '0' , '485.00' ) 03/01/2023 03:06:36 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 ( '59768' , '0' , 'GIGLIO DORATO DA SCONTARE IN C/ VISIONE' , '1' , '-1' , '0' , '105.0000' , '105' , '0' , '0' , '105.00' ) 03/01/2023 03:06:36 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 ( '59768' , '20228' , 'BAMBINELLO IN GESSO CM 30 STILE ANTICO - J202/30' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 03/01/2023 03:14:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 03:14: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 ( '11' , '24' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.80' , '69.20' , NOW() , NOW() ) 03/01/2023 03:14: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 = '78155' 03/01/2023 03:14:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '78155' 03/01/2023 03:14: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 ( '78155' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 03/01/2023 03:14: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 ( '78155' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 03/01/2023 04:12:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 04: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 ( '11' , '25' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 03/01/2023 04: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 = '78156' 03/01/2023 04:12:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '78156' 03/01/2023 04: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 ( '78156' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 03/01/2023 04:12:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 04:12: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 ( '11' , '26' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 03/01/2023 04:12: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 = '78157' 03/01/2023 04:12:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '78157' 03/01/2023 04:12: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 ( '78157' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 03/01/2023 05:00:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 05:00:32 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' , '27' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 03/01/2023 05:00:32 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 = '78158' 03/01/2023 05:00:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '78158' 03/01/2023 05:00:33 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 ( '78158' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/01/2023 06:00:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 06:00:44 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' , '28' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/01/2023 06:00:44 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 = '78159' 03/01/2023 06:00:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '78159' 03/01/2023 06:00:44 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 ( '78159' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/01/2023 06:03:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3762' AND id_document != '76102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-05') 03/01/2023 06:03:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3762', document_date = '2022-12-05', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '76102' 03/01/2023 06:03:55 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 = '76102' 03/01/2023 06:03:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '76102' 03/01/2023 06:03:55 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 ( '76102' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 03/01/2023 06:03:55 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 ( '76102' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 03/01/2023 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 ( '32' , '22v606319' , '2022-12-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '4109.24' , '4109.24' , NOW() , NOW() ) 03/01/2023 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 = '78160' 03/01/2023 06:12:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '78160' 03/01/2023 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 ( '78160' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '33+18' , '21.98' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20472' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20472' , '7' , '1' ) 03/01/2023 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 ( '78160' , '5592' , 'LECTIO DIVINA OGNI GIORNO - 2' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '30+18' , '7.75' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5592' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5592' , '7' , '1' ) 03/01/2023 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 ( '78160' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30+18' , '5.74' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '7' , '1' ) 03/01/2023 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 ( '78160' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '30+18' , '5.17' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '7' , '1' ) 03/01/2023 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 ( '78160' , '1763' , 'CASTELLO INTERIORE - TERESA DAVILA' , '1' , '0' , '4' , '8.5000' , '8.5' , '0' , '33+18' , '4.67' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1763' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1763' , '7' , '1' ) 03/01/2023 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 ( '78160' , '20057' , 'CINQUE PANI DORZO 2023' , '5' , '0' , '4' , '6.9000' , '6.9' , '0' , '30+18' , '19.80' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '7' , '1' ) 03/01/2023 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 ( '78160' , '19638' , 'STORIA DI CARLO ACUTIS' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '30+18' , '2.18' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '7' , '1' ) 03/01/2023 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 ( '78160' , '20543' , 'dominus iesus' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '33+18' , '2.75' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20543' AND id_supplier = '7' 03/01/2023 06:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20543' , '7' , '1' ) 03/01/2023 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 ( '78160' , '7275' , 'ORDO VIRGINUM' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '33+18' , '2.75' ) 03/01/2023 06:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7275' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7275' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '18776' , 'GESU A COLORI' , '2' , '0' , '4' , '8.9000' , '8.9' , '0' , '30+18' , '10.22' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18776' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18776' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '20544' , 'padre nostro - spagnolo' , '4' , '0' , '4' , '6.5000' , '6.5' , '0' , '33+18' , '14.28' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20544' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20544' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '1090' , 'BIBBIA' , '100' , '0' , '4' , '9.9000' , '9.9' , '0' , '33+18' , '543.91' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '5' , '0' , '4' , '12.9000' , '12.9' , '0' , '33+18' , '35.44' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '1128' , 'BIBBIA DELLA CRESIMA - RIL' , '2' , '0' , '4' , '12.9000' , '12.9' , '0' , '33+18' , '14.17' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1128' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1128' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '5' , '0' , '4' , '39.0000' , '39' , '0' , '33+18' , '107.13' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '17734' , 'VANGELO E ATTI BAMBINI' , '500' , '0' , '4' , '3.0000' , '3' , '0' , '33+18' , '824.10' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17734' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17734' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '3289' , 'DAI FRAMMENTI ALLA STORIA - GALVAGNO/GIUNTOLI' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35+18' , '11.73' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3289' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3289' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '20545' , 'TUTTO CIO CHE GESU FECE - GRAFHE 6' , '1' , '0' , '4' , '24.0000' , '24' , '0' , '35+18' , '12.79' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20545' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20545' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '5587' , 'LECTIO DIVINA OGNI GIORNO - 13' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30+18' , '10.33' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5587' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5587' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '5598' , 'LECTIO DIVINA OGNI GIORNO - 8' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30+18' , '11.48' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5598' AND id_supplier = '7' 03/01/2023 06:12:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5598' , '7' , '1' ) 03/01/2023 06:12:06 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 ( '78160' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33+18' , '7.69' ) 03/01/2023 06:12:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '18051' , 'MIA BIBBIA' , '10' , '0' , '4' , '3.5000' , '3.5' , '0' , '30+18' , '20.09' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18051' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18051' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '15722' , 'BIBBIA DEI PICCOLI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35+18' , '6.40' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15722' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15722' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '14259' , 'ARCA DI NOE - GIOCO' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '30+18' , '8.55' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14259' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14259' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35+18' , '11.73' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17511' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17511' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '5832' , 'LIBRO DEI SANTI' , '2' , '0' , '4' , '12.9000' , '12.9' , '0' , '30+18' , '14.81' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5832' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5832' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '17554' , 'GRANDI SANTI AMICI DI GESU' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30+18' , '6.89' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17554' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17554' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '17553' , 'GRANDI SANTE AMICHE DI GESU' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30+18' , '6.89' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17553' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17553' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '10430' , 'TABOR' , '1' , '0' , '4' , '17.9000' , '17.9' , '0' , '30+18.' , '10.27' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '3216' , 'CUORE - E. DE AMICIS' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '35+18' , '5.28' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3216' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3216' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '50' , '0' , '4' , '1.5000' , '1.5' , '0' , '33+18' , '41.21' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '12895' , 'PASSI VERSO LA CRESIMA' , '5' , '0' , '4' , '7.9000' , '7.9' , '0' , '35+18' , '21.05' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '7' 03/01/2023 06:12:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '7' , '1' ) 03/01/2023 06:12:07 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 ( '78160' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33+18' , '8.79' ) 03/01/2023 06:12:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33+18' , '8.79' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '100' , '0' , '4' , '3.0000' , '3' , '0' , '35+18' , '159.90' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18565' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18565' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '7' , '1' ) 03/01/2023 06:12:08 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 ( '78160' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 03/01/2023 06:12:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '7' 03/01/2023 06:12:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '6620' , 'MIA IMPRONTA È TUA - GUIDA 1' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '15.99' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6620' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6620' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '50' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '133.25' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '50' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '133.25' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '14529' , 'PANE E VINO - SUSSIDIO' , '40' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '106.60' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '40' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '106.60' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15926' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15926' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '25' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '66.63' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17229' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17229' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '25' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '66.63' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18564' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18564' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '20261' , 'GIOIA - PAPA FRANCESCO' , '2' , '0' , '4' , '14.0000' , '14' , '0' , '35+18' , '14.92' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20261' AND id_supplier = '7' 03/01/2023 06:12:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20261' , '7' , '1' ) 03/01/2023 06:12: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 ( '78160' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33+18' , '5.49' ) 03/01/2023 06:12:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17852' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17852' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33+18' , '8.79' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30+18' , '5.74' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '10751' , 'TU MI PERDONI' , '20' , '0' , '4' , '5.9000' , '5.9' , '0' , '30+18' , '67.73' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '14719' , 'TU MI AMI DAVVERO' , '20' , '0' , '4' , '5.9000' , '5.9' , '0' , '30+18' , '67.73' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '1116' , 'BIBBIA DEI BAMBINI' , '2' , '0' , '4' , '12.9000' , '12.9' , '0' , '30+18' , '14.81' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1116' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1116' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '19953' , 'FELIZ CITTA - GIOCO CARLO ACUTIS' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30+18' , '8.61' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19953' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19953' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '0' , '4' , '39.0000' , '39' , '0' , '33+18' , '21.43' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1671' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1671' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33+18' , '8.79' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '18298' , 'SAN GIUSEPPE - F. ROSINI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33+18' , '7.69' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18298' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18298' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30+18' , '9.18' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19512' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19512' , '7' , '1' ) 03/01/2023 06:12:10 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 ( '78160' , '7647' , 'PAROLE DI GESÙ MISERICORDIOSO - SUOR FAUSTINA' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '30+18' , '4.02' ) 03/01/2023 06:12:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7647' AND id_supplier = '7' 03/01/2023 06:12:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7647' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33+18' , '8.24' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '16686' , 'EVANGELIARIO' , '1' , '0' , '4' , '140.0000' , '140' , '0' , '30+18' , '80.36' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '19291' , 'VANGELO DELLA PRIMA COMUNIONE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35+18' , '6.40' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19291' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19291' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '4168' , 'FIGLI DEL VENTO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '35+18' , '2.67' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4168' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4168' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '30+18' , '2.81' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '30+18' , '2.81' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17242' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17242' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '30+18' , '2.81' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '19294' , 'SCOPRIAMO INSIEME IL VANGELO' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '30+18' , '2.81' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19294' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19294' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '17767' , 'SCOPRIAMO INSIEME LA QUARESIMA E PASQUA' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '30+18' , '8.44' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17767' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17767' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '3666' , 'DONI DELLO SPIRITO SANTO SPIEGATI AI RAGAZZI - V. BOCCI' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '35+18' , '5.22' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3666' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3666' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '997' , 'BEATITUDINI SPIEGATE AI RAGAZZI - V. BOCCI' , '5' , '0' , '4' , '4.9000' , '4.9' , '0' , '35+18' , '13.06' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '997' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '997' , '7' , '1' ) 03/01/2023 06:12:11 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 ( '78160' , '5592' , 'LECTIO DIVINA OGNI GIORNO - 2' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '30+18' , '7.75' ) 03/01/2023 06:12:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5592' AND id_supplier = '7' 03/01/2023 06:12:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5592' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33+18' , '10.99' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20472' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20472' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '33+18' , '3.30' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '3' , '0' , '4' , '16.0000' , '16' , '0' , '33+18' , '26.37' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '20530' , 'ULTIME PAROLE - TERESA DI GESU BAMBINO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33+18' , '10.99' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20530' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20530' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '1410' , 'BUONA NOTIZIA PER TE! - ANNO B - A. COMASTRI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '8.00' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1410' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1410' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '3878' , 'ENTRARE NELLA DOMENICA DALLA PORTA - ANNO A - R. PAGANELLI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35+18' , '8.00' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3878' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3878' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '10202' , 'STARE NELLA DOMENICA ALLA MENSA ... - R. PAGANELLI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35+18' , '8.53' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10202' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10202' , '7' , '1' ) 03/01/2023 06:12:12 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 ( '78160' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '145.63' , '145.63' , '0' , '0' , '145.6300' ) 03/01/2023 06:12:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 03/01/2023 06:12:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '32' , '22V606318' , '2022-12-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '13.25' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '459.56' , '459.56' , NOW() , NOW() ) 03/01/2023 06:15:30 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 = '78161' 03/01/2023 06:15:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '78161' 03/01/2023 06:15:30 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 ( '78161' , '20496' , 'KYRIE BAMBINO' , '5' , '0' , '4' , '2.7000' , '2.7' , '0' , '30' , '9.45' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20496' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20496' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '0' , '4' , '39.0000' , '39' , '0' , '33' , '26.13' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '33' , '2.01' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '4265' , 'FRANCESCA ROMANA -' , '1' , '0' , '4' , '11.0000' , '11' , '0' , '33' , '7.37' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4265' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4265' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '17286' , 'VIVERE DA ORIGINALI - C. GALATOLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17286' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17286' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '16034' , 'CON TE AMICI' , '19' , '0' , '4' , '5.5000' , '5.5' , '0' , '30+7' , '68.03' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16034' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16034' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '16034' , 'CON TE AMICI' , '1' , '0' , '4' , '5.5000' , '5.5' , '0' , '100' , '0.00' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16034' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16034' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '20531' , 'MADRE DI DIO - AAVV' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20531' AND id_supplier = '7' 03/01/2023 06:15:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20531' , '7' , '1' ) 03/01/2023 06:15:30 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 ( '78161' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '5' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '9.72' ) 03/01/2023 06:15:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20534' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20534' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20532' , 'HO VISTO E UDITO - ILDEGARDA DI BINGEN' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '33' , '21.44' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20532' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20532' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20530' , 'ULTIME PAROLE - TERASA DI GESU BAMBINO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33' , '13.40' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20530' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20530' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20533' , 'TORNIAMO ALLE SORGENTI - D. BATTAGLIA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20533' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20533' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20528' , 'AMEN - MAR 2023' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20528' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20528' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20528' , 'AMEN - MAR 2023' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20528' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20528' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20527' , 'AMEN - APR 2023' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20527' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20527' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20527' , 'AMEN - APR 2023' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20527' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20527' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20529' , 'EDITH STEIN - V.R. BENDAUD' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20529' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20529' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '17177' , 'AGGIUNTA 2020' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17177' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17177' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20541' , 'BIBBIA UNA STORIA... - B. BARBERIS' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20541' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20541' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20542' , 'NEL PROPRIO CUORE - A. CANOPI' , '2' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '19.60' ) 03/01/2023 06:15:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20542' AND id_supplier = '7' 03/01/2023 06:15:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20542' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '14103' , 'PROFUMO DELLO SPOSO - G. PICCOLO' , '1' , '0' , '4' , '11.0000' , '11' , '0' , '33' , '7.37' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14103' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14103' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20583' , 'PAROLA E PREGHIERA - MAR. 23' , '3' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '5.83' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20583' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20583' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20584' , 'INSIEME NELLA MESSA - MAR. 23' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20584' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20584' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '12' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '50.40' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20585' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20585' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '100' , '0.00' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20585' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20585' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '12' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '23.32' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20534' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20534' , '7' , '1' ) 03/01/2023 06:15: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 ( '78161' , '20534' , 'DOMENICA DELLA PAROLA 2023' , '1' , '0' , '4' , '2.9000' , '2.9' , '0' , '100' , '0.00' ) 03/01/2023 06:15:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20534' AND id_supplier = '7' 03/01/2023 06:15:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20534' , '7' , '1' ) 03/01/2023 06:16:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '78146' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 06:16:30 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2023-01-03', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALE CURTERI', 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 = '101.00', price_tax_excluded = '83.15', date_upd = NOW() WHERE id_document = '78146' 03/01/2023 06:16:30 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 = '78146' 03/01/2023 06:16:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '78146' 03/01/2023 06:16:30 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 ( '78146' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '' , '99.00' ) 03/01/2023 06:16:30 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 ( '78146' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 03/01/2023 06:34:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 06:34:32 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' , '29' , '2023-01-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 03/01/2023 06:34:32 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 = '78162' 03/01/2023 06:34:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '78162' 03/01/2023 06:34: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 ( '78162' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 03/01/2023 06:58:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '78150' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-03') 03/01/2023 06:58:24 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '1', document_date = '2023-01-03', document_letter = '', id_customer = '3997', id_supplier = '', id_address = '4678088', address1 = 'VIA RINASCITA 83055 STURNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '136.85', price_tax_excluded = '136.85', date_upd = NOW() WHERE id_document = '78150' 03/01/2023 06:58:24 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 = '78150' 03/01/2023 06:58:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '78150' 03/01/2023 06:58:24 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 ( '78150' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '15' , '51.00' ) 03/01/2023 06:58:24 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 ( '78150' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 03/01/2023 06:58:24 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 ( '78150' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 03/01/2023 06:58:24 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 ( '78150' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 03/01/2023 06:58:24 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 ( '78150' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 03/01/2023 06:58:24 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 ( '78150' , '9675' , 'SARETE MIEI TESTIMONI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 03/01/2023 06:58:24 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 ( '78150' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 06:58:24 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 ( '78150' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 06:58:24 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 ( '78150' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 06:58:24 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 ( '78150' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '15' , '4.25' ) 03/01/2023 08:03:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 03/01/2023 08:03:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2022-12-23', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '77503' 03/01/2023 08:03: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 = '77503' 03/01/2023 08:03:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 03/01/2023 08:03: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 ( '77503' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' , '-1' , '1' , '800.0000' , '655.73770491803' , '22' , '0' , '800.00' )