25/03/2024 08:35:51 am >> SELECT document_num FROM ps_document WHERE document_num = '870' AND id_document != '90912' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-23') 25/03/2024 08:35:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '870', document_date = '2024-03-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 = '51.50', price_tax_excluded = '42.21', date_upd = NOW() WHERE id_document = '90912' 25/03/2024 08:35:51 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 = '90912' 25/03/2024 08:35:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90912' 25/03/2024 08:35:51 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 ( '90912' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.5' , '13.524590163934' , '22' , '0' , '16.50' ) 25/03/2024 08:35:51 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 ( '90912' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 25/03/2024 08:49:08 am >> UPDATE ps_address SET id_state = '182', lastname = 'MARIO BALDRIGHI srl -', address1 = 'VIA G. B. STUCCHI 62/27', address2 = '', postcode = '20900', dni = '', vat_number = '02347600963', city = 'MONZA', phone = '039834020', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '187' 25/03/2024 08:49:08 am >> UPDATE ps_supplier SET email = 'segreteria@baldrighi.it', name = 'MARIO BALDRIGHI srl -', date_upd = NOW() WHERE id_supplier = '187' 25/03/2024 08:49:08 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '187' 25/03/2024 08:49:53 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 ( '34' , 'NC/103' , '2024-03-21' , '103' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.78' , '49.00' , NOW() , NOW() ) 25/03/2024 08:49:53 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 = '90925' 25/03/2024 08:49:53 am >> DELETE FROM ps_document_detail WHERE id_document = '90925' 25/03/2024 08:49:53 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 ( '90925' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '0' , '1' , '49' , '40.16393442623' , '22' , '0' , '59.7800' ) 25/03/2024 08:49:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '22317' AND id_supplier = '187' 25/03/2024 08:49:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22317' , '187' , '1' ) 25/03/2024 08:51:31 am >> UPDATE ps_document SET id_document_type = '34', document_num = 'NC/103', document_date = '2024-03-21', document_letter = '103', id_customer = '0', id_supplier = '', id_address = '4679290', address1 = 'VIA G. B. STUCCHI 62/27 20900 MONZA', 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 = '59.78', price_tax_excluded = '49.00', date_upd = NOW() WHERE id_document = '90925' 25/03/2024 08:51: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 = '90925' 25/03/2024 08:51:31 am >> DELETE FROM ps_document_detail WHERE id_document = '90925' 25/03/2024 08:51: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 ( '90925' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '59.78' ) 25/03/2024 08:52:00 am >> DELETE FROM ps_document WHERE id_document = '90887' 25/03/2024 08:52:00 am >> DELETE FROM ps_document_detail WHERE id_document = '90887' 25/03/2024 08:58:01 am >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '90183' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-01') 25/03/2024 08:58:01 am >> UPDATE ps_document SET id_document_type = '21', document_num = '26', document_date = '2024-02-01', document_letter = '', id_customer = '3859', id_supplier = '', id_address = '4679261', address1 = 'VIA G.B.VENTURI , 140 42021 BIBBIANO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '38.25', price_tax_excluded = '38.25', date_upd = NOW() WHERE id_document = '90183' 25/03/2024 08:58: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 = '90183' 25/03/2024 08:58:01 am >> DELETE FROM ps_document_detail WHERE id_document = '90183' 25/03/2024 08:58: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 ( '90183' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '2.8500' , '2.85' , '0' , '0' , '2.85' ) 25/03/2024 08:58: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 ( '90183' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '5' , '19.00' ) 25/03/2024 08:58: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 ( '90183' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 25/03/2024 09:00:41 am >> SELECT document_num FROM ps_document WHERE document_num = '478' AND id_document != '90391' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 25/03/2024 09:00:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '478', document_date = '2024-02-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 = '60.00', price_tax_excluded = '53.51', date_upd = NOW() WHERE id_document = '90391' 25/03/2024 09:00:41 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 = '90391' 25/03/2024 09:00:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90391' 25/03/2024 09:00: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 ( '90391' , '14664' , 'DALL\'AURORA IO TI CERCO - A. CENCINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 25/03/2024 09:00: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 ( '90391' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 25/03/2024 09:00: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 ( '90391' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/03/2024 09:00: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 ( '90391' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 25/03/2024 09:00: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 ( '90391' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 25/03/2024 09:00: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 ( '90391' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 25/03/2024 09:00: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 ( '90391' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.3400' , '2.34' , '0' , '0' , '2.34' ) 25/03/2024 09:00:53 am >> SELECT document_num FROM ps_document WHERE document_num = '477' AND id_document != '90390' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-16') 25/03/2024 09:00:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '477', document_date = '2024-02-16', 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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '90390' 25/03/2024 09:00:53 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 = '90390' 25/03/2024 09:00:53 am >> DELETE FROM ps_document_detail WHERE id_document = '90390' 25/03/2024 09:00:53 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 ( '90390' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 25/03/2024 09:01:07 am >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '90083' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-25') 25/03/2024 09:01:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '246', document_date = '2024-01-25', 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 = '41.50', price_tax_excluded = '34.02', date_upd = NOW() WHERE id_document = '90083' 25/03/2024 09:01: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 = '90083' 25/03/2024 09:01:07 am >> DELETE FROM ps_document_detail WHERE id_document = '90083' 25/03/2024 09:01: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 ( '90083' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 25/03/2024 09:01: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 ( '90083' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 25/03/2024 09:01:08 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 ( '90083' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 25/03/2024 09:01:23 am >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '90040' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-19') 25/03/2024 09:01:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '211', document_date = '2024-01-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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '90040' 25/03/2024 09:01:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90040' 25/03/2024 09:01:23 am >> DELETE FROM ps_document_detail WHERE id_document = '90040' 25/03/2024 09:01:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90040' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 25/03/2024 09:01:39 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '89965' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-16') 25/03/2024 09:01:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '159', document_date = '2024-01-16', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '89965' 25/03/2024 09:01:39 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 = '89965' 25/03/2024 09:01:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89965' 25/03/2024 09:01:39 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 ( '89965' , '19787' , 'ROSARIO METALLO MM4 - 48M4' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 25/03/2024 09:01:39 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 ( '89965' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 25/03/2024 09:02:36 am >> SELECT document_num FROM ps_document WHERE document_num = '819' AND id_document != '90845' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 25/03/2024 09:02:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '819', document_date = '2024-03-20', 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 = '200.00', price_tax_excluded = '167.27', date_upd = NOW() WHERE id_document = '90845' 25/03/2024 09:02:36 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 = '90845' 25/03/2024 09:02:36 am >> DELETE FROM ps_document_detail WHERE id_document = '90845' 25/03/2024 09:02:36 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 ( '90845' , '10687' , 'TORCIA A VENTO ' , '6' , '-6' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '17.40' ) 25/03/2024 09:02:36 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 ( '90845' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '2' , '-2' , '1' , '67.7' , '55.491803278689' , '22' , '0' , '135.40' ) 25/03/2024 09:02:36 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 ( '90845' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '23.70' ) 25/03/2024 09:02:36 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 ( '90845' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/03/2024 09:02:36 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 ( '90845' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 25/03/2024 09:03:21 am >> SELECT document_num FROM ps_document WHERE document_num = '869' AND id_document != '90911' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-23') 25/03/2024 09:03:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '869', document_date = '2024-03-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 = '61.50', price_tax_excluded = '50.41', date_upd = NOW() WHERE id_document = '90911' 25/03/2024 09:03: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 = '90911' 25/03/2024 09:03:21 am >> DELETE FROM ps_document_detail WHERE id_document = '90911' 25/03/2024 09:03: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 ( '90911' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '52' , '42.622950819672' , '22' , '0' , '52.00' ) 25/03/2024 09:03: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 ( '90911' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '5.50' ) 25/03/2024 09:03: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 ( '90911' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 25/03/2024 09:04:13 am >> SELECT document_num FROM ps_document WHERE document_num = '798' AND id_document != '90816' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 25/03/2024 09:04:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '798', document_date = '2024-03-18', 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 = '20.40', price_tax_excluded = '16.72', date_upd = NOW() WHERE id_document = '90816' 25/03/2024 09:04:14 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 = '90816' 25/03/2024 09:04:14 am >> DELETE FROM ps_document_detail WHERE id_document = '90816' 25/03/2024 09:04:14 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 ( '90816' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 25/03/2024 09:04:14 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 ( '90816' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '8' , '-8' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '4.00' ) 25/03/2024 09:04:14 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 ( '90816' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 25/03/2024 09:08:13 am >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '90125' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-27') 25/03/2024 09:08:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '281', document_date = '2024-01-27', 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 = '2.90', price_tax_excluded = '2.38', date_upd = NOW() WHERE id_document = '90125' 25/03/2024 09:08: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 = '90125' 25/03/2024 09:08:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90125' 25/03/2024 09:08: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 ( '90125' , '13363' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 25/03/2024 09:15:08 am >> SELECT document_num FROM ps_document WHERE document_num = '792' AND id_document != '90806' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 25/03/2024 09:15:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '792', document_date = '2024-03-18', 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 = '3.80', price_tax_excluded = '3.11', date_upd = NOW() WHERE id_document = '90806' 25/03/2024 09:15:08 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 = '90806' 25/03/2024 09:15:08 am >> DELETE FROM ps_document_detail WHERE id_document = '90806' 25/03/2024 09:15:08 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 ( '90806' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 25/03/2024 09:15:08 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 ( '90806' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 25/03/2024 09:15:37 am >> SELECT document_num FROM ps_document WHERE document_num = '837' AND id_document != '90868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 25/03/2024 09:15:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '837', document_date = '2024-03-20', 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 = '31.00', price_tax_excluded = '26.67', date_upd = NOW() WHERE id_document = '90868' 25/03/2024 09:15: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 = '90868' 25/03/2024 09:15:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90868' 25/03/2024 09:15: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 ( '90868' , '20516' , 'CROCE COMUNIONE - 42/08' , '20' , '-20' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '24.00' ) 25/03/2024 09:15: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 ( '90868' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 25/03/2024 09:16:16 am >> SELECT document_num FROM ps_document WHERE document_num = '571' AND id_document != '90518' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 25/03/2024 09:16:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '571', document_date = '2024-02-26', 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 = '37.40', price_tax_excluded = '35.16', date_upd = NOW() WHERE id_document = '90518' 25/03/2024 09:16:16 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 = '90518' 25/03/2024 09:16:16 am >> DELETE FROM ps_document_detail WHERE id_document = '90518' 25/03/2024 09:16:16 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 ( '90518' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 25/03/2024 09:16:16 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 ( '90518' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '23' , '23' , '0' , '0' , '23.00' ) 25/03/2024 09:16:16 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 ( '90518' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '12.40' ) 25/03/2024 09:16:49 am >> SELECT document_num FROM ps_document WHERE document_num = '513' AND id_document != '90431' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 25/03/2024 09:16:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '513', document_date = '2024-02-20', 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 = '9.60', price_tax_excluded = '7.87', date_upd = NOW() WHERE id_document = '90431' 25/03/2024 09:16: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 = '90431' 25/03/2024 09:16:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90431' 25/03/2024 09:16: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 ( '90431' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9.6' , '7.8688524590164' , '22' , '0' , '9.60' ) 25/03/2024 09:17:27 am >> SELECT document_num FROM ps_document WHERE document_num = '456' AND id_document != '90362' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-15') 25/03/2024 09:17:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '456', document_date = '2024-02-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 = '92.00', price_tax_excluded = '92.00', date_upd = NOW() WHERE id_document = '90362' 25/03/2024 09:17:27 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 = '90362' 25/03/2024 09:17:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90362' 25/03/2024 09:17:27 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 ( '90362' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 25/03/2024 09:17:27 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 ( '90362' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.18' , '4.18' , '0' , '' , '4.18' ) 25/03/2024 09:17:27 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 ( '90362' , '22122' , 'CON TUTTO TE STESSO' , '3' , '-3' , '4' , '2.8000' , '2.8' , '0' , '5' , '7.98' ) 25/03/2024 09:17:27 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 ( '90362' , '20872' , 'CON TE GESU - ' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '5' , '7.14' ) 25/03/2024 09:17:27 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 ( '90362' , '22073' , 'VIA CRUCIS PELLEGRINI DI SPERANZA' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 25/03/2024 09:17:27 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 ( '90362' , '22050' , 'E RISORTO, NON E QUI' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 25/03/2024 09:17:27 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 ( '90362' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 25/03/2024 09:17:27 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 ( '90362' , '1865' , 'CELEBRARE LAVVENTO E IL NATALE... - 2' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 25/03/2024 09:17:27 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 ( '90362' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 25/03/2024 09:17:28 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 ( '90362' , '1876' , 'CELEBRARE LA PRIMA RICONCILIAZIONE E LA PRIMA COM.' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 25/03/2024 09:17:28 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 ( '90362' , '13431' , 'PASSI VERSO LEUCARISTIA' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 25/03/2024 09:17:28 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 ( '90362' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 25/03/2024 09:17:28 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 ( '90362' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 25/03/2024 09:17:28 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 ( '90362' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 25/03/2024 09:17:28 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 ( '90362' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 25/03/2024 09:17:58 am >> SELECT document_num FROM ps_document WHERE document_num = '355' AND id_document != '90223' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 25/03/2024 09:17:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '355', document_date = '2024-02-02', 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 = '90223' 25/03/2024 09:17: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 = '90223' 25/03/2024 09:17:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90223' 25/03/2024 09:17: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 ( '90223' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 25/03/2024 09:17: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 ( '90223' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 25/03/2024 09:18:54 am >> SELECT document_num FROM ps_document WHERE document_num = '235' AND id_document != '90069' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-24') 25/03/2024 09:18:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '235', document_date = '2024-01-24', 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 = '3.30', price_tax_excluded = '2.70', date_upd = NOW() WHERE id_document = '90069' 25/03/2024 09:18: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 = '90069' 25/03/2024 09:18:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90069' 25/03/2024 09:18: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 ( '90069' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '0.80' ) 25/03/2024 09:18: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 ( '90069' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 25/03/2024 09:19:52 am >> SELECT document_num FROM ps_document WHERE document_num = '461' AND id_document != '90371' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-15') 25/03/2024 09:19:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '461', document_date = '2024-02-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 = '71.30', price_tax_excluded = '58.44', date_upd = NOW() WHERE id_document = '90371' 25/03/2024 09:19: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 = '90371' 25/03/2024 09:19:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90371' 25/03/2024 09:19: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 ( '90371' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '8' , '-8' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '3.20' ) 25/03/2024 09:19: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 ( '90371' , '7192' , 'NUPTIAE DECORO CIELO ' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 25/03/2024 09:19: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 ( '90371' , '17841' , 'QUADRO DECORATO 42X32' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 25/03/2024 09:19: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 ( '90371' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 25/03/2024 09:20:27 am >> SELECT document_num FROM ps_document WHERE document_num = '433' AND id_document != '90329' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-14') 25/03/2024 09:20:27 am >> UPDATE ps_document SET id_document_type = '11', document_num = '433', document_date = '2024-02-14', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '90329' 25/03/2024 09:20:27 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 = '90329' 25/03/2024 09:20:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90329' 25/03/2024 09:20:27 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 ( '90329' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 25/03/2024 09:22:04 am >> SELECT document_num FROM ps_document WHERE document_num = '639' AND id_document != '90614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 25/03/2024 09:22:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '639', document_date = '2024-03-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 = '24.50', price_tax_excluded = '23.33', date_upd = NOW() WHERE id_document = '90614' 25/03/2024 09:22:04 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 = '90614' 25/03/2024 09:22:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90614' 25/03/2024 09:22:04 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 ( '90614' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '6.00' ) 25/03/2024 09:22:04 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 ( '90614' , '9714' , 'SCATOLA OTTOGONALE - 7328' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 25/03/2024 09:22:04 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 ( '90614' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 25/03/2024 09:23:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867511600' AND id_product != '21697' AND ean13 != '' 25/03/2024 09:23:05 am >> UPDATE ps_product SET id_supplier = '177', reference = '', ean13 = '9788867511600', date_upd = NOW() WHERE id_product = '21697' 25/03/2024 09:23:05 am >> UPDATE ps_product_lang SET name = 'ORME SUL CUORE - A. ROMANO', description = '' WHERE id_product = '21697' 25/03/2024 09:23:05 am >> UPDATE ps_product SET wholesale_price = '8.54', on_sale = '0', price = '12.0000' WHERE id_product = '21697' 25/03/2024 09:23:05 am >> UPDATE ps_product_shop SET wholesale_price = '8.54', price = '12.0000', id_tax_rules_group = '4', id_category_default = '468', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21697' 25/03/2024 09:23:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21697' 25/03/2024 09:24:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3936' AND id_document != '89424' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-11') 25/03/2024 09:24:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3936', document_date = '2023-12-11', 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 = '13.10', price_tax_excluded = '10.74', date_upd = NOW() WHERE id_document = '89424' 25/03/2024 09:24:04 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 = '89424' 25/03/2024 09:24:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89424' 25/03/2024 09:24:04 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 ( '89424' , '20525' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM' , '1' , '-1' , '1' , '4.2000' , '3.4426229508197' , '22' , '0' , '4.20' ) 25/03/2024 09:24:04 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 ( '89424' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 25/03/2024 09:24:04 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 ( '89424' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '1.00' ) 25/03/2024 09:24: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 ( '89424' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 25/03/2024 09:24: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 ( '89424' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '1.10' ) 25/03/2024 09:24: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 ( '89424' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 25/03/2024 09:24: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 ( '89424' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 25/03/2024 09:56:31 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '90896' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 25/03/2024 09:56:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '41/A', document_date = '2024-03-22', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '426.80', price_tax_excluded = '370.26', date_upd = NOW() WHERE id_document = '90896' 25/03/2024 09:56: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 = '90896' 25/03/2024 09:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '90896' 25/03/2024 09:56: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 ( '90896' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 25/03/2024 09:56: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 ( '90896' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/03/2024 09:56: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 ( '90896' , '0' , 'GRANI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 25/03/2024 09:56: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 ( '90896' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 25/03/2024 09:56: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 ( '90896' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 25/03/2024 09:56: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 ( '90896' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '40.00' ) 25/03/2024 09:56: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 ( '90896' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 25/03/2024 09:56: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 ( '90896' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 25/03/2024 09:56: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 ( '90896' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.00' , '99' , '0' , '5' , '94.05' ) 25/03/2024 09:56: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 ( '90896' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.05' ) 25/03/2024 10:02:57 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '90896' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 25/03/2024 10:02:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '41/A', document_date = '2024-03-22', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '430.20', price_tax_excluded = '373.04', date_upd = NOW() WHERE id_document = '90896' 25/03/2024 10:02:57 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 = '90896' 25/03/2024 10:02:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90896' 25/03/2024 10:02:57 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 ( '90896' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 25/03/2024 10:02:57 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 ( '90896' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/03/2024 10:02:57 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 ( '90896' , '0' , 'GRANI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 25/03/2024 10:02:57 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 ( '90896' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 25/03/2024 10:02:57 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 ( '90896' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 25/03/2024 10:02:57 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 ( '90896' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '40.00' ) 25/03/2024 10:02:57 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 ( '90896' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 25/03/2024 10:02:57 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 ( '90896' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 25/03/2024 10:02:57 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 ( '90896' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.0000' , '99' , '0' , '5' , '94.05' ) 25/03/2024 10:02:57 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 ( '90896' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 25/03/2024 10:02:57 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 ( '90896' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 25/03/2024 10:02:57 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 ( '90896' , '18891' , 'ROSARIO LEGNO - R984' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/03/2024 10:06: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 ( '33' , '1321213' , '2024-03-15' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.60' , '75.60' , NOW() , NOW() ) 25/03/2024 10:06: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 = '90926' 25/03/2024 10:06:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90926' 25/03/2024 10:06: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 ( '90926' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '9' , '9' , '4' , '12.00' , '12' , '0' , '30' , '75.6000' ) 25/03/2024 10:06:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 25/03/2024 10:06:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 25/03/2024 10:22:55 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/03/2024 10:22:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22337' , '1' , '' , 'nuovo-prodotto' ) 25/03/2024 10:22:55 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22337' , '1' , '1' , '2' , NOW() , NOW() ) 25/03/2024 10:22:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22337' , '0' , '1' , '0' , '0' ) 25/03/2024 10:25:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400316520' AND id_product != '22337' AND ean13 != '' 25/03/2024 10:25:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400316520', date_upd = NOW() WHERE id_product = '22337' 25/03/2024 10:25:53 am >> UPDATE ps_product_lang SET name = 'CROCE IN POLIMERO - 2748', description = '' WHERE id_product = '22337' 25/03/2024 10:25:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '22337' 25/03/2024 10:25:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '22337' 25/03/2024 10:25:54 am >> DELETE FROM ps_specific_price WHERE id_product = '22337' 25/03/2024 10:25:56 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22337' 25/03/2024 10:25:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22338' , '1' , '' , 'nuovo-prodotto' ) 25/03/2024 10:25:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22338' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22337' 25/03/2024 10:25:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22338' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22337' 25/03/2024 10:27:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400053708' AND id_product != '4883' AND ean13 != '' 25/03/2024 10:27:25 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '8058400053708', date_upd = NOW() WHERE id_product = '4883' 25/03/2024 10:27:25 am >> UPDATE ps_product_lang SET name = 'ICONA IN LEGNO 30X40 - 1283', description = '' WHERE id_product = '4883' 25/03/2024 10:27:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '34.42622950819672' WHERE id_product = '4883' 25/03/2024 10:27:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '95', 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 = '4883' 25/03/2024 10:27:25 am >> DELETE FROM ps_specific_price WHERE id_product = '4883' 25/03/2024 10:27:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '4883' 25/03/2024 10:27:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22339' , '1' , '' , 'nuovo-prodotto' ) 25/03/2024 10:27:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22339' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '4883' 25/03/2024 10:27:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22339' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '4883' 25/03/2024 10:28:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002252' AND id_product != '4883' AND ean13 != '' 25/03/2024 10:28:01 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '002252', date_upd = NOW() WHERE id_product = '4883' 25/03/2024 10:28:01 am >> UPDATE ps_product_lang SET name = 'ICONA IN LEGNO 30X40 - 1283', description = '' WHERE id_product = '4883' 25/03/2024 10:28:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '34.4262' WHERE id_product = '4883' 25/03/2024 10:28:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '34.4262', id_tax_rules_group = '1', id_category_default = '95', 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 = '4883' 25/03/2024 10:28:01 am >> DELETE FROM ps_specific_price WHERE id_product = '4883' 25/03/2024 10:29: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 ( '31' , 'A1216' , '2024-03-25' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '153.76' , '126.03' , NOW() , NOW() ) 25/03/2024 10:29: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 = '90927' 25/03/2024 10:29:09 am >> DELETE FROM ps_document_detail WHERE id_document = '90927' 25/03/2024 10:29: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 ( '90927' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '4' , '4' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '44.2128' ) 25/03/2024 10:29:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 25/03/2024 10:29:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 25/03/2024 10:29: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 ( '90927' , '22337' , 'CROCE IN POLIMERO - 2748' , '50' , '50' , '1' , '0.87' , '0.71311475409836' , '22' , '0' , '53.0700' ) 25/03/2024 10:29:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '22337' AND id_supplier = '28' 25/03/2024 10:29:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22337' , '28' , '1' ) 25/03/2024 10:29: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 ( '90927' , '4883' , 'ICONA IN LEGNO 30X40 - 1283' , '1' , '1' , '1' , '15.9' , '13.032786885246' , '22' , '0' , '19.3980' ) 25/03/2024 10:29:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '4883' AND id_supplier = '28' 25/03/2024 10:29:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4883' , '28' , '1' ) 25/03/2024 10:29: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 ( '90927' , '4889' , 'ICONA LEGNO 30X40 - 1224' , '1' , '1' , '1' , '9.65' , '7.9098360655738' , '22' , '0' , '11.7730' ) 25/03/2024 10:29:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '4889' AND id_supplier = '28' 25/03/2024 10:29:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4889' , '28' , '1' ) 25/03/2024 10:29: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 ( '90927' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '2' , '2' , '1' , '4.37' , '3.5819672131148' , '22' , '0' , '10.6628' ) 25/03/2024 10:29:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21559' AND id_supplier = '28' 25/03/2024 10:29:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21559' , '28' , '1' ) 25/03/2024 10:53:17 am >> SELECT document_num FROM ps_document WHERE document_num = '882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 10:53: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' , '882' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.62' , '18.62' , NOW() , NOW() ) 25/03/2024 10:53: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 = '90928' 25/03/2024 10:53:17 am >> DELETE FROM ps_document_detail WHERE id_document = '90928' 25/03/2024 10:53: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 ( '90928' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '5' , '18.62' ) 25/03/2024 11:02:54 am >> SELECT document_num FROM ps_document WHERE document_num = '751' AND id_document != '90758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-14') 25/03/2024 11:02:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '751', document_date = '2024-03-14', 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 = '260.00', price_tax_excluded = '213.11', date_upd = NOW() WHERE id_document = '90758' 25/03/2024 11:02: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 = '90758' 25/03/2024 11:02:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90758' 25/03/2024 11:02: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 ( '90758' , '22317' , 'CASULA PERSONALIZZATA' , '3' , '-3' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '210.00' ) 25/03/2024 11:02: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 ( '90758' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 25/03/2024 11:03:16 am >> SELECT document_num FROM ps_document WHERE document_num = '781' AND id_document != '90795' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 25/03/2024 11:03:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '781', document_date = '2024-03-16', 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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '90795' 25/03/2024 11:03:16 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 = '90795' 25/03/2024 11:03:16 am >> DELETE FROM ps_document_detail WHERE id_document = '90795' 25/03/2024 11:03:16 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 ( '90795' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 25/03/2024 11:03:39 am >> SELECT document_num FROM ps_document WHERE document_num = '672' AND id_document != '90658' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 25/03/2024 11:03:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '672', document_date = '2024-03-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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '90658' 25/03/2024 11:03:39 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 = '90658' 25/03/2024 11:03:39 am >> DELETE FROM ps_document_detail WHERE id_document = '90658' 25/03/2024 11:03:39 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 ( '90658' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 25/03/2024 11:03:59 am >> SELECT document_num FROM ps_document WHERE document_num = '606' AND id_document != '90562' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-29') 25/03/2024 11:03:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '606', document_date = '2024-02-29', 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 = '90562' 25/03/2024 11:03: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 = '90562' 25/03/2024 11:03:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90562' 25/03/2024 11:03: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 ( '90562' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 25/03/2024 11:14:47 am >> SELECT document_num FROM ps_document WHERE document_num = '883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 11:14: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' , '883' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '21.63' , NOW() , NOW() ) 25/03/2024 11:14: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 = '90929' 25/03/2024 11:14:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90929' 25/03/2024 11:14: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 ( '90929' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 25/03/2024 11:14: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 ( '90929' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/03/2024 11:14: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 ( '90929' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 25/03/2024 11:31:21 am >> SELECT document_num FROM ps_document WHERE document_num = '884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 11:31: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' , '884' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 25/03/2024 11:31: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 = '90930' 25/03/2024 11:31:21 am >> DELETE FROM ps_document_detail WHERE id_document = '90930' 25/03/2024 11:31: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 ( '90930' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 25/03/2024 11:31: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 ( '90930' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '11.60' ) 25/03/2024 11:31: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 ( '90930' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '67.6' , '55.409836065574' , '22' , '0' , '67.60' ) 25/03/2024 11:31: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 ( '90930' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 25/03/2024 11: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 ( '90930' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 25/03/2024 11: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 ( '90930' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '115' , '94.262295081967' , '22' , '0' , '115.00' ) 25/03/2024 11: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 ( '90930' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 25/03/2024 11:33:51 am >> DELETE FROM ps_document WHERE id_document = '90728' 25/03/2024 11:33:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90728' 25/03/2024 11:37:40 am >> SELECT document_num FROM ps_document WHERE document_num = '43/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 11:37: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 ( '24' , '43/A' , '2024-03-25' , 'A' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.00' , '56.56' , NOW() , NOW() ) 25/03/2024 11:37: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 = '90931' 25/03/2024 11:37:40 am >> DELETE FROM ps_document_detail WHERE id_document = '90931' 25/03/2024 11:37: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 ( '90931' , '22318' , 'BOSSOLO OTTONE 8X14 - 162' , '1' , '-1' , '1' , '69.00' , '56.55737704918' , '22' , '0' , '69.00' ) 25/03/2024 11:51:02 am >> SELECT document_num FROM ps_document WHERE document_num = '884' AND id_document != '90930' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 11:51:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '884', document_date = '2024-03-25', 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 = '400.00', price_tax_excluded = '327.87', date_upd = NOW() WHERE id_document = '90930' 25/03/2024 11:51: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 = '90930' 25/03/2024 11:51:02 am >> DELETE FROM ps_document_detail WHERE id_document = '90930' 25/03/2024 11:51: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 ( '90930' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 25/03/2024 11:51: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 ( '90930' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '11.60' ) 25/03/2024 11:51: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 ( '90930' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '67.6000' , '55.409836065574' , '22' , '0' , '67.60' ) 25/03/2024 11:51: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 ( '90930' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 25/03/2024 11:51: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 ( '90930' , '22311' , 'CAMICE BENEDETTINO POL. - 70/000015' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 25/03/2024 11:51: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 ( '90930' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 25/03/2024 11:51:29 am >> SELECT document_num FROM ps_document WHERE document_num = '757' AND id_document != '90764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-14') 25/03/2024 11:51:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '757', document_date = '2024-03-14', 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 = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '90764' 25/03/2024 11:51:29 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 = '90764' 25/03/2024 11:51:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90764' 25/03/2024 11:51:29 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 ( '90764' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 25/03/2024 12:06:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839938213' AND id_product != '22339' AND ean13 != '' 25/03/2024 12:06:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788839938213', date_upd = NOW() WHERE id_product = '22339' 25/03/2024 12:06:33 pm >> UPDATE ps_product_lang SET name = 'UMILTA\' UN DONO NASCOSTO - F. LE CORRE', description = '' WHERE id_product = '22339' 25/03/2024 12:06:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '22339' 25/03/2024 12:06:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22339' 25/03/2024 12:06:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '22339' 25/03/2024 12:06:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22339' 25/03/2024 12:06:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22340' , '1' , '' , 'nuovo-prodotto' ) 25/03/2024 12:06:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22340' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22339' 25/03/2024 12:06:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22340' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22339' 25/03/2024 12:07: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 ( '33' , '660090' , '2024-03-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.86' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.52' , '171.52' , NOW() , NOW() ) 25/03/2024 12:07: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 = '90932' 25/03/2024 12:07:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90932' 25/03/2024 12:07: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 ( '90932' , '17327' , 'FIORI E LITURGIA - C. CRUCIANI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 25/03/2024 12:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17327' AND id_supplier = '7' 25/03/2024 12:07:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17327' , '7' , '1' ) 25/03/2024 12:07: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 ( '90932' , '22141' , 'CATECHESI' , '1' , '1' , '4' , '22.00' , '22' , '0' , '35' , '14.3000' ) 25/03/2024 12:07:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22141' AND id_supplier = '7' 25/03/2024 12:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22141' , '7' , '1' ) 25/03/2024 12:07:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90932' , '20778' , 'PASSIO N.E.' , '5' , '5' , '4' , '6.00' , '6' , '0' , '35' , '19.5000' ) 25/03/2024 12:07:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20778' AND id_supplier = '7' 25/03/2024 12:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20778' , '7' , '1' ) 25/03/2024 12:07:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90932' , '22339' , 'UMILTA UN DONO NASCOSTO - F. LE CORRE' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 25/03/2024 12:07:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22339' AND id_supplier = '7' 25/03/2024 12:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22339' , '7' , '1' ) 25/03/2024 12:07:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90932' , '22228' , 'PAROLA MI RACCONTA - P. CURTAZ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 25/03/2024 12:07:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22228' AND id_supplier = '7' 25/03/2024 12:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22228' , '7' , '1' ) 25/03/2024 12:07:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90932' , '16686' , 'EVANGELIARIO' , '1' , '1' , '4' , '150.00' , '150' , '0' , '30' , '105.0000' ) 25/03/2024 12:07:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '7' 25/03/2024 12:07:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '7' , '1' ) 25/03/2024 12:43:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '600' AND id_document != '90555' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-29') 25/03/2024 12:43:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '600', document_date = '2024-02-29', 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 = '7.30', price_tax_excluded = '5.98', date_upd = NOW() WHERE id_document = '90555' 25/03/2024 12:43:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90555' 25/03/2024 12:43:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90555' 25/03/2024 12:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90555' , '3028' , 'CROCE MET. 3T.OX CM 4,5 - G299 ' , '3' , '-3' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '1.20' ) 25/03/2024 12:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90555' , '3051' , 'CROCE METALLO CORPO RIP.OX CM 4X2 - G184OX' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 25/03/2024 12:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90555' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 25/03/2024 12:43:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90555' , '18138' , 'PORTACHIAVI DECINA CROCE - S46' , '1' , '-1' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '3.30' ) 25/03/2024 12:45:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '513' AND id_document != '90431' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 25/03/2024 12:45:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '513', document_date = '2024-02-20', 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 = '9.60', price_tax_excluded = '7.87', date_upd = NOW() WHERE id_document = '90431' 25/03/2024 12:45:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90431' 25/03/2024 12:45:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90431' 25/03/2024 12:45:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90431' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 25/03/2024 12:45:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90431' , '18138' , 'PORTACHIAVI DECINA CROCE - S46' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 25/03/2024 12:53:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '884' AND id_document != '90930' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 12:53:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '884', document_date = '2024-03-25', 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 = '400.00', price_tax_excluded = '327.87', date_upd = NOW() WHERE id_document = '90930' 25/03/2024 12:53: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 = '90930' 25/03/2024 12:53:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90930' 25/03/2024 12:53: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 ( '90930' , '22311' , 'CAMICE BENEDETTINO POL. - 70/000015' , '1' , '-1' , '1' , '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 25/03/2024 12:53: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 ( '90930' , '22317' , 'CASULA PERSONALIZZATA' , '3' , '-3' , '1' , '80' , '65.573770491803' , '22' , '0' , '240.00' ) 25/03/2024 12:54:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '536' AND id_document != '90468' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 25/03/2024 12:54:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '536', document_date = '2024-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '50.06', date_upd = NOW() WHERE id_document = '90468' 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90468' 25/03/2024 12:54:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90468' 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '20072' , 'BRACCIALE - BC1759N' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.3' , '5.1639344262295' , '22' , '0' , '6.30' ) 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '2440' , 'COLORO IL MIO GESÙ' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 25/03/2024 12:54:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 25/03/2024 12:55:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '530' AND id_document != '90456' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 25/03/2024 12:55:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '530', document_date = '2024-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '192.00', price_tax_excluded = '157.38', date_upd = NOW() WHERE id_document = '90456' 25/03/2024 12:55: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 = '90456' 25/03/2024 12:55:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90456' 25/03/2024 12:55: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 ( '90456' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '6' , '-6' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '132.00' ) 25/03/2024 12:55: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 ( '90456' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 25/03/2024 12:55: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 ( '90456' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 25/03/2024 12:55: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 ( '90456' , '10687' , 'TORCIA A VENTO ' , '4' , '-4' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '10.00' ) 25/03/2024 12:56:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '543' AND id_document != '90479' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-23') 25/03/2024 12:56:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '543', document_date = '2024-02-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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '90479' 25/03/2024 12:56:53 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 = '90479' 25/03/2024 12:56:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90479' 25/03/2024 12:56:53 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 ( '90479' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 25/03/2024 03:37:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 03:37: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' , '885' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.00' , '104.92' , NOW() , NOW() ) 25/03/2024 03:37: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 = '90933' 25/03/2024 03:37:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90933' 25/03/2024 03:37: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 ( '90933' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 25/03/2024 03:37: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 ( '90933' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 25/03/2024 03:39:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '90601' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-04') 25/03/2024 03:39:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '30/A', document_date = '2024-03-04', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 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 = '144.60', price_tax_excluded = '127.11', date_upd = NOW() WHERE id_document = '90601' 25/03/2024 03:39:56 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 = '90601' 25/03/2024 03:39:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90601' 25/03/2024 03:39:56 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 ( '90601' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 25/03/2024 03:39:56 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 ( '90601' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 25/03/2024 03:39:56 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 ( '90601' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '8.60' ) 25/03/2024 03:39:56 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 ( '90601' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/03/2024 03:39:56 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 ( '90601' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 25/03/2024 03:39:56 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 ( '90601' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 25/03/2024 03:46:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 03:46: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 ( '24' , '44/A' , '2024-03-25' , 'A' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.40' , '103.61' , NOW() , NOW() ) 25/03/2024 03:46: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 = '90934' 25/03/2024 03:46:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90934' 25/03/2024 03:46: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 ( '90934' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 25/03/2024 03:46: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 ( '90934' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 25/03/2024 03:47:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 03:47:46 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' , '886' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 25/03/2024 03:47:46 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 = '90935' 25/03/2024 03:47:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '90935' 25/03/2024 03:47:46 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 ( '90935' , '20487' , 'STELLARIO CM 14 - ART. 70' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 25/03/2024 03:55:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 03:55:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '887' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '137.50' , '116.61' , NOW() , NOW() ) 25/03/2024 03:55:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90936' 25/03/2024 03:55:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90936' 25/03/2024 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90936' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 25/03/2024 03:55:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90936' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 25/03/2024 03:55:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90936' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 25/03/2024 04:09:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 04:09:10 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' , '888' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '8.30' , NOW() , NOW() ) 25/03/2024 04:09:10 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 = '90937' 25/03/2024 04:09:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90937' 25/03/2024 04:09: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 ( '90937' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.3' , '8.3' , '0' , '0' , '8.30' ) 25/03/2024 04:32:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '89882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-09') 25/03/2024 04:32:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '91', document_date = '2024-01-09', 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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '89882' 25/03/2024 04:32: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 = '89882' 25/03/2024 04:32:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89882' 25/03/2024 04:32: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 ( '89882' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 25/03/2024 04:48:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 04:48:40 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' , '889' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '11.80' , NOW() , NOW() ) 25/03/2024 04:48:40 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 = '90938' 25/03/2024 04:48:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90938' 25/03/2024 04:48:40 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 ( '90938' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '6' , '-6' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '14.40' ) 25/03/2024 04:53:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 04:53: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' , '890' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '445.00' , '364.75' , NOW() , NOW() ) 25/03/2024 04:53: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 = '90939' 25/03/2024 04:53:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 04:53: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 ( '90939' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 25/03/2024 04:53:45 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 ( '90939' , '19344' , 'BALZA IN RASO - P354' , '2.5' , '-2.5' , '1' , '20' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 04:53:45 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 ( '90939' , '16279' , 'PIZZO VARI COLORI JHS - P486' , '2.5' , '-2.5' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 04:53:45 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 ( '90939' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 25/03/2024 04:53:45 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 ( '90939' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 25/03/2024 04:53:45 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 ( '90939' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 25/03/2024 04:53:45 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 ( '90939' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '63.1' , '51.72131147541' , '22' , '0' , '63.10' ) 25/03/2024 04:59:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '90939' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 04:59:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '890', document_date = '2024-03-25', 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 = '445.00', price_tax_excluded = '364.75', date_upd = NOW() WHERE id_document = '90939' 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 04:59:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '19344' , 'BALZA IN RASO - P354' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '16279' , 'PIZZO VARI COLORI JHS - P486' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '32.00' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '63.1000' , '51.72131147541' , '22' , '0' , '63.10' ) 25/03/2024 04:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '927' , 'BALZA RICAMATA VERDE - CM 15 - KOM/020 - OGGETTI' , '3' , '-3' , '1' , '20' , '16.393442622951' , '22' , '0' , '60.00' ) 25/03/2024 05:00:26 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '929' 25/03/2024 05:00:26 pm >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '929' 25/03/2024 05:00:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '90939' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 05:00:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '890', document_date = '2024-03-25', 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 = '445.00', price_tax_excluded = '364.75', date_upd = NOW() WHERE id_document = '90939' 25/03/2024 05:00:58 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 = '90939' 25/03/2024 05:00:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 05:00:58 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 ( '90939' , '19344' , 'BALZA IN RASO - P354' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 05:00:58 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 ( '90939' , '16279' , 'PIZZO VARI COLORI JHS - P486' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '50.00' ) 25/03/2024 05:00:58 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 ( '90939' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 25/03/2024 05:00:58 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 ( '90939' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '32.00' ) 25/03/2024 05:00:58 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 ( '90939' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 25/03/2024 05:00:58 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 ( '90939' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '63.1000' , '51.72131147541' , '22' , '0' , '63.10' ) 25/03/2024 05:00:58 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 ( '90939' , '927' , 'BALZA RICAMATA VERDE - CM 15 - KOM/020 - OGGETTI' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '60.00' ) 25/03/2024 05:00:58 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 ( '90939' , '926' , 'BALZA RICAMATA ROSSA CM 15 - KOM/020 - OGGETTI' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 25/03/2024 05:31:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '211' AND id_document != '90040' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-19') 25/03/2024 05:31:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '211', document_date = '2024-01-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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '90040' 25/03/2024 05:31:33 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 = '90040' 25/03/2024 05:31:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '90040' 25/03/2024 05:31: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 ( '90040' , '927' , 'BALZA RICAMATA VERDE - CM 15 - KOM/020 - OGGETTI' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 25/03/2024 05:31:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '379' AND id_document != '90259' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-06') 25/03/2024 05:31:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '379', document_date = '2024-02-06', 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 = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '90259' 25/03/2024 05:31: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 = '90259' 25/03/2024 05:31:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90259' 25/03/2024 05:31:58 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 ( '90259' , '927' , 'BALZA RICAMATA VERDE - CM 15 - KOM/020 - OGGETTI' , '2' , '-2' , '1' , '21.5' , '17.622950819672' , '22' , '0' , '43.00' ) 25/03/2024 05:32:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '522' AND id_document != '90447' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-21') 25/03/2024 05:32:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '522', document_date = '2024-02-21', 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 = '90447' 25/03/2024 05:32:27 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 = '90447' 25/03/2024 05:32:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '90447' 25/03/2024 05:32:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90447' , '926' , 'BALZA RICAMATA ROSSA CM 15 - KOM/020 - OGGETTI' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 25/03/2024 05:33:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '488' AND id_document != '90401' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 25/03/2024 05:33:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '488', document_date = '2024-02-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 = '51.00', price_tax_excluded = '41.80', date_upd = NOW() WHERE id_document = '90401' 25/03/2024 05:33:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90401' 25/03/2024 05:33:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90401' 25/03/2024 05:33:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90401' , '19344' , 'BALZA IN RASO - P354' , '3' , '-3' , '1' , '17' , '13.934426229508' , '22' , '0' , '51.00' ) 25/03/2024 05:34:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '89965' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-16') 25/03/2024 05:34:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '159', document_date = '2024-01-16', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '89965' 25/03/2024 05:34:15 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 = '89965' 25/03/2024 05:34:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89965' 25/03/2024 05:34:15 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 ( '89965' , '19787' , 'ROSARIO METALLO MM4 - 48M4' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 25/03/2024 05:34:15 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 ( '89965' , '16279' , 'PIZZO VARI COLORI JHS - P486' , '3' , '-3' , '1' , '11' , '9.016393442623' , '22' , '0' , '33.00' ) 25/03/2024 05:34:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '785' AND id_document != '90799' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 25/03/2024 05:34:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '785', document_date = '2024-03-16', 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 = '64.00', price_tax_excluded = '52.46', date_upd = NOW() WHERE id_document = '90799' 25/03/2024 05:34:56 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 = '90799' 25/03/2024 05:34:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90799' 25/03/2024 05:34:56 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 ( '90799' , '14621' , 'SANTA RITA BABY - 023 SR/9 BB' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 25/03/2024 05:34:56 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 ( '90799' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/03/2024 05:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '833' AND id_document != '90864' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 25/03/2024 05:35:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '833', document_date = '2024-03-20', 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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '90864' 25/03/2024 05:35:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90864' 25/03/2024 05:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90864' 25/03/2024 05:35:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90864' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 25/03/2024 05:35:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90864' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 25/03/2024 05:37:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '90939' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 05:37:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '890', document_date = '2024-03-25', 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 = '445.00', price_tax_excluded = '364.75', date_upd = NOW() WHERE id_document = '90939' 25/03/2024 05:37:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 05:37:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90939' 25/03/2024 05:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '47.5' , '38.934426229508' , '22' , '0' , '95.00' ) 25/03/2024 05:37:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90939' , '22317' , 'CASULA PERSONALIZZATA' , '5' , '-5' , '1' , '70' , '57.377049180328' , '22' , '0' , '350.00' ) 25/03/2024 05:47:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 05:47: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' , '891' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 25/03/2024 05:47: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 = '90940' 25/03/2024 05:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90940' 25/03/2024 05:47: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 ( '90940' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/03/2024 06:20:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 06:20:24 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' , '892' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.50' , '38.39' , NOW() , NOW() ) 25/03/2024 06:20: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 = '90941' 25/03/2024 06:20:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '90941' 25/03/2024 06:20: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 ( '90941' , '21015' , 'PASQUA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/03/2024 06:20: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 ( '90941' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 25/03/2024 06:21:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 06:21:48 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' , '893' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 25/03/2024 06:21:48 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 = '90942' 25/03/2024 06:21:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90942' 25/03/2024 06:21:48 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 ( '90942' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 25/03/2024 06:21:48 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 ( '90942' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/03/2024 06:24:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 06:24:45 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' , '894' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.50' , NOW() , NOW() ) 25/03/2024 06:24:45 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 = '90943' 25/03/2024 06:24:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90943' 25/03/2024 06:24:45 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 ( '90943' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 25/03/2024 06:24:45 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 ( '90943' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 25/03/2024 06:34:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 25/03/2024 06:34:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 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 = '66.00', price_tax_excluded = '57.34', date_upd = NOW() WHERE id_document = '90734' 25/03/2024 06:34: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 = '90734' 25/03/2024 06:34:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '90734' 25/03/2024 06:34: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 ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 25/03/2024 06:34: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 ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '48.00' ) 25/03/2024 06:57:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 06:57:52 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' , '895' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 25/03/2024 06:57:52 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 = '90944' 25/03/2024 06:57:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90944' 25/03/2024 06:57:52 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 ( '90944' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 25/03/2024 07:00:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 25/03/2024 07:00:46 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' , '896' , '2024-03-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 25/03/2024 07:00:46 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 = '90945' 25/03/2024 07:00:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '90945' 25/03/2024 07:00:46 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 ( '90945' , '5823' , 'LIBRO DORO' , '15' , '-15' , '4' , '0.60' , '0.6' , '0' , '0' , '9.00' )