25/11/2024 09:12:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '17608/00/2024' , '2024-11-21' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '123.03' , '111.12' , NOW() , NOW() ) 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94467' 25/11/2024 09:12:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94467' 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94467' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 25/11/2024 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '23104' AND id_supplier = '38' 25/11/2024 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23104' , '38' , '1' ) 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94467' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 25/11/2024 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 25/11/2024 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94467' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 25/11/2024 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 25/11/2024 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94467' , '22382' , 'STORIA DI UNANIMA - TASC - 8603' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 25/11/2024 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22382' AND id_supplier = '38' 25/11/2024 09:12:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22382' , '38' , '1' ) 25/11/2024 09:12:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94467' , '22555' , 'RITA DA CASCIA - 8658' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 25/11/2024 09:12:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22555' AND id_supplier = '38' 25/11/2024 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22555' , '38' , '1' ) 25/11/2024 09:12:17 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 ( '94467' , '23040' , 'SAN GABRIELE DELLADDOLORATA - 8756' , '2' , '2' , '4' , '12.00' , '12' , '0' , '40' , '14.4000' ) 25/11/2024 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '23040' AND id_supplier = '38' 25/11/2024 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23040' , '38' , '1' ) 25/11/2024 09:12:17 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 ( '94467' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '1' , '4' , '20.00' , '20' , '0' , '40' , '12.0000' ) 25/11/2024 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11882' AND id_supplier = '38' 25/11/2024 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11882' , '38' , '1' ) 25/11/2024 09:12:17 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 ( '94467' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '5' , '5' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '36.0144' ) 25/11/2024 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '22911' AND id_supplier = '38' 25/11/2024 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22911' , '38' , '1' ) 25/11/2024 09:12:17 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 ( '94467' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '5' , '5' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '30.0120' ) 25/11/2024 09:12:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '22910' AND id_supplier = '38' 25/11/2024 09:12:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22910' , '38' , '1' ) 25/11/2024 09:19:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3569' AND id_document != '94392' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 25/11/2024 09:19:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3569', document_date = '2024-11-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA S. FELICE IN FELLINE 84133 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 = '228.00', price_tax_excluded = '194.41', date_upd = NOW() WHERE id_document = '94392' 25/11/2024 09:19: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 = '94392' 25/11/2024 09:19:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94392' 25/11/2024 09:19: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 ( '94392' , '14791' , 'NATIVITA GROTTA 12 CM' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 25/11/2024 09:19: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 ( '94392' , '16319' , 'NATIVITA CM 8X8' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 25/11/2024 09:19: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 ( '94392' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' , '-150' , '1' , '0.2800' , '0.22950819672131' , '22' , '0' , '42.00' ) 25/11/2024 09:19: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 ( '94392' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '87.0000' , '71.311475409836' , '22' , '0' , '87.00' ) 25/11/2024 09:19: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 ( '94392' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 25/11/2024 09:19: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 ( '94392' , '19748' , 'CORONA DAVVENTO STELLE' , '1' , '-1' , '1' , '23.5000' , '19.262295081967' , '22' , '0' , '23.50' ) 25/11/2024 09:19: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 ( '94392' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '880' , '-880' , '4' , '0.0400' , '0.04' , '0' , '0' , '35.20' ) 25/11/2024 09:19: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 ( '94392' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/11/2024 09:19: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 ( '94392' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/11/2024 09:19: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 ( '94392' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/11/2024 10:10:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 10:10:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3626' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '33.65' , NOW() , NOW() ) 25/11/2024 10:10:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94468' 25/11/2024 10:10:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94468' 25/11/2024 10:10:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94468' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 25/11/2024 10:42:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3627' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 10:42:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3627' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 25/11/2024 10:42:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94469' 25/11/2024 10:42:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94469' 25/11/2024 10:42:19 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 ( '94469' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 25/11/2024 10:45:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 10:45:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3628' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '101.64' , NOW() , NOW() ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94470' 25/11/2024 10:45:56 am >> DELETE FROM ps_document_detail WHERE id_document = '94470' 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '22507' , 'SPES NON CONFUNDIT' , '9' , '-9' , '4' , '2.00' , '2' , '0' , '5' , '17.10' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 25/11/2024 10:45:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94470' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 25/11/2024 10:53:02 am >> SELECT document_num FROM ps_document WHERE document_num = '20/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 10:53: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 ( '23' , '20/L' , '2024-11-25' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA UNIVERSITA\'' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '286.00' , '242.23' , NOW() , NOW() ) 25/11/2024 10:53: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 = '94471' 25/11/2024 10:53:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94471' 25/11/2024 10:53: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 ( '94471' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 25/11/2024 10:53: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 ( '94471' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 25/11/2024 10:53: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 ( '94471' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 25/11/2024 10:53: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 ( '94471' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 25/11/2024 10:57:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 10:57: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' , '3629' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.30' , '9.30' , NOW() , NOW() ) 25/11/2024 10:57: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 = '94472' 25/11/2024 10:57:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94472' 25/11/2024 10:57: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 ( '94472' , '22698' , 'CALENDARIO LITURGICO 2025' , '8' , '-8' , '4' , '0.80' , '0.8' , '0' , '0' , '6.40' ) 25/11/2024 10:57: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 ( '94472' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 25/11/2024 11:13:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 11:13:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3630' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.30' , '63.18' , NOW() , NOW() ) 25/11/2024 11:13:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94473' 25/11/2024 11:13:29 am >> DELETE FROM ps_document_detail WHERE id_document = '94473' 25/11/2024 11:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94473' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 25/11/2024 11:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94473' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 25/11/2024 11:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94473' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 25/11/2024 11:26:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3185' AND id_document != '93838' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 25/11/2024 11:26:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3185', document_date = '2024-10-25', 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 = '6.70', price_tax_excluded = '5.49', date_upd = NOW() WHERE id_document = '93838' 25/11/2024 11:26:45 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 = '93838' 25/11/2024 11:26:45 am >> DELETE FROM ps_document_detail WHERE id_document = '93838' 25/11/2024 11:26:45 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 ( '93838' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.2' , '5.0819672131148' , '22' , '0' , '6.20' ) 25/11/2024 11:26:45 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 ( '93838' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 25/11/2024 11:27:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810978658' AND id_product != '23256' AND ean13 != '' 25/11/2024 11:27:39 am >> UPDATE ps_product SET id_supplier = '109', reference = '7/4', ean13 = '9788810978658', date_upd = NOW() WHERE id_product = '23256' 25/11/2024 11:27:39 am >> UPDATE ps_product_lang SET name = 'CELEBRIAMO MARIA - MESSALE MARIANO', description = '' WHERE id_product = '23256' 25/11/2024 11:27:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42.0000' WHERE id_product = '23256' 25/11/2024 11:27:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23256' 25/11/2024 11:27:39 am >> DELETE FROM ps_specific_price WHERE id_product = '23256' 25/11/2024 12:16:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 12:16:25 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' , '3631' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 25/11/2024 12:16:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94474' 25/11/2024 12:16:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '94474' 25/11/2024 12:16:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94474' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 25/11/2024 12:18:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3185' AND id_document != '93838' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 25/11/2024 12:18:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3185', document_date = '2024-10-25', 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 = '6.70', price_tax_excluded = '5.49', date_upd = NOW() WHERE id_document = '93838' 25/11/2024 12:18: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 = '93838' 25/11/2024 12:18:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '93838' 25/11/2024 12:18: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 ( '93838' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 25/11/2024 12:18: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 ( '93838' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 25/11/2024 12:18: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 ( '93838' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 25/11/2024 12:48:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 25/11/2024 12:48:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', 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 = '680.45', price_tax_excluded = '667.12', date_upd = NOW() WHERE id_document = '92691' 25/11/2024 12:48: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 = '92691' 25/11/2024 12:48:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 25/11/2024 12:48:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 25/11/2024 12:48:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '12' , '-12' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '42.00' ) 25/11/2024 12:48:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 25/11/2024 12:48: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 ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 25/11/2024 12:48: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 ( '92691' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 25/11/2024 12:48: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 ( '92691' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 25/11/2024 12:48: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 ( '92691' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 25/11/2024 12:48: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 ( '92691' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 25/11/2024 12:48: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 ( '92691' , '6809' , 'MOCCOLO 60X165' , '8' , '-8' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '36.00' ) 25/11/2024 12:48: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 ( '92691' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '-35' , '4' , '12.0000' , '12' , '0' , '5' , '399.00' ) 25/11/2024 12:48: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 ( '92691' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 25/11/2024 02:17:01 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/11/2024 02:17:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23260' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:17:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23260' , '1' , '1' , '2' , NOW() , NOW() ) 25/11/2024 02:17:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23260' , '0' , '1' , '0' , '0' ) 25/11/2024 02:18:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002330' AND id_product != '23260' AND ean13 != '' 25/11/2024 02:18:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002330', date_upd = NOW() WHERE id_product = '23260' 25/11/2024 02:18:22 pm >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO MARIANO LUREX - 671', description = '' WHERE id_product = '23260' 25/11/2024 02:18:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '174.59016393442624' WHERE id_product = '23260' 25/11/2024 02:18:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '174.59016393442624', id_tax_rules_group = '1', id_category_default = '432', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23260' 25/11/2024 02:18:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '23260' 25/11/2024 02:18:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002330' AND id_product != '23260' AND ean13 != '' 25/11/2024 02:18:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002330', date_upd = NOW() WHERE id_product = '23260' 25/11/2024 02:18:50 pm >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO MARIANO LUREX - 671', description = '' WHERE id_product = '23260' 25/11/2024 02:18:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '174.59016393442624' WHERE id_product = '23260' 25/11/2024 02:18:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '174.59016393442624', id_tax_rules_group = '1', id_category_default = '432', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23260' 25/11/2024 02:18:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '23260' 25/11/2024 02:18:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23260' 25/11/2024 02:18:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23261' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:18:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23261' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23260' 25/11/2024 02:18:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23261' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23260' 25/11/2024 02:19:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002231' AND id_product != '23261' AND ean13 != '' 25/11/2024 02:20:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002331' AND id_product != '23261' AND ean13 != '' 25/11/2024 02:20:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002331', date_upd = NOW() WHERE id_product = '23261' 25/11/2024 02:20:09 pm >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO COLOMBA', description = '' WHERE id_product = '23261' 25/11/2024 02:20:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '23261' 25/11/2024 02:20:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '432', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23261' 25/11/2024 02:20:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '23261' 25/11/2024 02:20:15 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23261' 25/11/2024 02:20:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23262' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:20:15 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23262' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23261' 25/11/2024 02:20:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23262' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23261' 25/11/2024 02:21:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002332' AND id_product != '23262' AND ean13 != '' 25/11/2024 02:21:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002332', date_upd = NOW() WHERE id_product = '23262' 25/11/2024 02:21:11 pm >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO AGNELLO - 61AGN', description = '' WHERE id_product = '23262' 25/11/2024 02:21:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '118.85245901639344' WHERE id_product = '23262' 25/11/2024 02:21:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '118.85245901639344', id_tax_rules_group = '1', id_category_default = '432', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23262' 25/11/2024 02:21:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23262' 25/11/2024 02:22: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 ( '31' , '538' , '2024-11-22' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '524.15' , '429.63' , NOW() , NOW() ) 25/11/2024 02:22: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 = '94475' 25/11/2024 02:22:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94475' 25/11/2024 02:22: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 ( '94475' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '3' , '3' , '1' , '54' , '44.262295081967' , '22' , '3' , '191.7108' ) 25/11/2024 02:22:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 25/11/2024 02:22:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 25/11/2024 02:22: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 ( '94475' , '17352' , 'STOLA MARIANA MISTO SETA - 1021 AM' , '1' , '1' , '1' , '61' , '50' , '22' , '3' , '72.1874' ) 25/11/2024 02:22:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17352' AND id_supplier = '118' 25/11/2024 02:22:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17352' , '118' , '1' ) 25/11/2024 02:22: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 ( '94475' , '23260' , 'COPRI LEGGIO MARIANO LUREX - 671' , '1' , '1' , '1' , '93' , '76.229508196721' , '22' , '3' , '110.0562' ) 25/11/2024 02:22:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23260' AND id_supplier = '118' 25/11/2024 02:22:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23260' , '118' , '1' ) 25/11/2024 02:22: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 ( '94475' , '23261' , 'COPRI LEGGIO COLOMBA' , '1' , '1' , '1' , '60' , '49.180327868852' , '22' , '3' , '71.0040' ) 25/11/2024 02:22:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23261' AND id_supplier = '118' 25/11/2024 02:22:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23261' , '118' , '1' ) 25/11/2024 02:22: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 ( '94475' , '23262' , 'COPRI LEGGIO AGNELLO - 61AGN' , '1' , '1' , '1' , '53' , '43.44262295082' , '22' , '3' , '62.7202' ) 25/11/2024 02:22:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23262' AND id_supplier = '118' 25/11/2024 02:22:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23262' , '118' , '1' ) 25/11/2024 02:22: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 ( '94475' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '13.5' , '11.065573770492' , '22' , '' , '16.4700' ) 25/11/2024 02:22:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '118' 25/11/2024 02:22:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '118' , '1' ) 25/11/2024 02:36:06 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/11/2024 02:36:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23263' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:36:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23263' , '1' , '1' , '2' , NOW() , NOW() ) 25/11/2024 02:36:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23263' , '0' , '1' , '0' , '0' ) 25/11/2024 02:37:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450374' AND id_product != '23263' AND ean13 != '' 25/11/2024 02:37:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791256450374', date_upd = NOW() WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> UPDATE ps_product_lang SET name = 'SEI SPECIALE DI GESU\' - M. DE SANCTIS', description = '' WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23264' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:37:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23264' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23263' 25/11/2024 02:37:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23264' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23263' 25/11/2024 02:38:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450343' AND id_product != '23264' AND ean13 != '' 25/11/2024 02:38:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256450343', date_upd = NOW() WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA CAMMINO ... - ', description = '' WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23265' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:38:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23265' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23264' 25/11/2024 02:38:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23265' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23264' 25/11/2024 02:39:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450336' AND id_product != '23265' AND ean13 != '' 25/11/2024 02:39:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791256450336', date_upd = NOW() WHERE id_product = '23265' 25/11/2024 02:39:52 pm >> UPDATE ps_product_lang SET name = 'ROSARIO E NOVENA A MARIA CHE SCIOGLIE I NODI ', description = '' WHERE id_product = '23265' 25/11/2024 02:39:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '23265' 25/11/2024 02:39:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '506', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23265' 25/11/2024 02:39:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '23265' 25/11/2024 02:39:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23265' 25/11/2024 02:39:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23266' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:39:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23266' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23265' 25/11/2024 02:39:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23266' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23265' 25/11/2024 02:40:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557719' AND id_product != '23266' AND ean13 != '' 25/11/2024 02:40:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831557719', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:40:58 pm >> UPDATE ps_product_lang SET name = 'FOLLOWERS 3 ', description = '' WHERE id_product = '23266' 25/11/2024 02:40:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23266' 25/11/2024 02:40:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:40:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '23266' 25/11/2024 02:40:59 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23266' 25/11/2024 02:40:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23267' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:40:59 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23267' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23266' 25/11/2024 02:40:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23267' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23266' 25/11/2024 02:43:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245648' AND id_product != '23267' AND ean13 != '' 25/11/2024 02:43:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788892245648', date_upd = NOW() WHERE id_product = '23267' 25/11/2024 02:43:10 pm >> UPDATE ps_product_lang SET name = 'NUTRIRE LA MENTE - CALABRESE/NOE', description = '' WHERE id_product = '23267' 25/11/2024 02:43:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23267' 25/11/2024 02:43:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23267' 25/11/2024 02:43:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23267' 25/11/2024 02:43:17 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23267' 25/11/2024 02:43:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23268' , '1' , '' , 'nuovo-prodotto' ) 25/11/2024 02:43:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23268' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23267' 25/11/2024 02:43:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23268' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23267' 25/11/2024 02:43:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '682880' , '2024-11-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.31' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.14' , '91.76' , NOW() , NOW() ) 25/11/2024 02:43:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94476' 25/11/2024 02:43:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94476' 25/11/2024 02:43: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 ( '94476' , '23263' , 'SEI SPECIALE DI GESU - M. DE SANCTIS' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23263' AND id_supplier = '7' 25/11/2024 02:43:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23263' , '7' , '1' ) 25/11/2024 02:43: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 ( '94476' , '23264' , 'MEDAGLIA MIRACOLOSA CAMMINO ... - ' , '1' , '1' , '4' , '4.00' , '4' , '0' , '30' , '2.8000' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23264' AND id_supplier = '7' 25/11/2024 02:43:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23264' , '7' , '1' ) 25/11/2024 02:43: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 ( '94476' , '23266' , 'FOLLOWERS 3 ' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23266' AND id_supplier = '7' 25/11/2024 02:43:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23266' , '7' , '1' ) 25/11/2024 02:43: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 ( '94476' , '22870' , 'AGENDA SAN PAOLO 2025' , '6' , '6' , '1' , '4.83' , '3.9590163934426' , '22' , '0' , '35.3556' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22870' AND id_supplier = '7' 25/11/2024 02:43:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22870' , '7' , '1' ) 25/11/2024 02:43: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 ( '94476' , '21522' , 'MASSIME ETERNE' , '3' , '3' , '4' , '5.50' , '5.5' , '0' , '30' , '11.5500' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21522' AND id_supplier = '7' 25/11/2024 02:43:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21522' , '7' , '1' ) 25/11/2024 02:43: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 ( '94476' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '33' , '4.0200' ) 25/11/2024 02:43:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22265' AND id_supplier = '7' 25/11/2024 02:44:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22265' , '7' , '1' ) 25/11/2024 02:44: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 ( '94476' , '23267' , 'NUTRIRE LA MENTE - CALABRESE/NOE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 25/11/2024 02:44:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23267' AND id_supplier = '7' 25/11/2024 02:44:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23267' , '7' , '1' ) 25/11/2024 02:46:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '255' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 02:46:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '255' , '2024-11-25' , '' , '4047' , '0' , '4679173' , 'VIALE 2 GIUGNO 53 40064 OZZANO DELL\\\'EMILIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '297.50' , '297.50' , NOW() , NOW() ) 25/11/2024 02:46:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94477' 25/11/2024 02:46:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94477' 25/11/2024 02:46:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94477' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '70' , '-70' , '4' , '5.00' , '5' , '0' , '15' , '297.50' ) 25/11/2024 02:51:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4047' 25/11/2024 02:51:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4047' , '10' , '137' , 'PARROCCHIA SAN CRISTOFORO' , '' , '' , 'VIALE 2 GIUGNO 53' , '' , '40064' , 'OZZANO DELL\'EMILIA' , 'CHIEDE INFO: ENRICO FABBRI - enfabbri75@gmail.com\r\nSpedizione a \r\nBERGONZONI FABIO - VIA TURATI, 2 - 40064 OZZANO DELL\'EMILIA (BO)\r\nTel. 333-1221906\r\n' , '' , '' , '' , '92014650375' , NOW() , NOW() ) 25/11/2024 02:51:22 pm >> UPDATE ps_customer SET email = 'parrocchia@sancristoforozzano.net', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4047' 25/11/2024 02:53:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557719' AND id_product != '23266' AND ean13 != '' 25/11/2024 02:53:37 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788831557719', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:53:37 pm >> UPDATE ps_product_lang SET name = 'FOLLOWERS 3 ', description = '' WHERE id_product = '23266' 25/11/2024 02:53:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '23266' 25/11/2024 02:53:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:53:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '23266' 25/11/2024 02:53:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557719' AND id_product != '23266' AND ean13 != '' 25/11/2024 02:53:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788831557719', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:53:46 pm >> UPDATE ps_product_lang SET name = 'FOLLOWERS 3 - CRESIMANDI', description = '' WHERE id_product = '23266' 25/11/2024 02:53:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.0000' WHERE id_product = '23266' 25/11/2024 02:53:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23266' 25/11/2024 02:53:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23266' 25/11/2024 02:55:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '44' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 02:55: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 ( '21' , '44' , '2024-11-25' , '' , '5685' , '0' , '4672435' , 'VIA UMBERTO I, 69 98046 S. LUCIA DEL MELA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '32.70' , '32.70' , NOW() , NOW() ) 25/11/2024 02:55: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 = '14772' 25/11/2024 02:55:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '14772' 25/11/2024 02:55: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 ( '14772' , '117' , 'La preghiera delle cinque dita n.e.' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 25/11/2024 02:55: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 ( '14772' , '' , 'AGENDA LITURGICO PASTORALE' , '2' , '-2' , '4' , '12' , '12' , '0' , '0' , '24.00' ) 25/11/2024 02:57:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3530' AND id_document != '94334' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 25/11/2024 02:57:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3530', document_date = '2024-11-19', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '94334' 25/11/2024 02:57:05 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 = '94334' 25/11/2024 02:57:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94334' 25/11/2024 02:57: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 ( '94334' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/11/2024 02:57:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3567' AND id_document != '94388' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 25/11/2024 02:57:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3567', document_date = '2024-11-20', 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.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94388' 25/11/2024 02:57:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94388' 25/11/2024 02:57:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94388' 25/11/2024 02:57:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94388' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 25/11/2024 02:57:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94388' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/11/2024 03:42:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '256' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 03:42:50 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' , '256' , '2024-11-25' , '' , '3138' , '0' , '4673110' , 'VIA RAMPA DELLA CHIESA, 26 56048 SALINE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '17.75' , '17.75' , NOW() , NOW() ) 25/11/2024 03:42:50 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 = '94478' 25/11/2024 03:42:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '94478' 25/11/2024 03:42:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94478' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '-5' , '4' , '2.40' , '2.4' , '0' , '15' , '10.20' ) 25/11/2024 03:42:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94478' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 25/11/2024 03:51:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 03:51:15 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' , '3632' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 25/11/2024 03:51: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 = '94479' 25/11/2024 03:51:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94479' 25/11/2024 03:51:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94479' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 25/11/2024 04:14:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '125/A' AND id_document != '94315' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-18') 25/11/2024 04:14:36 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '125/A', document_date = '2024-11-18', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '274.30', price_tax_excluded = '226.51', date_upd = NOW() WHERE id_document = '94315' 25/11/2024 04:14:36 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 = '94315' 25/11/2024 04:14:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94315' 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '0' , '23/11 DON MICHELE RITIRA' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '30' , '-30' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '96.00' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 25/11/2024 04:14:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94315' , '21137' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 25/11/2024 04:16:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 04:16:58 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' , '3633' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.80' , '25.17' , NOW() , NOW() ) 25/11/2024 04:16: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 = '94480' 25/11/2024 04:16:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94480' 25/11/2024 04:16: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 ( '94480' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 25/11/2024 04:16: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 ( '94480' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 25/11/2024 04:16: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 ( '94480' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/11/2024 04:20:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 04:20:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3634' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 25/11/2024 04:20:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94481' 25/11/2024 04:20:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '94481' 25/11/2024 04:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94481' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '-1' , '1' , '102.00' , '83.606557377049' , '22' , '0' , '102.00' ) 25/11/2024 04:25:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 04:25:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3635' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 25/11/2024 04:25: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 = '94482' 25/11/2024 04:25:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94482' 25/11/2024 04:25: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 ( '94482' , '23185' , 'GRUPPO NATIVITA\' CM 30 - PB16104' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 25/11/2024 04:28:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3301' AND id_document != '94004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-04') 25/11/2024 04:28:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3301', document_date = '2024-11-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '17.20', price_tax_excluded = '14.10', date_upd = NOW() WHERE id_document = '94004' 25/11/2024 04:28:28 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 = '94004' 25/11/2024 04:28:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '94004' 25/11/2024 04:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94004' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 25/11/2024 04:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94004' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '2' , '-2' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '1.20' ) 25/11/2024 04:28:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3359' AND id_document != '94099' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-07') 25/11/2024 04:28:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3359', document_date = '2024-11-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 = '14.50', price_tax_excluded = '11.89', date_upd = NOW() WHERE id_document = '94099' 25/11/2024 04:28:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94099' 25/11/2024 04:28:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '94099' 25/11/2024 04:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94099' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 25/11/2024 04:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94099' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 25/11/2024 04:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94099' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 25/11/2024 05:17:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 05:17: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' , '3636' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 25/11/2024 05:17: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 = '94483' 25/11/2024 05:17:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94483' 25/11/2024 05:17: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 ( '94483' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 25/11/2024 05:29:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 05:29:46 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' , '3637' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 25/11/2024 05:29:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94484' 25/11/2024 05:29:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '94484' 25/11/2024 05:29: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 ( '94484' , '7202' , 'ARTICOLI RELIGIOSI' , '7' , '-7' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '4.90' ) 25/11/2024 05:34:12 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '402/X', document_date = '2024-10-29', document_letter = 'X', id_customer = '0', id_supplier = '', id_address = '2668', address1 = 'VIA P. TRIBOLDI, 4 26015 SORESINA', address2 = '', note = '', price_shipping = '135.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2731.46', price_tax_excluded = '2238.90', date_upd = NOW() WHERE id_document = '93933' 25/11/2024 05:34:12 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 = '93933' 25/11/2024 05:34:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '93933' 25/11/2024 05:34: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 ( '93933' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '25' , '0' , '1' , '32' , '26.229508196721' , '22' , '0' , '976.0000' ) 25/11/2024 05:34: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 ( '93933' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '5' , '0' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '195.2000' ) 25/11/2024 05:34: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 ( '93933' , '15210' , 'CERO PASQUALE API 80X120' , '30' , '0' , '1' , '31.9000' , '26.147540983607' , '22' , '0' , '1167.54' ) 25/11/2024 05:34: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 ( '93933' , '19150' , 'MOCCOLO 70X200' , '24' , '0' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '105.41' ) 25/11/2024 05:34: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 ( '93933' , '6001' , 'LUMELLA ALLUMINIO 4AR F - 50 PZ' , '10' , '0' , '1' , '3.6500' , '2.9918032786885' , '22' , '0' , '44.53' ) 25/11/2024 05:34: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 ( '93933' , '20026' , 'CANDELA VOTIVA 20X40' , '200' , '0' , '1' , '0.32' , '0.26229508196721' , '22' , '0' , '78.0800' ) 25/11/2024 05:35:00 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '275/X', document_date = '2024-10-23', document_letter = 'X', id_customer = '0', id_supplier = '', id_address = '2668', address1 = 'VIA P. TRIBOLDI, 4 26015 SORESINA', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '93922' 25/11/2024 05:35:00 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 = '93922' 25/11/2024 05:35:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93922' 25/11/2024 05:35: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 ( '93922' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '25' , '25' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 25/11/2024 05:35: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 ( '93922' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '7' , '7' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 25/11/2024 05:35: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 ( '93922' , '15210' , 'CERO PASQUALE API 80X120' , '30' , '30' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 25/11/2024 05:35: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 ( '93922' , '19150' , 'MOCCOLO 70X200' , '24' , '24' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 25/11/2024 05:35: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 ( '93922' , '6001' , 'LUMELLA ALLUMINIO 4AR F - 50 PZ' , '10' , '10' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 25/11/2024 05:35: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 ( '93922' , '20026' , 'CANDELA VOTIVA 20X40' , '200' , '200' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 25/11/2024 05:37:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3638' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 05:37:24 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' , '3638' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.70' , '16.70' , NOW() , NOW() ) 25/11/2024 05:37:24 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 = '94485' 25/11/2024 05:37:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '94485' 25/11/2024 05:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94485' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 25/11/2024 05:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94485' , '18805' , 'FASCINO DELLE PARABOLE - 8016' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 25/11/2024 05:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94485' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 25/11/2024 05:51:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3637' AND id_document != '94484' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 05:51:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3637', document_date = '2024-11-25', 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 = '4.90', price_tax_excluded = '4.02', date_upd = NOW() WHERE id_document = '94484' 25/11/2024 05:51: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 = '94484' 25/11/2024 05:51:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94484' 25/11/2024 05:51: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 ( '94484' , '20026' , 'CANDELA VOTIVA 20X40' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 25/11/2024 05:56:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3639' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 05:56: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 ( '11' , '3639' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.48' , NOW() , NOW() ) 25/11/2024 05:56: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 = '94486' 25/11/2024 05:56:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94486' 25/11/2024 05:56: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 ( '94486' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 25/11/2024 06:00:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3640' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 06:00:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3640' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 25/11/2024 06:00: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 = '94487' 25/11/2024 06:00:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94487' 25/11/2024 06:00: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 ( '94487' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 25/11/2024 06:17:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3641' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 06:17:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3641' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.05' , '26.05' , NOW() , NOW() ) 25/11/2024 06:17:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94488' 25/11/2024 06:17:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94488' 25/11/2024 06:17: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 ( '94488' , '8328' , 'PREGHIERE A GESÙ BAMBINO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 25/11/2024 06:17: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 ( '94488' , '16598' , 'DEVOZIONE A GESU BAMBINO - 8943' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 25/11/2024 06:17: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 ( '94488' , '19587' , 'GESU BAMBINO DI PRAGA - 8079' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 25/11/2024 06:17: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 ( '94488' , '23040' , 'SAN GABRIELE DELLADDOLORATA - 8756' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 25/11/2024 06:22:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3642' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 06:22:56 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' , '3642' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 25/11/2024 06:22:56 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 = '94489' 25/11/2024 06:22:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94489' 25/11/2024 06:22:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94489' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 25/11/2024 06:27:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3643' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 06:27: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' , '3643' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 25/11/2024 06:27: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 = '94490' 25/11/2024 06:27:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94490' 25/11/2024 06:27: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 ( '94490' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 25/11/2024 06:27: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 ( '94490' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 25/11/2024 06:27: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 ( '94490' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 25/11/2024 06:27: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 ( '94490' , '17465' , 'QUADRETTO EFFETTO PIETRA MIRACOLOSA E MEDAGLIA 2952/M4' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 25/11/2024 06:31:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3608' AND id_document != '94444' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 25/11/2024 06:31:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3608', document_date = '2024-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.50', price_tax_excluded = '22.54', date_upd = NOW() WHERE id_document = '94444' 25/11/2024 06:31:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94444' 25/11/2024 06:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '94444' 25/11/2024 06:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94444' , '23100' , 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 25/11/2024 06:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94444' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 25/11/2024 06:32:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3462' AND id_document != '94239' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-13') 25/11/2024 06:32:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3462', document_date = '2024-11-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '81.42', price_tax_excluded = '74.21', date_upd = NOW() WHERE id_document = '94239' 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94239' 25/11/2024 06:32:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94239' 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/11/2024 06:32:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 25/11/2024 06:32:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94239' , '23088' , 'CAMPANA DEL GIUBILEO' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 25/11/2024 06:32:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3423' AND id_document != '94183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-11') 25/11/2024 06:32:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3423', document_date = '2024-11-11', 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 = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '94183' 25/11/2024 06:32:56 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 = '94183' 25/11/2024 06:32:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '94183' 25/11/2024 06:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94183' , '7109' , 'NOVENA ALL\'IMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 25/11/2024 06:45:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3644' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 06:45:58 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' , '3644' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '118.00' , '96.72' , NOW() , NOW() ) 25/11/2024 06:45: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 = '94491' 25/11/2024 06:45:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94491' 25/11/2024 06:45: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 ( '94491' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 25/11/2024 06:45: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 ( '94491' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.8' , '7.2131147540984' , '22' , '0' , '8.80' ) 25/11/2024 06:45: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 ( '94491' , '10475' , 'TEALIGHTS X 50 ' , '3' , '-3' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '11.70' ) 25/11/2024 06:45: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 ( '94491' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 25/11/2024 07:06:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3645' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-25') 25/11/2024 07:06:36 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' , '3645' , '2024-11-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.28' , '27.28' , NOW() , NOW() ) 25/11/2024 07:06:36 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 = '94492' 25/11/2024 07:06:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '94492' 25/11/2024 07:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94492' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 25/11/2024 07:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94492' , '23068' , 'PAROLA E PREGHIERA - GEN 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 25/11/2024 07:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94492' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 25/11/2024 07:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94492' , '23245' , 'PAROLA E PREGHIERA - FEB 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' )