14/11/2023 08:12:28 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'g2uoEbUKPOZX0dW2' , NOW() , NOW() ) 14/11/2023 08:12:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4054' , '1' ) 14/11/2023 08:12:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4054' , '2' ) 14/11/2023 08:12:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4054' , '3' ) 14/11/2023 08:13:49 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4054' 14/11/2023 08:13:49 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 ( '4054' , '10' , '173' , '' , 'TOMEI' , 'CARLO' , 'VIA 4 NOVEMBRE 3' , '' , '55064' , 'PESCAGLIA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 14/11/2023 08:13:49 am >> UPDATE ps_customer SET email = 'bartellonilucia@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4054' 14/11/2023 08:27:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 08:27: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' , '3592' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '374.00' , '306.56' , NOW() , NOW() ) 14/11/2023 08:27: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 = '88932' 14/11/2023 08:27:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88932' 14/11/2023 08:27: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 ( '88932' , '15097' , 'CORONA MATRIMONIO - ORO' , '20' , '-20' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '150.00' ) 14/11/2023 08:27: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 ( '88932' , '21767' , 'CROCE PETTORALE IN FILIGRANA - 3467' , '1' , '-1' , '1' , '224.00' , '183.60655737705' , '22' , '0' , '224.00' ) 14/11/2023 08:32:30 am >> SELECT document_num FROM ps_document WHERE document_num = '262' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 08:32:30 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' , '262' , '2023-11-14' , '' , '4054' , '0' , '4679187' , 'VIA 4 NOVEMBRE 3 55064 PESCAGLIA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '45.37' , '45.37' , NOW() , NOW() ) 14/11/2023 08:32: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 = '88933' 14/11/2023 08:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88933' 14/11/2023 08:32: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 ( '88933' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '5' , '13.30' ) 14/11/2023 08:32: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 ( '88933' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '15' , '-15' , '4' , '1.90' , '1.9' , '0' , '5' , '27.07' ) 14/11/2023 08:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '263' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 08:34:27 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' , '263' , '2023-11-14' , '' , '3836' , '0' , '4673191' , 'VIA ROMA , 34 84030 SAN RUFO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '135.29' , '135.29' , NOW() , NOW() ) 14/11/2023 08:34:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88934' 14/11/2023 08:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '88934' 14/11/2023 08:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88934' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '11' , '-11' , '4' , '3.40' , '3.4' , '0' , '5' , '35.53' ) 14/11/2023 08:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88934' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '19' , '-19' , '4' , '3.50' , '3.5' , '0' , '5' , '63.18' ) 14/11/2023 08:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88934' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '5' , '36.58' ) 14/11/2023 09:08:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 09:08: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' , '3593' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.90' , '29.43' , NOW() , NOW() ) 14/11/2023 09:08: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 = '88935' 14/11/2023 09:08:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88935' 14/11/2023 09:08: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 ( '88935' , '6404' , 'MENSA BIANCA 80X240 - M8024' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 14/11/2023 09:08: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 ( '88935' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 14/11/2023 09:19:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 09:19:16 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' , '3594' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '3.33' , NOW() , NOW() ) 14/11/2023 09:19:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88936' 14/11/2023 09:19:16 am >> DELETE FROM ps_document_detail WHERE id_document = '88936' 14/11/2023 09:19:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88936' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 14/11/2023 09:19:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88936' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 14/11/2023 09:21:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 09:21:26 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' , '3595' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 14/11/2023 09:21:26 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 = '88937' 14/11/2023 09:21:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88937' 14/11/2023 09:21:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88937' , '21483' , 'BIBBIA - SCRUTATE - TELATA' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/11/2023 09:48:05 am >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 09:48: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 ( '21' , '264' , '2023-11-14' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.11' , '31.11' , NOW() , NOW() ) 14/11/2023 09:48: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 = '88938' 14/11/2023 09:48:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88938' 14/11/2023 09:48: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 ( '88938' , '2448' , 'COLUI IN CUI CREDO' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 14/11/2023 09:48: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 ( '88938' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 14/11/2023 09:48: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 ( '88938' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '15' , '4.76' ) 14/11/2023 09:54:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 09:54:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3596' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.69' , '15.69' , NOW() , NOW() ) 14/11/2023 09:54:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88939' 14/11/2023 09:54:13 am >> DELETE FROM ps_document_detail WHERE id_document = '88939' 14/11/2023 09:54:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88939' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 14/11/2023 09:54:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88939' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 14/11/2023 10:03:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:03:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3597' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.20' , '117.38' , NOW() , NOW() ) 14/11/2023 10:03:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88940' 14/11/2023 10:03:13 am >> DELETE FROM ps_document_detail WHERE id_document = '88940' 14/11/2023 10:03:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88940' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 14/11/2023 10:03:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88940' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 14/11/2023 10:03:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88940' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 14/11/2023 10:03:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:03:35 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' , '3598' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 14/11/2023 10:03:35 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 = '88941' 14/11/2023 10:03:35 am >> DELETE FROM ps_document_detail WHERE id_document = '88941' 14/11/2023 10:03:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88941' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 14/11/2023 10:08:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:08:35 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' , '3599' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.51' , '7.51' , NOW() , NOW() ) 14/11/2023 10:08:35 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 = '88942' 14/11/2023 10:08:35 am >> DELETE FROM ps_document_detail WHERE id_document = '88942' 14/11/2023 10:08:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88942' , '21740' , 'ILLUMINA IL CAMMINO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 14/11/2023 10:28:54 am >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:28: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 ( '24' , '126/A' , '2023-11-14' , 'A' , '2021' , '0' , '4672489' , 'VIA ROMA, 134 80040 S. GENNARO VESUVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.87' , '14.87' , NOW() , NOW() ) 14/11/2023 10:28: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 = '88943' 14/11/2023 10:28:54 am >> DELETE FROM ps_document_detail WHERE id_document = '88943' 14/11/2023 10:28: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 ( '88943' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 14/11/2023 10:28: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 ( '88943' , '18357' , 'MIE PREGHIERINE N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 14/11/2023 10:28: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 ( '88943' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 14/11/2023 10:28: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 ( '88943' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 14/11/2023 10:28: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 ( '88943' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 14/11/2023 10:28: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 ( '88943' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 14/11/2023 10:35:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:35: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' , '3600' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '286.89' , NOW() , NOW() ) 14/11/2023 10:35: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 = '88944' 14/11/2023 10:35:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88944' 14/11/2023 10:35: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 ( '88944' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 14/11/2023 10:43:02 am >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:43:02 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' , '265' , '2023-11-14' , '' , '1140' , '0' , '4673607' , 'VIA PADRE GENTILE 84090 PONTECAGNANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.13' , '87.13' , NOW() , NOW() ) 14/11/2023 10:43:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88945' 14/11/2023 10:43:02 am >> DELETE FROM ps_document_detail WHERE id_document = '88945' 14/11/2023 10:43:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88945' , '2679' , 'CONOSCERE GESU' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 14/11/2023 10:43:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88945' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '15' , '12.75' ) 14/11/2023 10:46:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:46:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3601' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 14/11/2023 10:46:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88946' 14/11/2023 10:46:19 am >> DELETE FROM ps_document_detail WHERE id_document = '88946' 14/11/2023 10:46:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88946' , '21572' , 'DIO DOVE SEI FINITO? - M. PRASTARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/11/2023 10:46:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88946' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 14/11/2023 10:46:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88946' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 14/11/2023 10:53:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:53:37 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' , '3602' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 14/11/2023 10:53:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88947' 14/11/2023 10:53:37 am >> DELETE FROM ps_document_detail WHERE id_document = '88947' 14/11/2023 10:53:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88947' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 14/11/2023 10:57:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:57: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' , '3603' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '47.51' , NOW() , NOW() ) 14/11/2023 10:57: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 = '88948' 14/11/2023 10:57:23 am >> DELETE FROM ps_document_detail WHERE id_document = '88948' 14/11/2023 10:57: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 ( '88948' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 14/11/2023 10:57: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 ( '88948' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 14/11/2023 10:58:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 10:58:16 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' , '3604' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 14/11/2023 10:58:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88949' 14/11/2023 10:58:16 am >> DELETE FROM ps_document_detail WHERE id_document = '88949' 14/11/2023 10:58:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88949' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURÈ - 8814' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 14/11/2023 11:02:07 am >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '88938' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 11:02:07 am >> UPDATE ps_document SET id_document_type = '21', document_num = '264', document_date = '2023-11-14', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', 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 = '31.11', price_tax_excluded = '31.11', date_upd = NOW() WHERE id_document = '88938' 14/11/2023 11:02: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 = '88938' 14/11/2023 11:02:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88938' 14/11/2023 11:02: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 ( '88938' , '2448' , 'COLUI IN CUI CREDO' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 14/11/2023 11:02: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 ( '88938' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 14/11/2023 11:02: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 ( '88938' , '11191' , 'VENITE CON ME 1 PARTE' , '2' , '-2' , '4' , '2.8000' , '2.8' , '0' , '15' , '4.76' ) 14/11/2023 11:02:18 am >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '88945' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 11:02:18 am >> UPDATE ps_document SET id_document_type = '21', document_num = '265', document_date = '2023-11-14', document_letter = '', id_customer = '1140', id_supplier = '', id_address = '4673607', address1 = 'VIA PADRE GENTILE 84090 PONTECAGNANO', 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 = '87.13', price_tax_excluded = '87.13', date_upd = NOW() WHERE id_document = '88945' 14/11/2023 11:02: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 = '88945' 14/11/2023 11:02:18 am >> DELETE FROM ps_document_detail WHERE id_document = '88945' 14/11/2023 11:02: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 ( '88945' , '2679' , 'CONOSCERE GESU' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 14/11/2023 11:02: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 ( '88945' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '15' , '12.75' ) 14/11/2023 11:10: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 ( '33' , '648090' , '2023-11-10' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.20' , '124.20' , NOW() , NOW() ) 14/11/2023 11:10: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 = '88950' 14/11/2023 11:10:38 am >> DELETE FROM ps_document_detail WHERE id_document = '88950' 14/11/2023 11:10: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 ( '88950' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '33' , '40.2000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '7' , '1' ) 14/11/2023 11:10: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 ( '88950' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18691' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18691' , '7' , '1' ) 14/11/2023 11:10: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 ( '88950' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '12' , '12' , '4' , '5.00' , '5' , '0' , '33' , '40.2000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '7' , '1' ) 14/11/2023 11:10: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 ( '88950' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18704' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18704' , '7' , '1' ) 14/11/2023 11:10: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 ( '88950' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '33' , '40.2000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 14/11/2023 11:10: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 ( '88950' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 14/11/2023 11:10:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 14/11/2023 11:10:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 14/11/2023 11:24:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3275' AND id_document != '88458' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-21') 14/11/2023 11:24:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3275', document_date = '2023-10-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '88458' 14/11/2023 11:24:26 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 = '88458' 14/11/2023 11:24:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88458' 14/11/2023 11:24:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88458' , '21598' , 'SEGNALIBRO PICCOLO SAN PAOLO - PZ 50' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 14/11/2023 11:24:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88458' , '19996' , 'GESU\' BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '51' , '41.803278688525' , '22' , '0' , '51.00' ) 14/11/2023 02:31:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '88937' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 02:31:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3595', document_date = '2023-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.25', price_tax_excluded = '33.25', date_upd = NOW() WHERE id_document = '88937' 14/11/2023 02:31:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88937' 14/11/2023 02:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '88937' 14/11/2023 02:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88937' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '33.25' , '33.25' , '0' , '0' , '33.25' ) 14/11/2023 02:31:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3592' AND id_document != '88932' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 02:31:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3592', document_date = '2023-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '374.00', price_tax_excluded = '306.56', date_upd = NOW() WHERE id_document = '88932' 14/11/2023 02:31:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88932' 14/11/2023 02:31:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88932' 14/11/2023 02:31:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88932' , '15097' , 'CORONA MATRIMONIO - ORO' , '20' , '-20' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '150.00' ) 14/11/2023 02:31:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88932' , '21767' , 'CROCE PETTORALE IN FILIGRANA - 3467' , '1' , '-1' , '1' , '224.0000' , '183.60655737705' , '22' , '0' , '224.00' ) 14/11/2023 02:33:48 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3836' 14/11/2023 02:33:48 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 ( '3836' , '10' , '210' , '' , 'Perillo' , 'Mariassunta' , 'VIA ROMA 34' , '' , '84030' , 'SAN RUFO' , '' , '' , '3286568983' , '' , 'PRLMSS77D62G793R' , NOW() , NOW() ) 14/11/2023 02:33:48 pm >> UPDATE ps_customer SET email = 'maryasper@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3836' 14/11/2023 02:37:23 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/11/2023 02:37:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21823' , '1' , '' , 'nuovo-prodotto' ) 14/11/2023 02:37:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21823' , '1' , '1' , '2' , NOW() , NOW() ) 14/11/2023 02:37:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21823' , '0' , '1' , '0' , '0' ) 14/11/2023 02:38:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577126' AND id_product != '21823' AND ean13 != '' 14/11/2023 02:38:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788873577126', date_upd = NOW() WHERE id_product = '21823' 14/11/2023 02:38:20 pm >> UPDATE ps_product_lang SET name = 'DI MARIA UNA VERA IMMAGINE', description = '' WHERE id_product = '21823' 14/11/2023 02:38:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '21823' 14/11/2023 02:38:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21823' 14/11/2023 02:38:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21823' 14/11/2023 02:38:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21823' 14/11/2023 02:38:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21824' , '1' , '' , 'nuovo-prodotto' ) 14/11/2023 02:38:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21824' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21823' 14/11/2023 02:38:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21824' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21823' 14/11/2023 02:39:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879620079' AND id_product != '21824' AND ean13 != '' 14/11/2023 02:39:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788879620079', date_upd = NOW() WHERE id_product = '21824' 14/11/2023 02:39:19 pm >> UPDATE ps_product_lang SET name = 'TENEREZZA DEL PADRE - E. LECLERC', description = '' WHERE id_product = '21824' 14/11/2023 02:39:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '21824' 14/11/2023 02:39:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '110', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21824' 14/11/2023 02:39:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '21824' 14/11/2023 02:39:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21824' 14/11/2023 02:39:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21825' , '1' , '' , 'nuovo-prodotto' ) 14/11/2023 02:39:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21825' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21824' 14/11/2023 02:39:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21825' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21824' 14/11/2023 02:42:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280562432' AND id_product != '21825' AND ean13 != '' 14/11/2023 02:42:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9791280562432', date_upd = NOW() WHERE id_product = '21825' 14/11/2023 02:42:23 pm >> UPDATE ps_product_lang SET name = 'QUALE CANTO PER LE NOSTRE CELEBRAZIONI LITURGICHE? - A. CIMINI', description = '' WHERE id_product = '21825' 14/11/2023 02:42:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21825' 14/11/2023 02:42:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21825' 14/11/2023 02:42:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21825' 14/11/2023 02:44:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21825' 14/11/2023 02:44:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21826' , '1' , '' , 'nuovo-prodotto' ) 14/11/2023 02:44:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21826' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21825' 14/11/2023 02:44:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21826' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21825' 14/11/2023 02:45:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879623841' AND id_product != '21826' AND ean13 != '' 14/11/2023 02:45:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788879623841', date_upd = NOW() WHERE id_product = '21826' 14/11/2023 02:45:17 pm >> UPDATE ps_product_lang SET name = 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI', description = '' WHERE id_product = '21826' 14/11/2023 02:45:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '21826' 14/11/2023 02:45:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '110', id_argoment_default = '198', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21826' 14/11/2023 02:45:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '21826' 14/11/2023 02:46:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788879623841' AND id_product != '21826' AND ean13 != '' 14/11/2023 02:46:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788879623841', date_upd = NOW() WHERE id_product = '21826' 14/11/2023 02:46:03 pm >> UPDATE ps_product_lang SET name = 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI', description = '' WHERE id_product = '21826' 14/11/2023 02:46:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '21826' 14/11/2023 02:46:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '110', id_argoment_default = '198', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21826' 14/11/2023 02:46:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '21826' 14/11/2023 02:49:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000006131' , '2023-11-13' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '72.30' , '72.30' , NOW() , NOW() ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88951' 14/11/2023 02:49:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88951' 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21825' , 'QUALE CANTO PER LE NOSTRE CELEBRAZIONI LITURGICHE? - A. CIMINI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21825' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21825' , '107' , '1' ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21823' , 'DI MARIA UNA VERA IMMAGINE' , '2' , '2' , '4' , '8.00' , '8' , '0' , '35' , '10.4000' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21823' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21823' , '107' , '1' ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21824' , 'TENEREZZA DEL PADRE - E. LECLERC' , '1' , '1' , '4' , '11.00' , '11' , '0' , '35' , '7.1500' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21824' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21824' , '107' , '1' ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 14/11/2023 02:49:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88951' , '21826' , 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '35' , '16.9000' ) 14/11/2023 02:49:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21826' AND id_supplier = '107' 14/11/2023 02:49:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21826' , '107' , '1' ) 14/11/2023 02:53:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '88937' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 02:53:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3595', document_date = '2023-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.25', price_tax_excluded = '33.25', date_upd = NOW() WHERE id_document = '88937' 14/11/2023 02:53:34 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 = '88937' 14/11/2023 02:53:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '88937' 14/11/2023 02:53:35 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 ( '88937' , '21824' , 'TENEREZZA DEL PADRE - E. LECLERC' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 14/11/2023 02:53:35 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 ( '88937' , '7831' , 'PER LA VITA DEL MONDO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/11/2023 02:53:35 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 ( '88937' , '21692' , 'GENERATI DALLO SPIRITO - A. LOUF' , '1' , '-1' , '4' , '7.6' , '7.6' , '0' , '0' , '7.60' ) 14/11/2023 03:02:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 03:02:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3605' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.00' , '105.89' , NOW() , NOW() ) 14/11/2023 03:02:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88952' 14/11/2023 03:02:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88952' 14/11/2023 03:02:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88952' , '19997' , 'GESU\' BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 14/11/2023 03:02:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88952' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 14/11/2023 03:02:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88952' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '24' , '24' , '0' , '0' , '24.00' ) 14/11/2023 03:02:13 pm >> DELETE FROM ps_document WHERE id_document = '88786' 14/11/2023 03:02:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '88786' 14/11/2023 03:33:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3606' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 03:33:42 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' , '3606' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '31.88' , NOW() , NOW() ) 14/11/2023 03:33:42 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 = '88953' 14/11/2023 03:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88953' 14/11/2023 03:33:42 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 ( '88953' , '19143' , 'BIBBIA SCRUTATE - TASC.' , '1' , '-1' , '4' , '33.00' , '33' , '0' , '5' , '31.35' ) 14/11/2023 03:33:42 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 ( '88953' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '0.65' ) 14/11/2023 03:34:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 03:34:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3607' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.70' , '94.18' , NOW() , NOW() ) 14/11/2023 03:34:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88954' 14/11/2023 03:34:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '88954' 14/11/2023 03:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88954' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '3' , '-3' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '52.50' ) 14/11/2023 03:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88954' , '21773' , 'MERAVIGLIA DELLEVENTO CRISTIANO - G. BIFFI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 14/11/2023 03:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88954' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 14/11/2023 03:34:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88954' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 14/11/2023 03:40:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 03:40:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '31/S' , '2023-11-14' , 'S' , '3541' , '17' , '4672903' , 'VIA T. TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 14/11/2023 03:40:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13237' 14/11/2023 03:40:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '13237' 14/11/2023 03:40:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13237' , '126' , 'SACRAMENTO DEL PERDONO' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '50' , '50.00' ) 14/11/2023 03:40:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '126' AND id_supplier = '17' 14/11/2023 03:40:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '126' , '17' , '1' ) 14/11/2023 03:41:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/S' AND id_document != '13237' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 03:41:52 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '31/S', document_date = '2023-11-14', document_letter = 'S', id_customer = '3487', id_supplier = '0', id_address = '144688386', address1 = 'VIA T. TASSO, 10 24020 GORLE', 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 = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '13237' 14/11/2023 03:41:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13237' 14/11/2023 03:41:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '13237' 14/11/2023 03:41:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13237' , '126' , 'SACRAMENTO DEL PERDONO' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '50' , '50.00' ) 14/11/2023 03:43:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '6214/00' , '2023-11-13' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '200.00' , NOW() , NOW() ) 14/11/2023 03:43:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13238' 14/11/2023 03:43:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '13238' 14/11/2023 03:43:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13238' , '126' , 'SACRAMENTO DEL PERDONO' , '100' , '100' , '4' , '2.00' , '2' , '0' , '0' , '200.0000' ) 14/11/2023 05:15:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 05:15:49 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' , '3608' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 14/11/2023 05:15:49 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 = '88955' 14/11/2023 05:15:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '88955' 14/11/2023 05:15:49 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 ( '88955' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '12.50' ) 14/11/2023 05:27:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '266' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 05:27:30 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' , '266' , '2023-11-14' , '' , '1632' , '0' , '4679142' , 'P.ZZA PLEBISCITO, 11 84030 SANZA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '19.25' , '19.25' , NOW() , NOW() ) 14/11/2023 05:27:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88956' 14/11/2023 05:27:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88956' 14/11/2023 05:27:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88956' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 14/11/2023 05:42:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '267' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 05:42:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '267' , '2023-11-14' , '' , '1832' , '0' , '4670920' , 'C.DA PANTANO 85010 PIGNOLA' , '' , '' , '4.72' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '23.00' , '23.00' , NOW() , NOW() ) 14/11/2023 05:42:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88957' 14/11/2023 05:42:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '88957' 14/11/2023 05:42:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88957' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 14/11/2023 05:42:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88957' , '4154' , 'FESTA DEL PERDONO' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '15' , '7.65' ) 14/11/2023 05:43:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '119' AND id_document != '87343' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-19') 14/11/2023 05:43:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '119', document_date = '2023-09-19', document_letter = '', id_customer = '1832', id_supplier = '', id_address = '4670920', address1 = 'C.DA PANTANO 85010 PIGNOLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '143.27', price_tax_excluded = '143.27', date_upd = NOW() WHERE id_document = '87343' 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87343' 14/11/2023 05:43:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '87343' 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '12' , '-12' , '4' , '2.5000' , '2.5' , '0' , '15' , '25.50' ) 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4154' , 'FESTA DEL PERDONO' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '15' , '33.15' ) 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4120' , 'FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '15' , '42.50' ) 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '12' , '-12' , '4' , '3.4000' , '3.4' , '0' , '15' , '34.68' ) 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 14/11/2023 05:43:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87343' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.1900' , '3.19' , '0' , '0' , '3.19' ) 14/11/2023 05:56:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 05:56:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3609' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '16.83' , NOW() , NOW() ) 14/11/2023 05:56:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88958' 14/11/2023 05:56:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '88958' 14/11/2023 05:56:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88958' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 14/11/2023 06:11:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 06:11:53 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' , '3610' , '2023-11-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '470.00' , '387.99' , NOW() , NOW() ) 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88959' 14/11/2023 06:11:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '88959' 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88959' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88959' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88959' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88959' , '20691' , 'LUIGI E ZELIA MARTIN - J. CLAPIER' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/11/2023 06:11:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88959' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '188.8' , '154.75409836066' , '22' , '0' , '188.80' ) 14/11/2023 06:29:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '104' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 06:29:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '104' , '2023-11-14' , '' , '7072' , '0' , '154022856' , 'VIA DELLE FONTI 4/A 58014 MANCIANO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '35.40' , '35.40' , NOW() , NOW() ) 14/11/2023 06:29:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13239' 14/11/2023 06:29:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '13239' 14/11/2023 06:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13239' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 14/11/2023 07:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '127/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-14') 14/11/2023 07:06:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '127/A' , '2023-11-14' , 'A' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '922.25' , '922.25' , NOW() , NOW() ) 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88960' 14/11/2023 07:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88960' 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88960' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '33' , '-33' , '4' , '3.50' , '3.5' , '0' , '38' , '71.61' ) 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88960' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '33' , '-33' , '4' , '3.50' , '3.5' , '0' , '38' , '71.61' ) 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88960' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '23' , '-23' , '4' , '3.50' , '3.5' , '0' , '38' , '49.91' ) 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88960' , '5457' , 'IO SONO CON VOI 1 PARTE' , '210' , '-210' , '4' , '2.80' , '2.8' , '0' , '38' , '364.56' ) 14/11/2023 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88960' , '11191' , 'VENITE CON ME 1 PARTE' , '210' , '-210' , '4' , '2.80' , '2.8' , '0' , '38' , '364.56' )