02/12/2023 08:28:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '87348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 02/12/2023 08:28:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2864', document_date = '2023-09-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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87348' 02/12/2023 08:28:49 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 = '87348' 02/12/2023 08:28:49 am >> DELETE FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:28:49 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 ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 02/12/2023 08:28:49 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 ( '87348' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 02/12/2023 08:28:49 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 ( '87348' , '0' , 'palla mariana 50/372' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 02/12/2023 08:28:49 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 ( '87348' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 02/12/2023 08:28:49 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 ( '87348' , '8166' , 'PORTACALICE - 18X35 - 726' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 02/12/2023 08:28:49 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 ( '87348' , '21642' , 'PISSIDE - 099PA' , '1' , '-1' , '1' , '1600' , '1311.4754098361' , '22' , '0' , '1600.00' ) 02/12/2023 08:31:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3241' AND id_document != '88405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-19') 02/12/2023 08:31:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3241', document_date = '2023-10-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 = '90.00', price_tax_excluded = '78.92', date_upd = NOW() WHERE id_document = '88405' 02/12/2023 08:31:22 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 = '88405' 02/12/2023 08:31:22 am >> DELETE FROM ps_document_detail WHERE id_document = '88405' 02/12/2023 08:31:22 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 ( '88405' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2023 08:31:22 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 ( '88405' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 02/12/2023 08:31:22 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 ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 02/12/2023 08:31:22 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 ( '88405' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '5' , '23.80' ) 02/12/2023 08:31:22 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 ( '88405' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 02/12/2023 08:31:22 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 ( '88405' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '3.50' ) 02/12/2023 08:31:22 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 ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.25' ) 02/12/2023 08:31:22 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 ( '88405' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2023 08:32:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '87532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 02/12/2023 08:32:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2996', document_date = '2023-10-03', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '87532' 02/12/2023 08:32:02 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 = '87532' 02/12/2023 08:32:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87532' 02/12/2023 08:32:02 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 ( '87532' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 02/12/2023 08:32:02 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 ( '87532' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 02/12/2023 08:32:02 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 ( '87532' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 02/12/2023 08:32:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '87348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 02/12/2023 08:32:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2864', document_date = '2023-09-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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87348' 02/12/2023 08:32:37 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 = '87348' 02/12/2023 08:32:37 am >> DELETE FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:32:37 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 ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 02/12/2023 08:32:37 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 ( '87348' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 02/12/2023 08:32:37 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 ( '87348' , '0' , 'palla mariana 50/372' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 02/12/2023 08:32:37 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 ( '87348' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 02/12/2023 08:32:37 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2023 08:32:37 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 ( '87348' , '21642' , 'PISSIDE - 099PA' , '1' , '-1' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 02/12/2023 08:35:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2580' AND id_document != '86999' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 02/12/2023 08:35:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2580', document_date = '2023-08-07', 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 = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '86999' 02/12/2023 08:35:02 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 = '86999' 02/12/2023 08:35:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86999' 02/12/2023 08:35:02 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 ( '86999' , '21039' , 'PALLA IN SETA RICAMO MARIANO - 50/372' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 02/12/2023 08:35:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '87348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 02/12/2023 08:35:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2864', document_date = '2023-09-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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87348' 02/12/2023 08:35:45 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 = '87348' 02/12/2023 08:35:45 am >> DELETE FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:35:45 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 ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 02/12/2023 08:35:45 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 ( '87348' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 02/12/2023 08:35:45 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 02/12/2023 08:35:45 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 ( '87348' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 02/12/2023 08:35:45 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2023 08:35:45 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 ( '87348' , '21642' , 'PISSIDE - 099PA' , '1' , '-1' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 02/12/2023 08:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2049' AND id_document != '85827' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 02/12/2023 08:37:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2049', document_date = '2023-06-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '122.95', date_upd = NOW() WHERE id_document = '85827' 02/12/2023 08:37:19 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 = '85827' 02/12/2023 08:37:19 am >> DELETE FROM ps_document_detail WHERE id_document = '85827' 02/12/2023 08:37:19 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 ( '85827' , '21150' , 'QUADRO 15X15' , '1' , '-1' , '1' , '19.5000' , '15.983606557377' , '22' , '0' , '19.50' ) 02/12/2023 08:37:19 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 ( '85827' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '-1' , '1' , '130.5' , '106.96721311475' , '22' , '0' , '130.50' ) 02/12/2023 08:37:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '87348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 02/12/2023 08:37:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2864', document_date = '2023-09-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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87348' 02/12/2023 08:37:42 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 = '87348' 02/12/2023 08:37:42 am >> DELETE FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:37:42 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 ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 02/12/2023 08:37:42 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 02/12/2023 08:37:42 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 02/12/2023 08:37:42 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 ( '87348' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '-1' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 02/12/2023 08:37:42 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2023 08:37:42 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 ( '87348' , '21642' , 'PISSIDE - 099PA' , '1' , '-1' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 02/12/2023 08:39:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2864' AND id_document != '87348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 02/12/2023 08:39:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2864', document_date = '2023-09-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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87348' 02/12/2023 08:39:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:39:32 am >> DELETE FROM ps_document_detail WHERE id_document = '87348' 02/12/2023 08:39:32 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 ( '87348' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '-1' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 02/12/2023 08:39:32 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 02/12/2023 08:39:32 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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 02/12/2023 08:39: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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '305' , '250' , '22' , '0' , '305.00' ) 02/12/2023 08:39: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 ( '87348' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/12/2023 08:39: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 ( '87348' , '21642' , 'PISSIDE - 099PA' , '1' , '-1' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 02/12/2023 09:19:11 am >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '3912' 02/12/2023 09:20:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '371' 02/12/2023 09:20:45 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 ( '371' , '10' , '210' , 'PARROCCHIA S. MARIA DELLE GRAZIE' , 'CIPOLLETTA ' , 'DON GIANLUCA' , 'P.ZZA S. ROCCO' , '' , '84088' , 'SIANO' , '' , '3890975580' , '' , '' , '8004311043651' , NOW() , NOW() ) 02/12/2023 09:20:45 am >> UPDATE ps_customer SET email = 'giacipolletta@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '371' 02/12/2023 09:20:59 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '371' 02/12/2023 09:20: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 ( '371' , '10' , '210' , 'PARROCCHIA S. MARIA DELLE GRAZIE' , 'CIPOLLETTA ' , 'DON GIANLUCA' , 'P.ZZA S. ROCCO' , '' , '84088' , 'SIANO' , '' , '3890975580' , '' , '' , '8004311043651' , NOW() , NOW() ) 02/12/2023 09:20:59 am >> UPDATE ps_customer SET email = 'giacipolletta@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '371' 02/12/2023 09:34:01 am >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 09:34:01 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' , '112' , '2023-12-02' , '' , '371' , '0' , '163357314' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.60' , '81.60' , NOW() , NOW() ) 02/12/2023 09:34:01 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 = '13759' 02/12/2023 09:34:01 am >> DELETE FROM ps_document_detail WHERE id_document = '13759' 02/12/2023 09:34:01 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 ( '13759' , '17' , 'LA FEDE NELLO ZAINETTO' , '16' , '-16' , '4' , '6.00' , '6' , '0' , '15' , '81.60' ) 02/12/2023 09:34:46 am >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '13759' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 09:34:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '112', document_date = '2023-12-02', document_letter = '', id_customer = '371', id_supplier = '', id_address = '163357314', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '81.60', price_tax_excluded = '81.60', date_upd = NOW() WHERE id_document = '13759' 02/12/2023 09:34:46 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 = '13759' 02/12/2023 09:34:46 am >> DELETE FROM ps_document_detail WHERE id_document = '13759' 02/12/2023 09:34:46 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 ( '13759' , '17' , 'LA FEDE NELLO ZAINETTO' , '16' , '-16' , '4' , '6.0000' , '6' , '0' , '15' , '81.60' ) 02/12/2023 09:35:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 09:35:19 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' , '3832' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 02/12/2023 09:35:19 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 = '89280' 02/12/2023 09:35:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89280' 02/12/2023 09:35:19 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 ( '89280' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 02/12/2023 09:41:33 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ln8vZYMIBeWzKbYY' , NOW() , NOW() ) 02/12/2023 09:41:33 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4062' , '1' ) 02/12/2023 09:41:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4062' , '2' ) 02/12/2023 09:41:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4062' , '3' ) 02/12/2023 09:43:06 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1237' 02/12/2023 09:43:06 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 ( '1237' , '10' , '202' , 'PARROCCHIA MADONNA ASSUNTA' , 'GIUNTA ' , 'P. GIUSEPPE' , 'VIA MILANO 11' , '' , '97019' , 'VITTORIA' , '' , '' , '' , '' , '91000960889' , NOW() , NOW() ) 02/12/2023 09:43:06 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1237' 02/12/2023 09:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '81226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-04') 02/12/2023 09:56:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2023-02-04', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '156.20', price_tax_excluded = '128.03', date_upd = NOW() WHERE id_document = '81226' 02/12/2023 09:56: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 = '81226' 02/12/2023 09:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '81226' 02/12/2023 09:56: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 ( '81226' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 02/12/2023 09:56: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 ( '81226' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 02/12/2023 09:56:41 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 ( '81226' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '62.9000' , '51.55737704918' , '22' , '0' , '62.90' ) 02/12/2023 09:56:41 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 ( '81226' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 02/12/2023 09:56:41 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 ( '81226' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 02/12/2023 10:06:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:06:05 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' , '3833' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.60' , '2.13' , NOW() , NOW() ) 02/12/2023 10:06:05 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 = '89281' 02/12/2023 10:06:05 am >> DELETE FROM ps_document_detail WHERE id_document = '89281' 02/12/2023 10:06:05 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 ( '89281' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '5' , '-5' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '2.00' ) 02/12/2023 10:06:05 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 ( '89281' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '2' , '-2' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.60' ) 02/12/2023 10:14:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:14:06 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' , '3834' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '26.00' , NOW() , NOW() ) 02/12/2023 10:14:06 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 = '89282' 02/12/2023 10:14:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89282' 02/12/2023 10:14:06 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 ( '89282' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '6.5' , '6.5' , '0' , '0' , '26.00' ) 02/12/2023 10:28:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:28:03 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' , '3835' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 02/12/2023 10:28:03 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 = '89283' 02/12/2023 10:28:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89283' 02/12/2023 10:28:03 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 ( '89283' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 02/12/2023 10:37:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:37:01 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' , '3836' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 02/12/2023 10:37:01 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 = '89284' 02/12/2023 10:37:01 am >> DELETE FROM ps_document_detail WHERE id_document = '89284' 02/12/2023 10:37:01 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 ( '89284' , '21196' , 'CALENDARIO LITURGICO 2024' , '10' , '-10' , '4' , '0.50' , '0.5' , '0' , '0' , '5.00' ) 02/12/2023 10:45:09 am >> SELECT document_num FROM ps_document WHERE document_num = '128/A' AND id_document != '88977' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 02/12/2023 10:45:10 am >> UPDATE ps_document SET id_document_type = '24', document_num = '128/A', document_date = '2023-11-15', document_letter = 'A', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', 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 = '88.00', price_tax_excluded = '84.39', date_upd = NOW() WHERE id_document = '88977' 02/12/2023 10:45:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88977' 02/12/2023 10:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '88977' 02/12/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88977' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '0' , '3.5000' , '3.5' , '0' , '0' , '14.00' ) 02/12/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88977' , '21838' , 'CARTOLINA CARLO ACUTIS' , '30' , '-30' , '0' , '0.1500' , '0.15' , '0' , '0' , '4.50' ) 02/12/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88977' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '11' , '-11' , '0' , '4.5000' , '4.5' , '0' , '0' , '49.50' ) 02/12/2023 10:45:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88977' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '10' , '-10' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '20.00' ) 02/12/2023 10:45:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3837' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:45:34 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' , '3837' , '2023-12-02' , '' , '0' , '0' , '0' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.00' , '84.39' , NOW() , NOW() ) 02/12/2023 10:45:34 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 = '89285' 02/12/2023 10:45:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89285' 02/12/2023 10:45:34 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 ( '89285' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '0' , '3.5000' , '3.5' , '0' , '0' , '14.00' ) 02/12/2023 10:45:34 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 ( '89285' , '21838' , 'CARTOLINA CARLO ACUTIS' , '30' , '-30' , '0' , '0.1500' , '0.15' , '0' , '0' , '4.50' ) 02/12/2023 10:45:34 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 ( '89285' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '11' , '-11' , '0' , '4.5000' , '4.5' , '0' , '0' , '49.50' ) 02/12/2023 10:45:34 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 ( '89285' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '10' , '-10' , '1' , '2.0000' , '1.6393' , '22' , '0' , '20.00' ) 02/12/2023 10:45:52 am >> DELETE FROM ps_document WHERE id_document = '88977' 02/12/2023 10:45:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88977' 02/12/2023 10:54:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 10:54:52 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' , '3838' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '174.93' , NOW() , NOW() ) 02/12/2023 10:54:52 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 = '89286' 02/12/2023 10:54:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89286' 02/12/2023 10:54:52 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 ( '89286' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 02/12/2023 10:54:52 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 ( '89286' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 02/12/2023 10:54:52 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 ( '89286' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2023 10:54:52 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 ( '89286' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 02/12/2023 10:54:52 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 ( '89286' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 02/12/2023 10:54:52 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 ( '89286' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '61' , '61' , '0' , '0' , '61.00' ) 02/12/2023 11:12:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:12:06 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' , '3839' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '188.52' , NOW() , NOW() ) 02/12/2023 11:12:06 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 = '89287' 02/12/2023 11:12:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89287' 02/12/2023 11:12:06 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 ( '89287' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 02/12/2023 11:12:06 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 ( '89287' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/12/2023 11:12:06 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 ( '89287' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 02/12/2023 11:12:06 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 ( '89287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 02/12/2023 11:12:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:12:59 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' , '3840' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 02/12/2023 11:12:59 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 = '89288' 02/12/2023 11:12:59 am >> DELETE FROM ps_document_detail WHERE id_document = '89288' 02/12/2023 11:12:59 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 ( '89288' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 02/12/2023 11:23:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:23:21 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' , '3841' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '39.59' , NOW() , NOW() ) 02/12/2023 11:23:21 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 = '89289' 02/12/2023 11:23:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89289' 02/12/2023 11:23:21 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 ( '89289' , '18883' , 'BAMBINELLO CM 26 - PB13992' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 02/12/2023 11:23:21 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 ( '89289' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 02/12/2023 11:23:21 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 ( '89289' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 02/12/2023 11:37:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:37:45 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' , '3842' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 02/12/2023 11:37:45 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 = '89290' 02/12/2023 11:37:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89290' 02/12/2023 11:37:45 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 ( '89290' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 02/12/2023 11:41:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:41:06 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' , '3843' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 02/12/2023 11:41:06 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 = '89291' 02/12/2023 11:41:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89291' 02/12/2023 11:41:06 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 ( '89291' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 02/12/2023 11:47:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:47: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' , '3844' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.30' , '23.13' , NOW() , NOW() ) 02/12/2023 11:47: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 = '89292' 02/12/2023 11:47:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89292' 02/12/2023 11:47: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 ( '89292' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 02/12/2023 11:47: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 ( '89292' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 02/12/2023 11:49:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:49:40 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' , '3845' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 02/12/2023 11:49: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 = '89293' 02/12/2023 11:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89293' 02/12/2023 11:49: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 ( '89293' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 02/12/2023 11:51:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:51:09 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' , '3846' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 02/12/2023 11:51:09 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 = '89294' 02/12/2023 11:51:09 am >> DELETE FROM ps_document_detail WHERE id_document = '89294' 02/12/2023 11:51:09 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 ( '89294' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 02/12/2023 11:57:38 am >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:57:38 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' , '305' , '2023-12-02' , '' , '321' , '0' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '380.72' , '380.72' , NOW() , NOW() ) 02/12/2023 11:57:38 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 = '89295' 02/12/2023 11:57:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89295' 02/12/2023 11:57:38 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 ( '89295' , '2679' , 'CONOSCERE GESU\'' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 02/12/2023 11:57:38 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 ( '89295' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '24' , '-24' , '4' , '3.4000' , '3.4' , '0' , '15' , '69.36' ) 02/12/2023 11:57:38 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 ( '89295' , '4154' , 'FESTA DEL PERDONO' , '18' , '-18' , '4' , '3.0000' , '3' , '0' , '15' , '45.90' ) 02/12/2023 11:57:38 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 ( '89295' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 02/12/2023 11:57:38 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 ( '89295' , '10748' , 'TU MI CHIAMI PER NOME' , '25' , '-25' , '4' , '6.9000' , '6.9' , '0' , '5' , '163.88' ) 02/12/2023 11:58:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 11:58:47 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' , '3847' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 02/12/2023 11:58:47 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 = '89296' 02/12/2023 11:58:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89296' 02/12/2023 11:58:47 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 ( '89296' , '21569' , 'DOMENICHE DA COLORARE - ANNO B ' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 02/12/2023 12:06:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 12:06:39 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' , '3848' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.81' , '94.81' , NOW() , NOW() ) 02/12/2023 12:06:39 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 = '89297' 02/12/2023 12:06:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89297' 02/12/2023 12:06:39 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 ( '89297' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 02/12/2023 12:06:39 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 ( '89297' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 02/12/2023 12:06:39 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 ( '89297' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '3' , '-3' , '4' , '12.00' , '12' , '0' , '0' , '36.00' ) 02/12/2023 12:06:39 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 ( '89297' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 02/12/2023 12:06:39 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 ( '89297' , '14289' , 'PAROLE DELLA LITURGIA - E. VIVIANO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/12/2023 12:06:39 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 ( '89297' , '6117' , 'MAESTRO INSEGNACI A PREGARE - A. GASPARINO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 02/12/2023 12:10:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 12:10:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3849' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.90' , '20.93' , NOW() , NOW() ) 02/12/2023 12:10:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89298' 02/12/2023 12:10:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89298' 02/12/2023 12:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89298' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2023 12:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89298' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/12/2023 12:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89298' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 02/12/2023 12:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89298' , '21679' , 'LAUDATE DEUM - 8583' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/12/2023 12:13:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '113' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 12:13:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '113' , '2023-12-02' , '' , '3488' , '0' , '4670195' , 'P. ZZA S. LUCIA 1 08029 SINISCOLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '37.10' , '37.10' , NOW() , NOW() ) 02/12/2023 12:13:18 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 = '13760' 02/12/2023 12:13:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '13760' 02/12/2023 12:13:18 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 ( '13760' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 02/12/2023 12:13:18 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 ( '13760' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 02/12/2023 12:27:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 02/12/2023 12:27:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3850' , '2023-12-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.41' , '41.41' , NOW() , NOW() ) 02/12/2023 12:27:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89299' 02/12/2023 12:27:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89299' 02/12/2023 12:27: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 ( '89299' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '32' , '32' , '0' , '0' , '32.00' ) 02/12/2023 12:27: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 ( '89299' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 02/12/2023 12:56:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '293' AND id_document != '89163' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-27') 02/12/2023 12:56:12 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '293', document_date = '2023-11-27', document_letter = '', id_customer = '3821', id_supplier = '', id_address = '4672560', address1 = 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '88.24', price_tax_excluded = '88.24', date_upd = NOW() WHERE id_document = '89163' 02/12/2023 12:56:12 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 = '89163' 02/12/2023 12:56:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89163' 02/12/2023 12:56: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 ( '89163' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 02/12/2023 12:56: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 ( '89163' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '-15' , '4' , '3.4000' , '3.4' , '0' , '15' , '43.35' ) 02/12/2023 12:56: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 ( '89163' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '10' , '6.21' )