07/12/2023 09:49:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 09:49: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 ( '11' , '3901' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '11.60' , NOW() , NOW() ) 07/12/2023 09:49: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 = '89381' 07/12/2023 09:49:27 am >> DELETE FROM ps_document_detail WHERE id_document = '89381' 07/12/2023 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89381' , '21919' , 'AMEN - APR 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 07/12/2023 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89381' , '21920' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 07/12/2023 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89381' , '21810' , 'AMEN - FEB 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 07/12/2023 09:49:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89381' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 07/12/2023 09:51:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 09:51:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3902' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.20' , '17.38' , NOW() , NOW() ) 07/12/2023 09:51:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89382' 07/12/2023 09:51:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89382' 07/12/2023 09:51:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89382' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '8' , '-8' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '17.60' ) 07/12/2023 09:51:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89382' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '3.60' ) 07/12/2023 09:56:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3903' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 09:56:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3903' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 07/12/2023 09:56:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89383' 07/12/2023 09:56:24 am >> DELETE FROM ps_document_detail WHERE id_document = '89383' 07/12/2023 09:56:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89383' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 07/12/2023 10:04:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3904' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:04: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' , '3904' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '6.90' , NOW() , NOW() ) 07/12/2023 10:04: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 = '89384' 07/12/2023 10:04:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89384' 07/12/2023 10:04: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 ( '89384' , '21532' , 'PENSIERI EUCARISTICI 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 07/12/2023 10:05:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:05:52 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' , '3905' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.10' , '15.45' , NOW() , NOW() ) 07/12/2023 10:05:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89385' 07/12/2023 10:05:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89385' 07/12/2023 10:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 07/12/2023 10:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 07/12/2023 10:05:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '5' , '4.0983606557377' , '22' , '0' , '10.00' ) 07/12/2023 10:09:40 am >> SELECT document_num FROM ps_document WHERE document_num = '22/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:09:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '22/L' , '2023-12-07' , 'L' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '299.20' , '283.87' , NOW() , NOW() ) 07/12/2023 10:09:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89386' 07/12/2023 10:09:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89386' 07/12/2023 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89386' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '90' , '-90' , '4' , '2.80' , '2.8' , '0' , '15' , '214.20' ) 07/12/2023 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89386' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '35.00' ) 07/12/2023 10:09:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89386' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '100' , '-100' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '50.00' ) 07/12/2023 10:14:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:14:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3906' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.27' , '56.66' , NOW() , NOW() ) 07/12/2023 10:14: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 = '89387' 07/12/2023 10:14:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89387' 07/12/2023 10:14: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 ( '89387' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 07/12/2023 10:14: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 ( '89387' , '1915' , 'CERCA E TROVA NELLE STORIE DELLA BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 07/12/2023 10:14: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 ( '89387' , '21627' , 'AVVENTO E NATALE 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 07/12/2023 10:14: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 ( '89387' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 07/12/2023 10:14: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 ( '89387' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.40' , '6.0655737704918' , '22' , '0' , '22.20' ) 07/12/2023 10:38:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:38:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3907' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.80' , '76.08' , NOW() , NOW() ) 07/12/2023 10:38:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89388' 07/12/2023 10:38:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89388' 07/12/2023 10:38:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89388' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.00' , '6' , '0' , '5' , '22.80' ) 07/12/2023 10:38:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89388' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 07/12/2023 10:38:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89388' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 07/12/2023 10:38:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89388' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 07/12/2023 10:45:53 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:45:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '313' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.20' , '214.20' , NOW() , NOW() ) 07/12/2023 10:45:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 10:45:53 am >> DELETE FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 10:45:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89389' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '90' , '-90' , '4' , '2.80' , '2.8' , '0' , '15' , '214.20' ) 07/12/2023 10:45:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89389' , '13397' , 'MIO GESU\'' , '70' , '-70' , '4' , '3.50' , '3.5' , '0' , '15' , '208.25' ) 07/12/2023 10:46:30 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '89389' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:46:30 am >> UPDATE ps_document SET id_document_type = '21', document_num = '313', document_date = '2023-12-07', document_letter = '', id_customer = '2021', id_supplier = '0', id_address = '4672489', 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 = '208.25', price_tax_excluded = '208.25', date_upd = NOW() WHERE id_document = '89389' 07/12/2023 10:46:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 10:46:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 10:46:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89389' , '13397' , 'MIO GESU\'' , '70' , '-70' , '4' , '3.5000' , '3.5' , '0' , '15' , '208.25' ) 07/12/2023 10:48:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 10:48: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' , '3908' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.75' , '30.12' , NOW() , NOW() ) 07/12/2023 10:48: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 = '89390' 07/12/2023 10:48:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89390' 07/12/2023 10:48: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 ( '89390' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '1' , '-1' , '1' , '32.25' , '26.434426229508' , '22' , '0' , '32.25' ) 07/12/2023 10:48: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 ( '89390' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 07/12/2023 11:06:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002128' AND id_product != '20885' AND ean13 != '' 07/12/2023 11:06:05 am >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '002128', date_upd = NOW() WHERE id_product = '20885' 07/12/2023 11:06:05 am >> UPDATE ps_product_lang SET name = 'BIGLIETTI SANTINI X 100 PZ', description = '' WHERE id_product = '20885' 07/12/2023 11:06:05 am >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '12.295081967213115' WHERE id_product = '20885' 07/12/2023 11:06:05 am >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '395', id_argoment_default = '206', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20885' 07/12/2023 11:06:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20885' 07/12/2023 11:07:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3624' AND id_document != '88987' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 07/12/2023 11:07:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3624', document_date = '2023-11-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '88987' 07/12/2023 11:07:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88987' 07/12/2023 11:07:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88987' 07/12/2023 11:07:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88987' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '9' , '-9' , '1' , '10' , '8.1967213114754' , '22' , '0' , '90.00' ) 07/12/2023 11:08:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3902' AND id_document != '89382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:08:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3902', document_date = '2023-12-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.20', price_tax_excluded = '17.38', date_upd = NOW() WHERE id_document = '89382' 07/12/2023 11:08: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 = '89382' 07/12/2023 11:08:54 am >> DELETE FROM ps_document_detail WHERE id_document = '89382' 07/12/2023 11:08: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 ( '89382' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '8' , '-8' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '17.60' ) 07/12/2023 11:08: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 ( '89382' , '9129' , 'ROSARIO LEGNO - T/2' , '2' , '-2' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '3.60' ) 07/12/2023 11:09:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3905' AND id_document != '89385' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:09:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3905', document_date = '2023-12-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.10', price_tax_excluded = '15.45', date_upd = NOW() WHERE id_document = '89385' 07/12/2023 11:09:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89385' 07/12/2023 11:09:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89385' 07/12/2023 11:09:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 07/12/2023 11:09:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 07/12/2023 11:09:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/12/2023 11:09:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89385' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/12/2023 11:11:41 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4970' 07/12/2023 11:11:41 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '4970' 07/12/2023 11:34:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:34:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3909' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.53' , '79.38' , NOW() , NOW() ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89391' 07/12/2023 11:34:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89391' 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '21915' , 'CI SPOSIAMO? - N. E. - L. FAGGIOLI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '6629' , 'MIA PREGHIERA' , '5' , '-5' , '4' , '0.90' , '0.9' , '0' , '0' , '4.50' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3604' , 'DOCUMENTI DEL CONCILIO VATICANO II' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3585' , 'DIVINA RIVELAZIONE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '4842' , 'HUMANAE VITAE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '6005' , 'LUMEN GENTIUM' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '9338' , 'SACROSANCTUM CONCILIUM' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '3433' , 'DIECI COMANDAMENTI' , '10' , '-10' , '4' , '0.20' , '0.2' , '0' , '0' , '2.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 07/12/2023 11:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89391' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 07/12/2023 11:38:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:38:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3910' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 07/12/2023 11:38:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89392' 07/12/2023 11:38:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89392' 07/12/2023 11:38:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89392' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 07/12/2023 11:38:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89392' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 07/12/2023 11:38:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89392' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 07/12/2023 11:38:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89392' , '21691' , 'PENDENTE FF 10X11' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/12/2023 11:49:38 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'P23Xpr4gdUTtnw9W' , NOW() , NOW() ) 07/12/2023 11:49:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4070' , '1' ) 07/12/2023 11:49:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4070' , '2' ) 07/12/2023 11:49:38 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4070' , '3' ) 07/12/2023 11:51:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4070' 07/12/2023 11:51:25 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 ( '4070' , '10' , '130' , 'CONVENTO S. GIOVANNI DEL PALCO' , 'CALVANO' , 'P. ANGELO' , 'VIA SAN GIOVANNI DEL PALCO 1' , '' , '83020' , 'TAURANO' , '' , '' , '3299133096' , '' , '' , NOW() , NOW() ) 07/12/2023 11:51:25 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4070' 07/12/2023 11:56:23 am >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:56: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 ( '21' , '314' , '2023-12-07' , '' , '4070' , '0' , '4679221' , 'VIA SAN GIOVANNI DEL PALCO 1 83020 TAURANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 07/12/2023 11:56: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 = '89393' 07/12/2023 11:56:23 am >> DELETE FROM ps_document_detail WHERE id_document = '89393' 07/12/2023 11:56: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 ( '89393' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 07/12/2023 11:56:27 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4070' 07/12/2023 11:56:27 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 ( '4070' , '10' , '130' , 'CONVENTO S. GIOVANNI DEL PALCO' , 'CALVANO' , 'P. ANGELO' , 'VIA SAN GIOVANNI DEL PALCO 1' , '' , '83020' , 'TAURANO' , '' , '' , '3299133096' , '' , '' , NOW() , NOW() ) 07/12/2023 11:56:27 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4070' 07/12/2023 11:58:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 11:58:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3911' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.80' , '44.10' , NOW() , NOW() ) 07/12/2023 11:58: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 = '89394' 07/12/2023 11:58:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89394' 07/12/2023 11:58: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 ( '89394' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '-1' , '1' , '51.00' , '41.803278688525' , '22' , '0' , '51.00' ) 07/12/2023 11:58: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 ( '89394' , '3051' , 'CROCE METALLO CORPO RIP.OX CM 4X2 - G184OX' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 07/12/2023 11:58: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 ( '89394' , '5536' , 'LACCIO' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 07/12/2023 12:00:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 12:00:04 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' , '3912' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '176.20' , '154.55' , NOW() , NOW() ) 07/12/2023 12:00:04 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 = '89395' 07/12/2023 12:00:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89395' 07/12/2023 12:00:04 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 ( '89395' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 07/12/2023 12:00:04 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 ( '89395' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 07/12/2023 12:00:04 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 ( '89395' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 07/12/2023 12:00:04 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 ( '89395' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 07/12/2023 12:00:04 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 ( '89395' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 07/12/2023 12:00:04 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 ( '89395' , '21745' , 'VENUTA DI DIO - F. KAMPHAUS' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 07/12/2023 12:04:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '89393' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 12:04:43 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '314', document_date = '2023-12-07', document_letter = '', id_customer = '4070', id_supplier = '', id_address = '4679221', address1 = 'VIA SAN GIOVANNI DEL PALCO 1 83020 TAURANO', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '20.20', price_tax_excluded = '20.20', date_upd = NOW() WHERE id_document = '89393' 07/12/2023 12:04:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89393' 07/12/2023 12:04:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89393' 07/12/2023 12:04:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89393' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 07/12/2023 12:15:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884242015' AND id_product != '8562' AND ean13 != '' 07/12/2023 12:15:36 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/2', ean13 = '9788884242015', date_upd = NOW() WHERE id_product = '8562' 07/12/2023 12:15:36 pm >> UPDATE ps_product_lang SET name = 'PROMESSE DEL SACRO CUORE DI GESÙ', description = '' WHERE id_product = '8562' 07/12/2023 12:15:36 pm >> UPDATE ps_product SET wholesale_price = '4.55', on_sale = '0', price = '6.5000' WHERE id_product = '8562' 07/12/2023 12:15:36 pm >> UPDATE ps_product_shop SET wholesale_price = '4.55', price = '6.5000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8562' 07/12/2023 12:15:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '8562' 07/12/2023 12:17:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884242075' AND id_product != '8562' AND ean13 != '' 07/12/2023 12:17:31 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/2', ean13 = '9788884242075', date_upd = NOW() WHERE id_product = '8562' 07/12/2023 12:17:31 pm >> UPDATE ps_product_lang SET name = 'PROMESSE DEL SACRO CUORE DI GESÙ', description = '' WHERE id_product = '8562' 07/12/2023 12:17:31 pm >> UPDATE ps_product SET wholesale_price = '4.55', on_sale = '0', price = '6.5000' WHERE id_product = '8562' 07/12/2023 12:17:31 pm >> UPDATE ps_product_shop SET wholesale_price = '4.55', price = '6.5000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8562' 07/12/2023 12:17:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '8562' 07/12/2023 12:18:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '89370' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 07/12/2023 12:18:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '51', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca prof. Giuseppe Lazzaro in Santa Maria ad Martyres\r\nv. Adriano Falvo - 84127 Salerno\r\n', 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 = '2596.00', price_tax_excluded = '2596.00', date_upd = NOW() WHERE id_document = '89370' 07/12/2023 12:18:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89370' 07/12/2023 12:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89370' 07/12/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 07/12/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 07/12/2023 12:18:13 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 ( '89370' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 12:18:13 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 ( '89370' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 07/12/2023 12:18:13 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 ( '89370' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 07/12/2023 12:18:13 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 ( '89370' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 12:18:13 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 ( '89370' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:13 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 ( '89370' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 07/12/2023 12:18:13 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 ( '89370' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 12:18:13 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 ( '89370' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 07/12/2023 12:18:13 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 ( '89370' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 07/12/2023 12:18:13 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 ( '89370' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 07/12/2023 12:18:13 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 ( '89370' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 07/12/2023 12:18:13 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 ( '89370' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1820' , '1820' , '0' , '0' , '1820.00' ) 07/12/2023 12:18:13 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 ( '89370' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '0' , '6.50' ) 07/12/2023 12:30:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '89389' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 12:30:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '313', document_date = '2023-12-07', document_letter = '', id_customer = '2021', id_supplier = '', id_address = '4672489', address1 = '', 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 = '208.25', price_tax_excluded = '208.25', date_upd = NOW() WHERE id_document = '89389' 07/12/2023 12:30:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 12:30:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89389' 07/12/2023 12:30:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89389' , '13397' , 'MIO GESU\'' , '70' , '-70' , '4' , '3.5000' , '3.5' , '0' , '15' , '208.25' ) 07/12/2023 01:01:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '140/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 01:01:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '140/A' , '2023-12-07' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '169.00' , '138.52' , NOW() , NOW() ) 07/12/2023 01:01:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89396' 07/12/2023 01:01:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89396' 07/12/2023 01:01:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89396' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '80' , '-80' , '1' , '1' , '0.81967213114754' , '22' , '0' , '80.00' ) 07/12/2023 01:01:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89396' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 07/12/2023 01:01:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89396' , '17617' , 'IMMAGINI ISONZO X 100' , '9' , '-9' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '31.50' ) 07/12/2023 01:01:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89396' , '19996' , 'GESU\' BAMBINO CM 34 - BJ142-34E' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 07/12/2023 01:02:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '141/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 01:02:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '141/A' , '2023-12-07' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 07/12/2023 01:02:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89397' 07/12/2023 01:02:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89397' 07/12/2023 01:02:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89397' , '11151' , 'LIBRI' , '200' , '-200' , '4' , '0.12' , '0.12' , '0' , '0' , '24.00' ) 07/12/2023 01:07:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 07/12/2023 01:07:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23 + 40,00 22/11 - 110,00 07/12', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '82607' 07/12/2023 01:07:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82607' 07/12/2023 01:07:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82607' 07/12/2023 01:07: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 ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 07/12/2023 01:07: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 ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 07/12/2023 01:08:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '89370' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 07/12/2023 01:08:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '51', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca prof. Giuseppe Lazzaro in Santa Maria ad Martyres\r\nv. Adriano Falvo - 84127 Salerno\r\n', 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 = '2596.00', price_tax_excluded = '2596.00', date_upd = NOW() WHERE id_document = '89370' 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89370' 07/12/2023 01:08:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89370' 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 07/12/2023 01:08:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 07/12/2023 01:08: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 ( '89370' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 01:08: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 ( '89370' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 01:08: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 ( '89370' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 01:08: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 ( '89370' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 07/12/2023 01:08: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 ( '89370' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 01:08: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 ( '89370' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 01:08: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 ( '89370' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 07/12/2023 01:08: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 ( '89370' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 01:08: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 ( '89370' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 01:08: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 ( '89370' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 07/12/2023 01:08: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 ( '89370' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 07/12/2023 01:08: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 ( '89370' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/12/2023 01:08: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 ( '89370' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:08: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 ( '89370' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1805' , '1805' , '0' , '0' , '1805.00' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '0' , '6.50' ) 07/12/2023 01:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89370' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 07/12/2023 02:29:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2810' AND id_document != '87277' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-13') 07/12/2023 02:29:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2810', document_date = '2023-09-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '87277' 07/12/2023 02:29:08 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 = '87277' 07/12/2023 02:29:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '87277' 07/12/2023 02:29:08 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 ( '87277' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/12/2023 02:29:08 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 ( '87277' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '190.00' , '155.73770491803' , '22' , '0' , '190.00' ) 07/12/2023 04:06:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 04:06:07 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' , '3913' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.90' , NOW() , NOW() ) 07/12/2023 04:06:07 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 = '89398' 07/12/2023 04:06:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89398' 07/12/2023 04:06:07 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 ( '89398' , '18690' , 'STORIA DEL NATALE' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 07/12/2023 04:45:57 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '3271/23', document_date = '2023-11-17', document_letter = '23', id_customer = '0', id_supplier = '', id_address = '2617', address1 = 'C.DA GIOPPO, 11 89040 CIRELLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '582.40', price_tax_excluded = '560.00', date_upd = NOW() WHERE id_document = '89062' 07/12/2023 04:45:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89062' 07/12/2023 04:45:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89062' 07/12/2023 04:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89062' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '280' , '280' , '3' , '2.0000' , '1.9230769230769' , '4' , '' , '582.4000' ) 07/12/2023 05:44:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 05:44:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3914' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '26.07' , NOW() , NOW() ) 07/12/2023 05:44: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 = '89399' 07/12/2023 05:44:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '89399' 07/12/2023 05:44: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 ( '89399' , '17569' , 'BAMBINO IN RESINA - PB6277' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 07/12/2023 05:44: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 ( '89399' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 07/12/2023 06:42:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 06:42:13 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' , '3915' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 07/12/2023 06:42:13 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 = '89400' 07/12/2023 06:42:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89400' 07/12/2023 06:42:13 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 ( '89400' , '16132' , 'DECINA IN METALLO - M0123' , '5' , '-5' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '2.00' ) 07/12/2023 07:07:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-07') 07/12/2023 07:07:35 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' , '3916' , '2023-12-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '9.34' , NOW() , NOW() ) 07/12/2023 07:07:35 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 = '89401' 07/12/2023 07:07:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89401' 07/12/2023 07:07: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 ( '89401' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 07/12/2023 07:45:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2898' AND id_document != '87397' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 07/12/2023 07:45:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2898', document_date = '2023-09-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '87397' 07/12/2023 07:45: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 = '87397' 07/12/2023 07:45:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '87397' 07/12/2023 07:45: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 ( '87397' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 07/12/2023 07:45: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 ( '87397' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 07/12/2023 07:45: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 ( '87397' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 07/12/2023 07:45: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 ( '87397' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' )