28/10/2023 09:11:50 am >> SELECT document_num FROM ps_document WHERE document_num = '205' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 09:11:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '205' , '2023-10-28' , '' , '541' , '0' , '4671522' , 'VIA GALLIANO 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '184.45' , '184.45' , NOW() , NOW() ) 28/10/2023 09:11:50 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 = '88591' 28/10/2023 09:11:50 am >> DELETE FROM ps_document_detail WHERE id_document = '88591' 28/10/2023 09:11:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88591' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '24' , '-24' , '4' , '3.50' , '3.5' , '0' , '15' , '71.40' ) 28/10/2023 09:11:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88591' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 28/10/2023 09:11:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88591' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '23' , '-23' , '4' , '3.50' , '3.5' , '0' , '15' , '68.42' ) 28/10/2023 09:13:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 09:13:46 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' , '3371' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 28/10/2023 09:13:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88592' 28/10/2023 09:13:46 am >> DELETE FROM ps_document_detail WHERE id_document = '88592' 28/10/2023 09:13:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88592' , '5823' , 'LIBRO DORO' , '100' , '-100' , '4' , '0.60' , '0.6' , '0' , '5' , '57.00' ) 28/10/2023 09:58:29 am >> SELECT document_num FROM ps_document WHERE document_num = '113/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 09:58:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '113/A' , '2023-10-28' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA BATTIPAGLIA ' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '40.33' , NOW() , NOW() ) 28/10/2023 09:58: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 = '88593' 28/10/2023 09:58:29 am >> DELETE FROM ps_document_detail WHERE id_document = '88593' 28/10/2023 09:58: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 ( '88593' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 28/10/2023 09:58: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 ( '88593' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 28/10/2023 09:58: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 ( '88593' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 28/10/2023 09:58: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 ( '88593' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/10/2023 09:58:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 09:58:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3372' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 28/10/2023 09:58:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88594' 28/10/2023 09:58:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88594' 28/10/2023 09:58:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88594' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 28/10/2023 10:21:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3373' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 10:21:24 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' , '3373' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 28/10/2023 10:21:24 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 = '88595' 28/10/2023 10:21:24 am >> DELETE FROM ps_document_detail WHERE id_document = '88595' 28/10/2023 10:21:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88595' , '21691' , 'PENDENTE FF 10X11' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/10/2023 10:23:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3374' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 10:23:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3374' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.70' , '7.13' , NOW() , NOW() ) 28/10/2023 10:23:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88596' 28/10/2023 10:23:38 am >> DELETE FROM ps_document_detail WHERE id_document = '88596' 28/10/2023 10:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88596' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '3' , '-3' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '8.70' ) 28/10/2023 10:24:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 10:24:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3375' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.65' , '192.65' , NOW() , NOW() ) 28/10/2023 10:24: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 = '88597' 28/10/2023 10:24:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88597' 28/10/2023 10:24: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 ( '88597' , '15475' , 'QUESTA SCUOLA E IL MONDO INTERO + CD - D. PAGANO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 28/10/2023 10:24: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 ( '88597' , '4168' , 'FIGLI DEL VENTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/10/2023 10:24: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 ( '88597' , '11280' , 'VI HO CHIAMATO AMICI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '11278' , 'VI HO CHIAMATO AMICI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 28/10/2023 10:24: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 ( '88597' , '17318' , 'CONOSCI LO SPIRITO SANTO - GUIDA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/10/2023 10:24: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 ( '88597' , '15386' , 'MESSA - LE PAROLE DI PAPA FRANCESCO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/10/2023 10:24: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 ( '88597' , '15982' , 'ANTICO TESTAMENTO - 1° ANNO' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 28/10/2023 10:24: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 ( '88597' , '18432' , 'SETTE SACRAMENTI ' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 28/10/2023 10:24: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 ( '88597' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 28/10/2023 10:24: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 ( '88597' , '19937' , 'SANTI A COLORI' , '1' , '-1' , '4' , '8.90' , '8.9' , '0' , '5' , '8.46' ) 28/10/2023 10:24: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 ( '88597' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/10/2023 10:24: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 ( '88597' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 28/10/2023 10:24: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 ( '88597' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '2.7' , '2.7' , '0' , '0' , '27.00' ) 28/10/2023 10:24: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 ( '88597' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '2.7' , '29.20' ) 28/10/2023 10:24: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 ( '88597' , '15316' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 28/10/2023 10:24: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 ( '88597' , '12868' , 'GIOCANDO SCOPRIAMO LANNO LITURGICO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 28/10/2023 10:24: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 ( '88597' , '18647' , 'SCOPRIAMO INSIEME AVVENTO E NATALE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 28/10/2023 10:45:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 10:45:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3376' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 28/10/2023 10:45: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 = '88598' 28/10/2023 10:45:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88598' 28/10/2023 10:45: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 ( '88598' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 28/10/2023 10:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '88526' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-25') 28/10/2023 10:50:52 am >> UPDATE ps_document SET id_document_type = '21', document_num = '193', document_date = '2023-10-25', document_letter = '', id_customer = '283', id_supplier = '', id_address = '4673604', address1 = 'VIA PALMIERI 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '129.71', price_tax_excluded = '129.71', date_upd = NOW() WHERE id_document = '88526' 28/10/2023 10:50: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 = '88526' 28/10/2023 10:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88526' 28/10/2023 10:50: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 ( '88526' , '5458' , 'IO SONO CON VOI 2 PARTE' , '11' , '-11' , '4' , '2.8000' , '2.8' , '0' , '15' , '26.18' ) 28/10/2023 10:50: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 ( '88526' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.8000' , '2.8' , '0' , '15' , '26.18' ) 28/10/2023 10:50: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 ( '88526' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 28/10/2023 10:50: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 ( '88526' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '21' , '-21' , '4' , '3.4000' , '3.4' , '0' , '15' , '60.69' ) 28/10/2023 11:00:14 am >> SELECT document_num FROM ps_document WHERE document_num = '193' AND id_document != '88526' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-25') 28/10/2023 11:00:14 am >> UPDATE ps_document SET id_document_type = '21', document_num = '193', document_date = '2023-10-25', document_letter = '', id_customer = '283', id_supplier = '', id_address = '4673604', address1 = 'VIA PALMIERI 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '1.27', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '282.03', price_tax_excluded = '282.03', date_upd = NOW() WHERE id_document = '88526' 28/10/2023 11:00: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 = '88526' 28/10/2023 11:00:14 am >> DELETE FROM ps_document_detail WHERE id_document = '88526' 28/10/2023 11:00: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 ( '88526' , '5458' , 'IO SONO CON VOI 2 PARTE' , '11' , '-11' , '4' , '2.8000' , '2.8' , '0' , '15' , '26.18' ) 28/10/2023 11:00: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 ( '88526' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.8000' , '2.8' , '0' , '15' , '26.18' ) 28/10/2023 11:00: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 ( '88526' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 28/10/2023 11:00: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 ( '88526' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '21' , '-21' , '4' , '3.4000' , '3.4' , '0' , '15' , '60.69' ) 28/10/2023 11:00: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 ( '88526' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '5' , '71.25' ) 28/10/2023 11:00: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 ( '88526' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '28' , '-28' , '4' , '3.00' , '3' , '0' , '5' , '79.80' ) 28/10/2023 11:01:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:01:41 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' , '3377' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.48' , '19.48' , NOW() , NOW() ) 28/10/2023 11:01: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 = '88599' 28/10/2023 11:01:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88599' 28/10/2023 11:01: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 ( '88599' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 28/10/2023 11:01: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 ( '88599' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 28/10/2023 11:06:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:06:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3378' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 28/10/2023 11:06:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88600' 28/10/2023 11:06:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88600' 28/10/2023 11:06:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88600' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 28/10/2023 11:07:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:07:36 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' , '3379' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 28/10/2023 11:07: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 = '88601' 28/10/2023 11:07:36 am >> DELETE FROM ps_document_detail WHERE id_document = '88601' 28/10/2023 11:07: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 ( '88601' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 28/10/2023 11:12:18 am >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:12:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '206' , '2023-10-28' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.50' , '197.50' , NOW() , NOW() ) 28/10/2023 11:12:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88602' 28/10/2023 11:12:18 am >> DELETE FROM ps_document_detail WHERE id_document = '88602' 28/10/2023 11:12:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '60' , '-60' , '4' , '3.50' , '3.5' , '0' , '15' , '178.50' ) 28/10/2023 11:12:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 28/10/2023 11:12:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '0' , '1.00' , '1' , '' , '0' , '2.00' ) 28/10/2023 11:21:09 am >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:21: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 ( '21' , '207' , '2023-10-28' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '261.25' , '261.25' , NOW() , NOW() ) 28/10/2023 11:21: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 = '88603' 28/10/2023 11:21:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88603' 28/10/2023 11:21: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 ( '88603' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 28/10/2023 11:21: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 ( '88603' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 28/10/2023 11:21: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 ( '88603' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '0' , '1.00' , '1' , '' , '0' , '1.00' ) 28/10/2023 11:21: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 ( '88603' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '50' , '-50' , '4' , '3.40' , '3.4' , '0' , '15' , '144.50' ) 28/10/2023 11:21: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 ( '88603' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 28/10/2023 11:21: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 ( '88603' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '0' , '1.00' , '1' , '' , '0' , '1.00' ) 28/10/2023 11:21:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:21:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3380' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 28/10/2023 11:21: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 = '88604' 28/10/2023 11:21:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88604' 28/10/2023 11:21: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 ( '88604' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 28/10/2023 11:25:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:25:48 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' , '3381' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.90' , '22.87' , NOW() , NOW() ) 28/10/2023 11:25:48 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 = '88605' 28/10/2023 11:25:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88605' 28/10/2023 11:25:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88605' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '4' , '-4' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '24.00' ) 28/10/2023 11:25:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88605' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 28/10/2023 11:27:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:27:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3382' , '2023-10-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 28/10/2023 11:27: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 = '88606' 28/10/2023 11:27:23 am >> DELETE FROM ps_document_detail WHERE id_document = '88606' 28/10/2023 11:27: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 ( '88606' , '21564' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 28/10/2023 11:41:38 am >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:41:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '208' , '2023-10-28' , '' , '396' , '0' , '4673404' , 'L.GO S. TOMMASO D\\\'AQUINO 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.73' , '51.73' , NOW() , NOW() ) 28/10/2023 11:41:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88607' 28/10/2023 11:41:38 am >> DELETE FROM ps_document_detail WHERE id_document = '88607' 28/10/2023 11:41:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88607' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 28/10/2023 11:41:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88607' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 28/10/2023 11:41:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88607' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/10/2023 11:46:04 am >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '88607' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:46:04 am >> UPDATE ps_document SET id_document_type = '21', document_num = '208', document_date = '2023-10-28', document_letter = '', id_customer = '396', id_supplier = '', id_address = '4673404', address1 = 'L.GO S. TOMMASO D\\\'AQUINO 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '51.73', price_tax_excluded = '51.73', date_upd = NOW() WHERE id_document = '88607' 28/10/2023 11:46: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 = '88607' 28/10/2023 11:46:04 am >> DELETE FROM ps_document_detail WHERE id_document = '88607' 28/10/2023 11:46: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 ( '88607' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 28/10/2023 11:46: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 ( '88607' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 28/10/2023 11:46: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 ( '88607' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 28/10/2023 11:46:46 am >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '88602' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:46:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '206', document_date = '2023-10-28', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '197.50', price_tax_excluded = '197.50', date_upd = NOW() WHERE id_document = '88602' 28/10/2023 11:46:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88602' 28/10/2023 11:46:46 am >> DELETE FROM ps_document_detail WHERE id_document = '88602' 28/10/2023 11:46:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '60' , '-60' , '4' , '3.5000' , '3.5' , '0' , '15' , '178.50' ) 28/10/2023 11:46:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 28/10/2023 11:46:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88602' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '0' , '1.0000' , '1' , '0' , '0' , '2.00' ) 28/10/2023 11:46:59 am >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '88603' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 11:46:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '207', document_date = '2023-10-28', document_letter = '', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '261.25', price_tax_excluded = '261.25', date_upd = NOW() WHERE id_document = '88603' 28/10/2023 11:46: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 = '88603' 28/10/2023 11:46:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88603' 28/10/2023 11:46: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 ( '88603' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 28/10/2023 11:46: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 ( '88603' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 28/10/2023 11:46: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 ( '88603' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '0' , '1.0000' , '1' , '0' , '0' , '1.00' ) 28/10/2023 11:46: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 ( '88603' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '50' , '-50' , '4' , '3.4000' , '3.4' , '0' , '15' , '144.50' ) 28/10/2023 11:46: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 ( '88603' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 28/10/2023 11:46: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 ( '88603' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '0' , '1.0000' , '1' , '0' , '0' , '1.00' ) 28/10/2023 12:15:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '112/A' AND id_document != '88581' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-27') 28/10/2023 12:15:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '112/A', document_date = '2023-10-27', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '122.27', price_tax_excluded = '122.27', date_upd = NOW() WHERE id_document = '88581' 28/10/2023 12:15: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 = '88581' 28/10/2023 12:15:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88581' 28/10/2023 12:15: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 ( '88581' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '29' , '-29' , '4' , '2.8000' , '2.8' , '0' , '15' , '69.02' ) 28/10/2023 12:15: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 ( '88581' , '4120' , 'FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 28/10/2023 12:15: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 ( '88581' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 28/10/2023 12:15: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 ( '88581' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.05' ) 28/10/2023 12:15: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 ( '88581' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 28/10/2023 12:15: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 ( '88581' , '' , 'lumino elettrico' , '2' , '-2' , '4' , '6.9' , '6.9' , '0' , '0' , '13.80' ) 28/10/2023 12:37:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '101/A' AND id_document != '87613' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-06') 28/10/2023 12:37:21 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '101/A', document_date = '2023-10-06', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo', 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 = '252.00', price_tax_excluded = '210.51', date_upd = NOW() WHERE id_document = '87613' 28/10/2023 12:37:21 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 = '87613' 28/10/2023 12:37:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '87613' 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '15.60' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16834' , 'LITURGICO CARTA 8GG' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 28/10/2023 12:37:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 28/10/2023 12:38:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 12:38:17 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' , '209' , '2023-10-28' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '26.52' , '26.52' , NOW() , NOW() ) 28/10/2023 12:38:17 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 = '88608' 28/10/2023 12:38:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88608' 28/10/2023 12:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88608' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.40' , '2.4' , '0' , '15' , '26.52' ) 28/10/2023 12:46:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '101/A' AND id_document != '87613' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-06') 28/10/2023 12:46:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '101/A', document_date = '2023-10-06', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo', 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 = '273.00', price_tax_excluded = '231.51', date_upd = NOW() WHERE id_document = '87613' 28/10/2023 12:46: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 = '87613' 28/10/2023 12:46:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87613' 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '15.60' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '16834' , 'LITURGICO CARTA 8GG' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 28/10/2023 12:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87613' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/10/2023 12:49:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 12:49: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 ( '26' , '3' , '2023-10-28' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '539.00' , '539.00' , NOW() , NOW() ) 28/10/2023 12:49: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 = '88609' 28/10/2023 12:49:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88609' 28/10/2023 12:49: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 ( '88609' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '60' , '0' , '4' , '3.5000' , '3.5' , '0' , '' , '210.00' ) 28/10/2023 12:49: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 ( '88609' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '' , '20.00' ) 28/10/2023 12:49: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 ( '88609' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '0' , '0' , '1.0000' , '1' , '0' , '0' , '2.00' ) 28/10/2023 12:49: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 ( '88609' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '0' , '4' , '3.5000' , '3.5' , '0' , '' , '105.00' ) 28/10/2023 12:49: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 ( '88609' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '' , '20.00' ) 28/10/2023 12:49: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 ( '88609' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '0' , '0' , '1.0000' , '1' , '0' , '0' , '1.00' ) 28/10/2023 12:49: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 ( '88609' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '50' , '0' , '4' , '3.4000' , '3.4' , '0' , '' , '170.00' ) 28/10/2023 12:49: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 ( '88609' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '' , '10.00' ) 28/10/2023 12:49: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 ( '88609' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '0' , '0' , '1.0000' , '1' , '0' , '0' , '1.00' ) 28/10/2023 12:53:24 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3988' 28/10/2023 12:53:24 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3988' , '10' , '140' , 'CURIA ARCIVESCOVILE' , 'TATULLO' , 'DON MARCO' , 'PIAZZA CATTEDRALE 9' , '' , '72024' , 'Oria' , '' , '' , '3296255702' , '' , '' , NOW() , NOW() ) 28/10/2023 12:53:24 pm >> UPDATE ps_customer SET email = 'marcotatu88@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3988' 28/10/2023 12:53:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '210' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-28') 28/10/2023 12:53:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '210' , '2023-10-28' , '' , '3988' , '0' , '4679162' , 'PIAZZA CATTEDRALE 9 72024 Oria' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '133.00' , '133.00' , NOW() , NOW() ) 28/10/2023 12:53: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 = '88610' 28/10/2023 12:53:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '88610' 28/10/2023 12:53: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 ( '88610' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '40' , '-40' , '4' , '3.50' , '3.5' , '0' , '5' , '133.00' )