22/01/2024 10:04:44 am >> DELETE FROM ps_document WHERE id_document = '89888' 22/01/2024 10:04:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89888' 22/01/2024 10:05:01 am >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 10:05:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '223' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '21.15' , NOW() , NOW() ) 22/01/2024 10:05:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90053' 22/01/2024 10:05:01 am >> DELETE FROM ps_document_detail WHERE id_document = '90053' 22/01/2024 10:05:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90053' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 22/01/2024 10:05:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90053' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/01/2024 10:07:22 am >> SELECT document_num FROM ps_document WHERE document_num = '224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 10:07:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '224' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 22/01/2024 10:07: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 = '90054' 22/01/2024 10:07:23 am >> DELETE FROM ps_document_detail WHERE id_document = '90054' 22/01/2024 10:07: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 ( '90054' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 22/01/2024 10:49:25 am >> SELECT document_num FROM ps_document WHERE document_num = '225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 10:49:25 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' , '225' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 22/01/2024 10:49:25 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 = '90055' 22/01/2024 10:49:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90055' 22/01/2024 10:49:25 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 ( '90055' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '10' , '-10' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '220.00' ) 22/01/2024 11:32:42 am >> SELECT document_num FROM ps_document WHERE document_num = '226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 11:32:42 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' , '226' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 22/01/2024 11:32:42 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 = '90056' 22/01/2024 11:32:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90056' 22/01/2024 11:32:42 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 ( '90056' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '5' , '-5' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '30.00' ) 22/01/2024 11:32:42 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 ( '90056' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 22/01/2024 11:32:42 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 ( '90056' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 22/01/2024 11:38:33 am >> SELECT document_num FROM ps_document WHERE document_num = '227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 11:38:34 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' , '227' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.10' , '10.74' , NOW() , NOW() ) 22/01/2024 11:38:34 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 = '90057' 22/01/2024 11:38:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90057' 22/01/2024 11:38:34 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 ( '90057' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 22/01/2024 11:38:34 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 ( '90057' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 22/01/2024 11:39:15 am >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 11:39:15 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' , '228' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 22/01/2024 11:39:15 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 = '90058' 22/01/2024 11:39:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90058' 22/01/2024 11:39:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90058' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 22/01/2024 11:50:02 am >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 11:50:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '7' , '2024-01-22' , '' , '3462' , '0' , '4670254' , 'VIA LUCIFREDI, 35 18020 BORGHETTO D\\\'ARROSCIA' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 22/01/2024 11:50:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14182' 22/01/2024 11:50:02 am >> DELETE FROM ps_document_detail WHERE id_document = '14182' 22/01/2024 11:50:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14182' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/01/2024 12:45:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 12:45:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '20' , '2024-01-22' , '' , '2159' , '0' , '4678463' , 'VIA CAVAROLA, 3 41054 MARANO SUL PANARO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '137.70' , '137.70' , NOW() , NOW() ) 22/01/2024 12:45:45 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 = '90059' 22/01/2024 12:45:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90059' 22/01/2024 12:45:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90059' , '1048' , 'BENEDIZIONI - CROCIFISSIONE-C' , '900' , '-900' , '0' , '0.18' , '0.18' , '' , '15' , '137.70' ) 22/01/2024 12:47:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 12:47: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 ( '21' , '21' , '2024-01-22' , '' , '2630' , '0' , '4673397' , 'VIA LOMBARDA, 189 55013 LAMMARI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '474.63' , '474.63' , NOW() , NOW() ) 22/01/2024 12:47: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 = '90060' 22/01/2024 12:47:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '90060' 22/01/2024 12:47: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 ( '90060' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '15' , '76.50' ) 22/01/2024 12:47:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90060' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '-40' , '4' , '5.00' , '5' , '0' , '15' , '170.00' ) 22/01/2024 12:47:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90060' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '100' , '-100' , '4' , '2.50' , '2.5' , '0' , '15' , '212.50' ) 22/01/2024 12:47:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90060' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 22/01/2024 12:47:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90060' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 22/01/2024 12:47:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90060' , '9683' , 'SARÒ PADRINO, SARÒ MADRINA - A. FONTANA' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 22/01/2024 12:48:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '90060' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 12:48:43 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '21', document_date = '2024-01-22', document_letter = '', id_customer = '2630', id_supplier = '', id_address = '4673397', address1 = 'VIA LOMBARDA, 189 55013 LAMMARI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '474.63', price_tax_excluded = '474.63', date_upd = NOW() WHERE id_document = '90060' 22/01/2024 12:48: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 = '90060' 22/01/2024 12:48:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90060' 22/01/2024 12:48: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 ( '90060' , '17257' , 'IO TI BATTEZZO ' , '50' , '-50' , '4' , '1.8000' , '1.8' , '0' , '15' , '76.50' ) 22/01/2024 12:48: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 ( '90060' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '-40' , '4' , '5.0000' , '5' , '0' , '15' , '170.00' ) 22/01/2024 12:48: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 ( '90060' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '100' , '-100' , '4' , '2.5000' , '2.5' , '0' , '15' , '212.50' ) 22/01/2024 12:48: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 ( '90060' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 22/01/2024 12:48: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 ( '90060' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 22/01/2024 12:48: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 ( '90060' , '9683' , 'SARÒ PADRINO, SARÒ MADRINA - A. FONTANA' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 22/01/2024 02:14:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '7/A' AND id_document != '89900' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-10') 22/01/2024 02:14:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '7/A', document_date = '2024-01-10', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', 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 = '111.40', price_tax_excluded = '93.01', date_upd = NOW() WHERE id_document = '89900' 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89900' 22/01/2024 02:14:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89900' 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 22/01/2024 02:14:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89900' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/01/2024 02:20:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '89986' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-01-17') 22/01/2024 02:20:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1', document_date = '2024-01-17', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'AMO IL SIGNORE - TITOLO SPEDITO DIRETTAMENTE DA VELAR', 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 = '15407.50', price_tax_excluded = '15407.50', date_upd = NOW() WHERE id_document = '89986' 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89986' 22/01/2024 02:20:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89986' 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2400' , '-2400' , '4' , '3.0000' , '3' , '0' , '0' , '7200.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '960' , '-960' , '4' , '2.5000' , '2.5' , '0' , '0' , '2400.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '200' , '-200' , '4' , '2.0000' , '2' , '0' , '0' , '400.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '200' , '-200' , '4' , '2.0000' , '2' , '0' , '0' , '400.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '90' , '-90' , '4' , '10.0000' , '10' , '0' , '0' , '900.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.0000' , '1' , '0' , '0' , '1120.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.0000' , '1' , '0' , '0' , '350.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '0' , '37.50' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '400' , '-400' , '4' , '2.5000' , '2.5' , '0' , '0' , '1000.00' ) 22/01/2024 02:20:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '200' , '-200' , '4' , '8.00' , '8' , '0' , '0' , '1600.00' ) 22/01/2024 03:45:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 03:45:11 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' , '229' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 22/01/2024 03:45: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 = '90061' 22/01/2024 03:45:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '90061' 22/01/2024 03:45: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 ( '90061' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/01/2024 04:02:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 04:02:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '8' , '2024-01-22' , '' , '7007' , '0' , '98016362' , 'VIA CORTILE SAN SEBASTIANO 4 90013 CASTELBUONO' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 22/01/2024 04:02:26 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 = '14183' 22/01/2024 04:02:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '14183' 22/01/2024 04:02:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14183' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/01/2024 04:23:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 04:23:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '9' , '2024-01-22' , '' , '7084' , '0' , '172691778' , 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO' , '' , '' , '2.5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '145.00' , '145.00' , NOW() , NOW() ) 22/01/2024 04:23:10 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 = '14184' 22/01/2024 04:23:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '14184' 22/01/2024 04:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14184' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '5' , '118.75' ) 22/01/2024 04:23:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14184' , '137' , 'AVVENTO' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '5' , '23.75' ) 22/01/2024 04:55:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-22') 22/01/2024 04:55:45 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' , '230' , '2024-01-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 22/01/2024 04:55:45 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 = '90062' 22/01/2024 04:55:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90062' 22/01/2024 04:55:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90062' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )