28/09/2024 08:52:59 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3045' 28/09/2024 08:52:59 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3045' , '10' , '200' , 'PARR. B. V. DEL ROSARIO' , 'LUCCHETTI' , 'P. FRANCESCO' , 'VIA MAESTRI DEL LAVORO 17' , '' , '85100' , 'POTENZA' , 'SPEDIZIONE: NICO TAMBURRINO - VIA SAN CONO 93B - 85100 POTENZA\r\nTEL 3792330488' , '' , '3280921026' , '' , '80007760764' , NOW() , NOW() ) 28/09/2024 08:52:59 am >> UPDATE ps_customer SET email = 'verginedelrosariopotenza@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3045' 28/09/2024 09:18:22 am >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 09:18:22 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' , '130' , '2024-09-28' , '' , '3045' , '0' , '4679365' , 'VIA MAESTRI DEL LAVORO 17 85100 POTENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '298.00' , '298.00' , NOW() , NOW() ) 28/09/2024 09:18:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93331' 28/09/2024 09:18:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93331' 28/09/2024 09:18:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93331' , '11193' , 'VENITE CON ME CAT.' , '25' , '-25' , '4' , '5.5' , '5.5' , '0' , '10' , '123.75' ) 28/09/2024 09:18:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93331' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '25' , '-25' , '4' , '5.50' , '5.5' , '0' , '10' , '123.75' ) 28/09/2024 09:18:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93331' , '12819' , 'REGISTRO DEL CATECHISTA ' , '30' , '-30' , '4' , '1.00' , '1' , '0' , '15' , '25.50' ) 28/09/2024 09:18:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93331' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '4' , '0.50' , '0.5' , '0' , '0' , '25.00' ) 28/09/2024 10:54:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2826' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 10:54:08 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' , '2826' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 28/09/2024 10:54:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93332' 28/09/2024 10:54:08 am >> DELETE FROM ps_document_detail WHERE id_document = '93332' 28/09/2024 10:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93332' , '20233' , 'STATUA BEATO CARLO ACUTIS CM 28 - 425' , '1' , '-1' , '1' , '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 28/09/2024 11:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2827' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:03:14 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' , '2827' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.90' , '46.63' , NOW() , NOW() ) 28/09/2024 11:03: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 = '93333' 28/09/2024 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93333' 28/09/2024 11:03: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 ( '93333' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '1.8' , '1.8' , '0' , '0' , '9.00' ) 28/09/2024 11:03: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 ( '93333' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/09/2024 11:03: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 ( '93333' , '475' , 'AMICO GESÙ - FIGURINE' , '11' , '-11' , '4' , '0.50' , '0.5' , '0' , '0' , '5.50' ) 28/09/2024 11:03: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 ( '93333' , '16265' , 'MIE PREGHIERE' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 28/09/2024 11:03: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 ( '93333' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/09/2024 11:03: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 ( '93333' , '19613' , 'AMICI CON LAUREOLA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/09/2024 11:03:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2828' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:03:44 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' , '2828' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 28/09/2024 11:03:44 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 = '93334' 28/09/2024 11:03:44 am >> DELETE FROM ps_document_detail WHERE id_document = '93334' 28/09/2024 11:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93334' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/09/2024 11:05:57 am >> SELECT document_num FROM ps_document WHERE document_num = '102/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:05:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '102/A' , '2024-09-28' , 'A' , '188' , '0' , '4679150' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '27.33' , NOW() , NOW() ) 28/09/2024 11:05:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93335' 28/09/2024 11:05:57 am >> DELETE FROM ps_document_detail WHERE id_document = '93335' 28/09/2024 11:05:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93335' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/09/2024 11:05:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93335' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 28/09/2024 11:05:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93335' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 28/09/2024 11:15:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2829' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:15: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' , '2829' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.33' , '133.59' , NOW() , NOW() ) 28/09/2024 11:15: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 = '93336' 28/09/2024 11:15:09 am >> DELETE FROM ps_document_detail WHERE id_document = '93336' 28/09/2024 11:15: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 ( '93336' , '13932' , 'CAMICE TALARE NERO' , '1' , '-1' , '1' , '110.00' , '90.16393442623' , '22' , '0' , '110.00' ) 28/09/2024 11:15: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 ( '93336' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 28/09/2024 11:15: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 ( '93336' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 28/09/2024 11:15: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 ( '93336' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 28/09/2024 11:15: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 ( '93336' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 28/09/2024 11:15: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 ( '93336' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/09/2024 11:15: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 ( '93336' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/09/2024 11:15: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 ( '93336' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 28/09/2024 11:18:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2830' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:18:56 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' , '2830' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.90' , '160.75' , NOW() , NOW() ) 28/09/2024 11:18:56 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 = '93337' 28/09/2024 11:18:56 am >> DELETE FROM ps_document_detail WHERE id_document = '93337' 28/09/2024 11:18:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93337' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/09/2024 11:18:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93337' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 28/09/2024 11:18:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93337' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '300' , '-300' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '90.00' ) 28/09/2024 11:18:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93337' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '300' , '-300' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '90.00' ) 28/09/2024 11:24:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2831' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:24:07 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' , '2831' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.03' , '11.48' , NOW() , NOW() ) 28/09/2024 11:24:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93338' 28/09/2024 11:24:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93338' 28/09/2024 11: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 ( '93338' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 28/09/2024 11: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 ( '93338' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '3' , '-3' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.50' ) 28/09/2024 11: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 ( '93338' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 28/09/2024 11: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 ( '93338' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/09/2024 11:25:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2832' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:25:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2832' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 28/09/2024 11:25:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93339' 28/09/2024 11:25:01 am >> DELETE FROM ps_document_detail WHERE id_document = '93339' 28/09/2024 11:25:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93339' , '21679' , 'LAUDATE DEUM - 8583' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/09/2024 11:25:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93339' , '21800' , 'LAUDATO SI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/09/2024 11:28:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2833' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:28:32 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' , '2833' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 28/09/2024 11:28:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93340' 28/09/2024 11:28:32 am >> DELETE FROM ps_document_detail WHERE id_document = '93340' 28/09/2024 11:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93340' , '16793' , 'SOPRACULLA 9X13' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 28/09/2024 11:33:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:33:12 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' , '2834' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.90' , '17.55' , NOW() , NOW() ) 28/09/2024 11:33:12 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 = '93341' 28/09/2024 11:33:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93341' 28/09/2024 11:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93341' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/09/2024 11:33:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93341' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/09/2024 11:46:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007817' AND id_product != '22933' AND ean13 != '' 28/09/2024 11:46:39 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000007817', date_upd = NOW() WHERE id_product = '22933' 28/09/2024 11:46:39 am >> UPDATE ps_product_lang SET name = 'BORSA CELEBRAZIONI - 1904', description = '' WHERE id_product = '22933' 28/09/2024 11:46:39 am >> UPDATE ps_product SET wholesale_price = '163.40', on_sale = '0', price = '327.8688524590164' WHERE id_product = '22933' 28/09/2024 11:46:39 am >> UPDATE ps_product_shop SET wholesale_price = '163.40', price = '327.8688524590164', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22933' 28/09/2024 11:46:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22933' 28/09/2024 11:46:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:46:51 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' , '2835' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 28/09/2024 11:46:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93342' 28/09/2024 11:46:51 am >> DELETE FROM ps_document_detail WHERE id_document = '93342' 28/09/2024 11:46:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93342' , '22933' , 'BORSA CELEBRAZIONI - 1904' , '1' , '-1' , '1' , '400.00' , '327.86885245902' , '22' , '0' , '400.00' ) 28/09/2024 11:52:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '92501' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-02') 28/09/2024 11:52:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2159', document_date = '2024-07-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '92501' 28/09/2024 11:52: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 = '92501' 28/09/2024 11:52:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92501' 28/09/2024 11:52: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 ( '92501' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/09/2024 11:52: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 ( '92501' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/09/2024 11:52:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2195' AND id_document != '92541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-04') 28/09/2024 11:52:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2195', document_date = '2024-07-04', 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 = '27.95', price_tax_excluded = '27.19', date_upd = NOW() WHERE id_document = '92541' 28/09/2024 11:52: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 = '92541' 28/09/2024 11:52:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92541' 28/09/2024 11:52: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 ( '92541' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 28/09/2024 11:52: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 ( '92541' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '2.80' ) 28/09/2024 11:52: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 ( '92541' , '1114' , 'BIBBIA DEGLI SPOSI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 28/09/2024 11:52:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2229' AND id_document != '92580' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 28/09/2024 11:52:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2229', document_date = '2024-07-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.50', price_tax_excluded = '2.05', date_upd = NOW() WHERE id_document = '92580' 28/09/2024 11:52:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92580' 28/09/2024 11:52:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92580' 28/09/2024 11:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92580' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 28/09/2024 11:53:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2426' AND id_document != '92822' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-06') 28/09/2024 11:53:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2426', document_date = '2024-08-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.55', price_tax_excluded = '7.86', date_upd = NOW() WHERE id_document = '92822' 28/09/2024 11:53:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92822' 28/09/2024 11:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92822' 28/09/2024 11:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92822' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 28/09/2024 11:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92822' , '15103' , 'GIROCOLLO - 870/24' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 28/09/2024 11:55:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2582' AND id_document != '93005' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-05') 28/09/2024 11:55:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2582', document_date = '2024-09-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '93005' 28/09/2024 11:55: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 = '93005' 28/09/2024 11:55:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93005' 28/09/2024 11:55: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 ( '93005' , '16955' , 'STOLA MARIANA - 8005' , '1' , '-1' , '1' , '155.0000' , '127.04918032787' , '22' , '0' , '155.00' ) 28/09/2024 11:55: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 ( '93005' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 28/09/2024 11:55:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93005' , '22362' , 'BASE CM 9X12 - 08.606' , '1' , '-1' , '1' , '41.00' , '33.606557377049' , '22' , '0' , '41.00' ) 28/09/2024 11:58:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 11:58:28 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' , '2836' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 28/09/2024 11:58:28 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 = '93343' 28/09/2024 11:58:28 am >> DELETE FROM ps_document_detail WHERE id_document = '93343' 28/09/2024 11:58:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93343' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 28/09/2024 12:06:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2837' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 12:06: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' , '2837' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.90' , '92.06' , NOW() , NOW() ) 28/09/2024 12:06: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 = '93344' 28/09/2024 12:06:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93344' 28/09/2024 12:06: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 ( '93344' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/09/2024 12:06: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 ( '93344' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 28/09/2024 12:06: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 ( '93344' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 28/09/2024 12:17:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2800' AND id_document != '93297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-26') 28/09/2024 12:17:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2800', document_date = '2024-09-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.00', price_tax_excluded = '54.65', date_upd = NOW() WHERE id_document = '93297' 28/09/2024 12:17: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 = '93297' 28/09/2024 12:17:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93297' 28/09/2024 12:17:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '17005' , 'BIGLIETTO AUGURALE medio' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 28/09/2024 12:17:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '10' , '-10' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '8.00' ) 28/09/2024 12:17:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '8983' , 'RINNEGARE SE STESSO PER VIVERE IN CRISTO - 8461' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 28/09/2024 12:17:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93297' , '20078' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '44.4' , '36.393442622951' , '22' , '0' , '44.40' ) 28/09/2024 12:18:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2818' AND id_document != '93321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 28/09/2024 12:18:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2818', document_date = '2024-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '93321' 28/09/2024 12:18:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93321' 28/09/2024 12:18:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93321' 28/09/2024 12:18:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/09/2024 12:18:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '20077' , 'BRACCIALE ARGENTO - 1375CAV' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 28/09/2024 12:18:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 28/09/2024 12:37:50 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'j8cn2KxA6caJZ541' , NOW() , NOW() ) 28/09/2024 12:37:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4118' , '1' ) 28/09/2024 12:37:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4118' , '2' ) 28/09/2024 12:37:50 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4118' , '3' ) 28/09/2024 12:39:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4118' 28/09/2024 12:39:12 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 ( '4118' , '10' , '126' , 'C/O STUDIO TECNICO' , 'DARBAZ' , 'ENRICA' , 'VIA GIARDINI 37' , '' , '11029' , 'VERRES' , '' , '' , '3482933941' , '' , '' , NOW() , NOW() ) 28/09/2024 12:39:12 pm >> UPDATE ps_customer SET email = 'saraja80@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4118' 28/09/2024 12:42:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 12:42:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '131' , '2024-09-28' , '' , '4118' , '0' , '4679366' , 'VIA GIARDINI 37 11029 VERRES' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '116.66' , '116.66' , NOW() , NOW() ) 28/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93345' 28/09/2024 12:42:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93345' 28/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93345' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 28/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93345' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '14' , '-14' , '4' , '3.61' , '3.61' , '0' , '0' , '50.54' ) 28/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93345' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '12' , '-12' , '4' , '3.61' , '3.61' , '0' , '0' , '43.32' ) 28/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93345' , '9675' , 'SARETE MIEI TESTIMONI' , '4' , '-4' , '4' , '3.33' , '3.33' , '0' , '0' , '13.32' ) 28/09/2024 12:42: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 ( '93345' , '' , 'ARROTONDAMENTI' , '1' , '-1' , '4' , '-0.02' , '-0.02' , '0' , '0' , '-0.02' ) 28/09/2024 12:47:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 12:47:09 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' , '2838' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 28/09/2024 12:47:09 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 = '93346' 28/09/2024 12:47:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93346' 28/09/2024 12:47:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93346' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/09/2024 12:47:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93346' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/09/2024 12:50:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-28') 28/09/2024 12:50:37 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' , '2839' , '2024-09-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 28/09/2024 12:50:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93347' 28/09/2024 12:50:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93347' 28/09/2024 12:50:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93347' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 28/09/2024 12:50:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93347' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' )