17/09/2024 11:29:30 am >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '93161' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 17/09/2024 11:29:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '111', document_date = '2024-09-16', document_letter = '', id_customer = '90', id_supplier = '', id_address = '4679182', address1 = 'VIA GIANANI 98051 BARCELLONA POZZO DI GOTTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '467.60', price_tax_excluded = '467.60', date_upd = NOW() WHERE id_document = '93161' 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93161' 17/09/2024 11:29:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93161' 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '5444' , 'IO SONO CON VOI - CAT.' , '12' , '-12' , '4' , '5.5000' , '5.5' , '0' , '5' , '62.70' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '11193' , 'VENITE CON ME CAT.' , '28' , '-28' , '4' , '5.5000' , '5.5' , '0' , '5' , '146.30' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '11191' , 'VENITE CON ME 1 PARTE' , '29' , '-29' , '4' , '2.8000' , '2.8' , '0' , '15' , '69.02' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '11192' , 'VENITE CON ME 2 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '5' , '26.13' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '9675' , 'SARETE MIEI TESTIMONI' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 17/09/2024 11:29:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93161' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.18' , '-0.18' , '0' , '0' , '-0.18' ) 17/09/2024 11:32:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '90' 17/09/2024 11:32:26 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '90' , '10' , '179' , 'PARR. S. MARIA DI FATIMA' , 'GENOVESE ' , 'DON COSIMO' , 'VIA GIANANI ' , '' , '98051' , 'BARCELLONA POZZO DI GOTTO' , '' , '3389067777' , '' , '' , '90019690834' , NOW() , NOW() ) 17/09/2024 11:32:26 am >> UPDATE ps_customer SET email = 's.mariadifatima@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '90' 17/09/2024 11:49:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 11:49:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2705' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 17/09/2024 11:49:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93166' 17/09/2024 11:49:10 am >> DELETE FROM ps_document_detail WHERE id_document = '93166' 17/09/2024 11:49:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93166' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 17/09/2024 11:49:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93166' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '9' , '7.3770491803279' , '22' , '0' , '36.00' ) 17/09/2024 12:04:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 12:04: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' , '2706' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '135.25' , NOW() , NOW() ) 17/09/2024 12:04: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 = '93167' 17/09/2024 12:04:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93167' 17/09/2024 12:04: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 ( '93167' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '164' , '134.4262295082' , '22' , '0' , '164.00' ) 17/09/2024 12:04: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 ( '93167' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/09/2024 12:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2706' AND id_document != '93167' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 12:06:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2706', document_date = '2024-09-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 = '165.00', price_tax_excluded = '135.25', date_upd = NOW() WHERE id_document = '93167' 17/09/2024 12:06: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 = '93167' 17/09/2024 12:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93167' 17/09/2024 12:06: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 ( '93167' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/09/2024 12:06: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 ( '93167' , '22835' , 'PALLA - 50/361.' , '1' , '-1' , '1' , '164' , '134.4262295082' , '22' , '0' , '164.00' ) 17/09/2024 12:50:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 12:50:27 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' , '2707' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.60' , '28.46' , NOW() , NOW() ) 17/09/2024 12:50: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 = '93168' 17/09/2024 12:50:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93168' 17/09/2024 12:50: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 ( '93168' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 17/09/2024 12:50: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 ( '93168' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 17/09/2024 02:17:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2705' AND id_document != '93166' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 02:17:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2705', document_date = '2024-09-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 = '54.00', price_tax_excluded = '44.26', date_upd = NOW() WHERE id_document = '93166' 17/09/2024 02:17:19 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 = '93166' 17/09/2024 02:17:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93166' 17/09/2024 02:17:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93166' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '54' , '44.262295081967' , '22' , '0' , '54.00' ) 17/09/2024 03:12:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 03:12:14 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' , '2708' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.00' , '136.44' , NOW() , NOW() ) 17/09/2024 03:12:14 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 = '93169' 17/09/2024 03:12:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93169' 17/09/2024 03:12: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 ( '93169' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 17/09/2024 03:12: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 ( '93169' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '10' , '-10' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '43.00' ) 17/09/2024 03:12: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 ( '93169' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 17/09/2024 03:12: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 ( '93169' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 17/09/2024 03:42:52 pm >> DELETE FROM ps_document WHERE id_document = '93010' 17/09/2024 03:42:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93010' 17/09/2024 03:45:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 03:45:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '112' , '2024-09-17' , '' , '3553' , '0' , '4679105' , 'VIALE ITALIA 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '71.40' , '71.40' , NOW() , NOW() ) 17/09/2024 03:45:16 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 = '93170' 17/09/2024 03:45:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93170' 17/09/2024 03:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93170' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 17/09/2024 03:50:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 03:50:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2709' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '427.50' , '427.50' , NOW() , NOW() ) 17/09/2024 03:50: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 = '93171' 17/09/2024 03:50:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93171' 17/09/2024 03:50: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 ( '93171' , '21646' , 'PERDONATI - QUADERNO' , '30' , '-30' , '4' , '6.75' , '6.75' , '0' , '0' , '202.50' ) 17/09/2024 03:50: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 ( '93171' , '21587' , 'PERDONATI - GUIDA' , '4' , '-4' , '4' , '6.75' , '6.75' , '0' , '0' , '27.00' ) 17/09/2024 03:50: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 ( '93171' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '29' , '-29' , '4' , '4.5' , '4.5' , '0' , '0' , '130.50' ) 17/09/2024 03:50: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 ( '93171' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '5' , '-5' , '4' , '13.5' , '13.5' , '0' , '0' , '67.50' ) 17/09/2024 04:15:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 04:15:56 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' , '2710' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '246.20' , '233.94' , NOW() , NOW() ) 17/09/2024 04:15: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 = '93172' 17/09/2024 04:15:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93172' 17/09/2024 04:15: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 ( '93172' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '3' , '-3' , '4' , '12.6' , '12.6' , '0' , '0' , '37.80' ) 17/09/2024 04:15: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 ( '93172' , '22704' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '9' , '9' , '0' , '0' , '9.00' ) 17/09/2024 04:15: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 ( '93172' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '2' , '-2' , '4' , '12.6' , '12.6' , '0' , '0' , '25.20' ) 17/09/2024 04:15: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 ( '93172' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '3' , '-3' , '4' , '12.6' , '12.6' , '0' , '0' , '37.80' ) 17/09/2024 04:15: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 ( '93172' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '2' , '-2' , '4' , '9' , '9' , '0' , '0' , '18.00' ) 17/09/2024 04:15: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 ( '93172' , '22708' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '4' , '-4' , '4' , '12.6' , '12.6' , '0' , '0' , '50.40' ) 17/09/2024 04:15: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 ( '93172' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '4' , '-4' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '68.00' ) 17/09/2024 04:19:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 04:19:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2711' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '9.34' , NOW() , NOW() ) 17/09/2024 04:19:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93173' 17/09/2024 04:19:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '93173' 17/09/2024 04:19:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93173' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 17/09/2024 04:28:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2710' AND id_document != '93172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 04:28:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2710', document_date = '2024-09-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 = '246.20', price_tax_excluded = '233.94', date_upd = NOW() WHERE id_document = '93172' 17/09/2024 04:28:11 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 = '93172' 17/09/2024 04:28:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93172' 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '3' , '-3' , '4' , '12.6000' , '12.6' , '0' , '0' , '37.80' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22704' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22707' , 'CUORI INQUIETI - G. RAVASI' , '2' , '-2' , '4' , '12.6000' , '12.6' , '0' , '0' , '25.20' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22705' , 'NUDE DOMANDE DEL VANGELO - E. RONCHI' , '3' , '-3' , '4' , '12.6000' , '12.6' , '0' , '0' , '37.80' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22706' , 'FRANCESCO DASSISI - A. COMASTRI' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '0' , '18.00' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '22708' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '4' , '-4' , '4' , '12.6000' , '12.6' , '0' , '0' , '50.40' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 17/09/2024 04:28:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93172' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 17/09/2024 04:31:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '93170' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 04:31:00 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '112', document_date = '2024-09-17', document_letter = '', id_customer = '3553', id_supplier = '', id_address = '4679105', address1 = 'VIALE ITALIA 83100 AVELLINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '71.40', price_tax_excluded = '71.40', date_upd = NOW() WHERE id_document = '93170' 17/09/2024 04:31:00 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 = '93170' 17/09/2024 04:31:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93170' 17/09/2024 04:31:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93170' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 17/09/2024 05:06:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2152' AND id_document != '92494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 17/09/2024 05:06:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2152', document_date = '2024-07-01', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92494' 17/09/2024 05:06:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92494' 17/09/2024 05:06:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '92494' 17/09/2024 05:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '22566' , 'POLO SIMIL SCOZIA MM - M03' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 17/09/2024 05:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '7925' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '0.10' ) 17/09/2024 05:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 17/09/2024 05:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '21290' , 'ROSARIO ADDOLORATA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 17/09/2024 05:34:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 05:34: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' , '2712' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.20' , '27.14' , NOW() , NOW() ) 17/09/2024 05:34: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 = '93174' 17/09/2024 05:34:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '93174' 17/09/2024 05:34: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 ( '93174' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 17/09/2024 05:34: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 ( '93174' , '22753' , 'MESSA MEDITAZIONE - SETT/OTT 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 17/09/2024 05:34: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 ( '93174' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 17/09/2024 05:34: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 ( '93174' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 17/09/2024 05:34: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 ( '93174' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 17/09/2024 06:01:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 06:01:51 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' , '2713' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.94' , NOW() , NOW() ) 17/09/2024 06:01: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 = '93175' 17/09/2024 06:01:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93175' 17/09/2024 06:01: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 ( '93175' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 17/09/2024 06:01: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 ( '93175' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 17/09/2024 06:25:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-17') 17/09/2024 06:25:03 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' , '2714' , '2024-09-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '65.18' , NOW() , NOW() ) 17/09/2024 06:25:03 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 = '93176' 17/09/2024 06:25:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93176' 17/09/2024 06:25:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93176' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 17/09/2024 06:25:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93176' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 17/09/2024 06:25:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93176' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 17/09/2024 06:25:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93176' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' )