13/12/2022 09:34:11 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 ( '32' , '1799' , '2022-11-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2475.20' , '2475.20' , NOW() , NOW() ) 13/12/2022 09:34:11 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 = '77233' 13/12/2022 09:34:11 am >> DELETE FROM ps_document_detail WHERE id_document = '77233' 13/12/2022 09:34:11 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 ( '77233' , '20267' , 'CRISTO SI E FATTO POVERO' , '150' , '0' , '4' , '2.5000' , '2.5' , '0' , '45' , '206.25' ) 13/12/2022 09:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20267' AND id_supplier = '79' 13/12/2022 09:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20267' , '79' , '1' ) 13/12/2022 09:34:11 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 ( '77233' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 13/12/2022 09:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 13/12/2022 09:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 13/12/2022 09:34:11 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 ( '77233' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 13/12/2022 09:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 13/12/2022 09:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 13/12/2022 09:34:11 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 ( '77233' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '30' , '18.90' ) 13/12/2022 09:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 13/12/2022 09:34:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 13/12/2022 09:34:11 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 ( '77233' , '13460' , 'VERITATIS GAUDIUM' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '45' , '2.75' ) 13/12/2022 09:34:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '13460' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13460' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '4' , '0' , '4' , '15.5000' , '15.5' , '0' , '30' , '43.40' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '0' , '4' , '130.0000' , '130' , '0' , '30' , '91.00' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17330' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17330' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '16.50' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '30' , '18.90' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '79' 13/12/2022 09:34:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '79' , '1' ) 13/12/2022 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5444' , 'IO SONO CON VOI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '0' , '550.00' ) 13/12/2022 09:34:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 13/12/2022 09:34:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 13/12/2022 09:34:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '11193' , 'VENITE CON ME CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '0' , '550.00' ) 13/12/2022 09:34:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 13/12/2022 09:34:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 13/12/2022 09:34:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '0' , '550.00' ) 13/12/2022 09:34:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 13/12/2022 09:34:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 13/12/2022 09:34:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 13/12/2022 09:34:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 13/12/2022 09:34:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 13/12/2022 09:34:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5765' , 'LEZIONARIO FERIALE TEMPI FORTI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 13/12/2022 09:34:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5765' AND id_supplier = '79' 13/12/2022 09:34:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5765' , '79' , '1' ) 13/12/2022 09:37:05 am >> UPDATE ps_document SET id_document_type = '33', document_num = '002712', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '1218.50', price_tax_excluded = '1218.50', date_upd = NOW() WHERE id_document = '75501' 13/12/2022 09:37:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75501' 13/12/2022 09:37:05 am >> DELETE FROM ps_document_detail WHERE id_document = '75501' 13/12/2022 09:37:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75501' , '5444' , 'IO SONO CON VOI - CAT.' , '100' , '100' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.0000' ) 13/12/2022 09:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 13/12/2022 09:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 13/12/2022 09:37:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75501' , '11193' , 'VENITE CON ME CAT.' , '100' , '100' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.0000' ) 13/12/2022 09:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 13/12/2022 09:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 13/12/2022 09:37:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75501' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '100' , '100' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.0000' ) 13/12/2022 09:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 13/12/2022 09:37:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 13/12/2022 09:37:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75501' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '30' , '24.5000' ) 13/12/2022 09:37:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 13/12/2022 09:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 13/12/2022 09:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75501' , '5765' , 'LEZIONARIO FERIALE TEMPI FORTI - TEMPO ORDINARIO' , '1' , '1' , '4' , '60.0000' , '60' , '0' , '35' , '39.0000' ) 13/12/2022 09:37:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5765' AND id_supplier = '' 13/12/2022 09:37:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5765' , '' , '1' ) 13/12/2022 09:38:04 am >> UPDATE ps_document SET id_document_type = '32', document_num = '1799', document_date = '2022-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '27.5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '1976.20', price_tax_excluded = '1976.20', date_upd = NOW() WHERE id_document = '77233' 13/12/2022 09:38:04 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 = '77233' 13/12/2022 09:38:04 am >> DELETE FROM ps_document_detail WHERE id_document = '77233' 13/12/2022 09:38:04 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 ( '77233' , '20267' , 'CRISTO SI E FATTO POVERO' , '150' , '0' , '4' , '2.5000' , '2.5' , '0' , '45' , '206.25' ) 13/12/2022 09:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '20267' AND id_supplier = '' 13/12/2022 09:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20267' , '' , '1' ) 13/12/2022 09:38:04 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 ( '77233' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 13/12/2022 09:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 13/12/2022 09:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 13/12/2022 09:38:04 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 ( '77233' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '42.00' ) 13/12/2022 09:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '' 13/12/2022 09:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '' , '1' ) 13/12/2022 09:38:04 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 ( '77233' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '30' , '18.90' ) 13/12/2022 09:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '' 13/12/2022 09:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '' , '1' ) 13/12/2022 09:38:04 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 ( '77233' , '13460' , 'VERITATIS GAUDIUM' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '45' , '2.75' ) 13/12/2022 09:38:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '13460' AND id_supplier = '' 13/12/2022 09:38:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13460' , '' , '1' ) 13/12/2022 09:38:04 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 ( '77233' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '4' , '0' , '4' , '15.5000' , '15.5' , '0' , '30' , '43.40' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '0' , '4' , '130.0000' , '130' , '0' , '30' , '91.00' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17330' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17330' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '35' , '58.50' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5774' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5774' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '16.50' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '30' , '18.90' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5444' , 'IO SONO CON VOI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 13/12/2022 09:38:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 13/12/2022 09:38:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 13/12/2022 09:38:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '11193' , 'VENITE CON ME CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 13/12/2022 09:38:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 13/12/2022 09:38:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 13/12/2022 09:38:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '100' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '385.00' ) 13/12/2022 09:38:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 13/12/2022 09:38:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 13/12/2022 09:38:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 13/12/2022 09:38:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '' 13/12/2022 09:38:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '' , '1' ) 13/12/2022 09:38:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77233' , '5765' , 'LEZIONARIO FERIALE TEMPI FORTI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 13/12/2022 09:38:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '5765' AND id_supplier = '' 13/12/2022 09:38:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5765' , '' , '1' ) 13/12/2022 09:48: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 ( '31' , '20844/00/2022' , '2022-12-09' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '441.00' , '441.00' , NOW() , NOW() ) 13/12/2022 09:48: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 = '77234' 13/12/2022 09:48:56 am >> DELETE FROM ps_document_detail WHERE id_document = '77234' 13/12/2022 09:48: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 ( '77234' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '145' , '145' , '4' , '5.00' , '5' , '0' , '40' , '435.0000' ) 13/12/2022 09:48:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '38' 13/12/2022 09:48:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '38' , '1' ) 13/12/2022 09:48: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 ( '77234' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 13/12/2022 09:48:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '38' 13/12/2022 09:48:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '38' , '1' ) 13/12/2022 10:00:41 am >> DELETE FROM ps_product WHERE id_product = '23' 13/12/2022 10:00:41 am >> DELETE FROM ps_product_shop WHERE id_product = '23' 13/12/2022 10:00:41 am >> DELETE FROM ps_product_lang WHERE id_product = '23' 13/12/2022 10:00:41 am >> DELETE FROM ps_stock_available WHERE id_product = '23' 13/12/2022 10:20:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 10:20:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3840' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '22.50' , NOW() , NOW() ) 13/12/2022 10:20:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77235' 13/12/2022 10:20:24 am >> DELETE FROM ps_document_detail WHERE id_document = '77235' 13/12/2022 10:20:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77235' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '4' , '-4' , '4' , '4.5' , '4.5' , '0' , '0' , '18.00' ) 13/12/2022 10:20:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6619' AND id_supplier = '' 13/12/2022 10:20:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6619' , '' , '1' ) 13/12/2022 10:20:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77235' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 13/12/2022 10:20:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 13/12/2022 10:20:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 13/12/2022 11:02:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 11:02:11 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' , '3841' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '800.00' , '655.74' , NOW() , NOW() ) 13/12/2022 11:02:11 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 = '77236' 13/12/2022 11:02:11 am >> DELETE FROM ps_document_detail WHERE id_document = '77236' 13/12/2022 11:02:11 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 ( '77236' , '19865' , 'CASULA CROCE ELICA - CSL080V' , '4' , '-4' , '1' , '200' , '163.93442622951' , '22' , '0' , '800.00' ) 13/12/2022 11:02:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19865' AND id_supplier = '' 13/12/2022 11:02:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19865' , '' , '1' ) 13/12/2022 12:02:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553476' AND id_product != '19291' AND ean13 != '' 13/12/2022 12:02:47 pm >> UPDATE ps_product SET id_supplier = '7', reference = '4/3', ean13 = '9788831553476', date_upd = NOW() WHERE id_product = '19291' 13/12/2022 12:02:47 pm >> UPDATE ps_product_lang SET name = 'VANGELO DELLA PRIMA COMUNIONE', description = '' WHERE id_product = '19291' 13/12/2022 12:02:47 pm >> UPDATE ps_product SET wholesale_price = '7.80', on_sale = '0', price = '12.0000' WHERE id_product = '19291' 13/12/2022 12:02:47 pm >> UPDATE ps_product_shop SET wholesale_price = '7.80', price = '12.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19291' 13/12/2022 12:02:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19291' 13/12/2022 12:12:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 12:12:34 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' , '3842' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.75' , '63.99' , NOW() , NOW() ) 13/12/2022 12:12:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77237' 13/12/2022 12:12:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77237' 13/12/2022 12:12:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77237' , '20006' , 'FASCINO DEL MALE - G. CUCCI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 13/12/2022 12:12:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20006' AND id_supplier = '' 13/12/2022 12:12:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20006' , '' , '1' ) 13/12/2022 12:12:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77237' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:12:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '' 13/12/2022 12:12:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '' , '1' ) 13/12/2022 12:12:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77237' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 13/12/2022 12:12:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 13/12/2022 12:12:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 13/12/2022 12:12:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77237' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 13/12/2022 12:12:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 13/12/2022 12:12:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 13/12/2022 12:15:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 12:15:54 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' , '3843' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 13/12/2022 12:15:54 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 = '77238' 13/12/2022 12:15:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '77238' 13/12/2022 12:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77238' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 13/12/2022 12:15:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 13/12/2022 12:15:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 13/12/2022 12:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77238' , '5536' , 'LACCIO' , '3' , '-3' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.50' ) 13/12/2022 12:15:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5536' AND id_supplier = '' 13/12/2022 12:15:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5536' , '' , '1' ) 13/12/2022 12:35:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 12:35:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3844' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 13/12/2022 12:35:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77239' 13/12/2022 12:35:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '77239' 13/12/2022 12:35:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77239' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 13/12/2022 12:35:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13142' AND id_supplier = '' 13/12/2022 12:35:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13142' , '' , '1' ) 13/12/2022 12:35:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77239' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 13/12/2022 12:35:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/12/2022 12:35:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/12/2022 12:39:11 pm >> DELETE FROM ps_product WHERE id_product = '998' 13/12/2022 12:39:11 pm >> DELETE FROM ps_product_shop WHERE id_product = '998' 13/12/2022 12:39:11 pm >> DELETE FROM ps_product_lang WHERE id_product = '998' 13/12/2022 12:39:11 pm >> DELETE FROM ps_stock_available WHERE id_product = '998' 13/12/2022 12:40:01 pm >> DELETE FROM ps_product WHERE id_product = '3665' 13/12/2022 12:40:01 pm >> DELETE FROM ps_product_shop WHERE id_product = '3665' 13/12/2022 12:40:01 pm >> DELETE FROM ps_product_lang WHERE id_product = '3665' 13/12/2022 12:40:01 pm >> DELETE FROM ps_stock_available WHERE id_product = '3665' 13/12/2022 12:42:09 pm >> DELETE FROM ps_product WHERE id_product = '4797' 13/12/2022 12:42:09 pm >> DELETE FROM ps_product_shop WHERE id_product = '4797' 13/12/2022 12:42:09 pm >> DELETE FROM ps_product_lang WHERE id_product = '4797' 13/12/2022 12:42:09 pm >> DELETE FROM ps_stock_available WHERE id_product = '4797' 13/12/2022 12:46:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '6/PA' AND id_document != '76096' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 12:46:36 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '6/PA', document_date = '2022-12-13', document_letter = 'PA', id_customer = '3965', id_supplier = '0', id_address = '4677719', address1 = 'PIAZZA GARIBALDI 84020 OLIVETO CITRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '435.04', price_tax_excluded = '435.04', date_upd = NOW() WHERE id_document = '76096' 13/12/2022 12:46: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 = '76096' 13/12/2022 12:46:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '76096' 13/12/2022 12:46: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 ( '76096' , '20277' , 'Grand Central dream' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/12/2022 12:46: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 ( '76096' , '20278' , 'Violenze e fascismo nel napoletano' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:46: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 ( '76096' , '20279' , 'Heinrich Schliemann a Napoli' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:46: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 ( '76096' , '20280' , 'C’era una volta Storybrooke' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/12/2022 12:46: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 ( '76096' , '20281' , 'Bibliografia degli scritti' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 13/12/2022 12:46: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 ( '76096' , '20285' , 'Quid est veritas?' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 13/12/2022 12:46: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 ( '76096' , '20283' , 'conquista normanna del meridione d’Italia' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/12/2022 12:46: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 ( '76096' , '20284' , 'bizantini nel Mezzogiorno d’Italia' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/12/2022 12:46: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 ( '76096' , '20286' , 'Chirone d’Achille' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/12/2022 12:46: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 ( '76096' , '20287' , 'geopolitica di Francesco' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 13/12/2022 12:46: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 ( '76096' , '20288' , 'Codice Corallino' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/12/2022 12:46: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 ( '76096' , '20289' , 'Folia Follia' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 13/12/2022 12:46: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 ( '76096' , '20290' , 'Raffaella Carrà una leggenda in tre minuti' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/12/2022 12:46: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 ( '76096' , '20291' , 'Futurvesuvio' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:46: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 ( '76096' , '20292' , 'A vita nova' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 13/12/2022 12:46: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 ( '76096' , '20282' , 'Storia politica della Langobardia minore' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/12/2022 12:46: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 ( '76096' , '20295' , 'GUIDA PER BAMBINE RIBELLI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 13/12/2022 12:46: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 ( '76096' , '20294' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI ' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20293' , 'Storie della buona notte PER BAMBINE RIBELLI 2' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20297' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 DONNE...' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20296' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 RAGAZZE...' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20298' , 'COFANETTO STORIE PER BAMBINI VOL 1 E 2' , '1' , '-1' , '4' , '29.9000' , '29.9' , '0' , '5' , '28.40' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20299' , 'DONNE E SCIENZA' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '14693' , 'VITE MERAVIGLIOSE - P. MARTINELLI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '11838' , 'UNA TERRA BAGNATA DAL SANGUE - A. PALINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '10052' , 'SOLE A MEZZANOTTE M. GARGANI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '20300' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '8.6600' , '8.66' , '0' , '5' , '8.23' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '0' , 'Determina affidamento n. 104/799 del 14/11.2022' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '0' , 'CUP D89I22000860001 ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/12/2022 12:46:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76096' , '0' , 'CIG: Z37389282E' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/12/2022 01:12:39 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3965' 13/12/2022 01:12:39 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 ( '3965' , '10' , '210' , 'COMUNE DI OLIVETO CITRA ' , 'Uff_eFatturaPA' , '' , 'VIA VITTORIO EMANUELE II' , '' , '84020' , 'OLIVETO CITRA' , '' , '0828799214' , '3341279577' , '' , '00578180655' , NOW() , NOW() ) 13/12/2022 01:12:39 pm >> UPDATE ps_customer SET email = 'socioculturale@comune.oliveto-citra.sa.it', sdi = 'UF8EUN', pec = 'urp.oliveto-citra@asmepec.it', date_upd = NOW() WHERE id_customer = '3965' 13/12/2022 02:25:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400029246' AND id_product != '9688' AND ean13 != '' 13/12/2022 02:25:05 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '8058400029246', date_upd = NOW() WHERE id_product = '9688' 13/12/2022 02:25:05 pm >> UPDATE ps_product_lang SET name = 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ', description = '' WHERE id_product = '9688' 13/12/2022 02:25:05 pm >> UPDATE ps_product SET wholesale_price = '1.19', on_sale = '0', price = '2.377049180327869' WHERE id_product = '9688' 13/12/2022 02:25:05 pm >> UPDATE ps_product_shop SET wholesale_price = '1.19', price = '2.377049180327869', id_tax_rules_group = '1', id_category_default = '95', 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 = '9688' 13/12/2022 02:25:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '9688' 13/12/2022 02:25:47 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/12/2022 02:25:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20503' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 02:25:47 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20503' , '1' , '1' , '2' , NOW() , NOW() ) 13/12/2022 02:25:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20503' , '0' , '1' , '0' , '0' ) 13/12/2022 02:26:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327830' AND id_product != '20503' AND ean13 != '' 13/12/2022 02:26:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400327830', date_upd = NOW() WHERE id_product = '20503' 13/12/2022 02:26:20 pm >> UPDATE ps_product_lang SET name = 'CROCE PLEX - 3882', description = '' WHERE id_product = '20503' 13/12/2022 02:26:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20503' 13/12/2022 02:26:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '95', 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 = '20503' 13/12/2022 02:26:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '20503' 13/12/2022 02:27:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327830' AND id_product != '20503' AND ean13 != '' 13/12/2022 02:27:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400327830', date_upd = NOW() WHERE id_product = '20503' 13/12/2022 02:27:26 pm >> UPDATE ps_product_lang SET name = 'CROCE PLEX - 3882', description = '' WHERE id_product = '20503' 13/12/2022 02:27:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '20503' 13/12/2022 02:27:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '95', 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 = '20503' 13/12/2022 02:27:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '20503' 13/12/2022 02:27:44 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 = '20503' 13/12/2022 02:27:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20504' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 02:27:44 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 '20504' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20503' 13/12/2022 02:27:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20504' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20503' 13/12/2022 02:28:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327656' AND id_product != '20504' AND ean13 != '' 13/12/2022 02:28:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400327656', date_upd = NOW() WHERE id_product = '20504' 13/12/2022 02:28:23 pm >> UPDATE ps_product_lang SET name = 'CROCE PLEX - 3886', description = '' WHERE id_product = '20504' 13/12/2022 02:28:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '20504' 13/12/2022 02:28:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '95', 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 = '20504' 13/12/2022 02:28:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '20504' 13/12/2022 02:28:26 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 = '20504' 13/12/2022 02:28:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20505' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 02:28:26 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 '20505' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20504' 13/12/2022 02:28:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20505' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20504' 13/12/2022 02:31:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000415' AND id_product != '935' AND ean13 != '' 13/12/2022 02:31:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000415', date_upd = NOW() WHERE id_product = '935' 13/12/2022 02:31:23 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 7,5 DIPINTO - P3', description = '' WHERE id_product = '935' 13/12/2022 02:31:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8852459016393441' WHERE id_product = '935' 13/12/2022 02:31:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8852459016393441', id_tax_rules_group = '1', id_category_default = '95', 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 = '935' 13/12/2022 02:31:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '935' 13/12/2022 02:34:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400322125' AND id_product != '20505' AND ean13 != '' 13/12/2022 02:34:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400322125', date_upd = NOW() WHERE id_product = '20505' 13/12/2022 02:34:27 pm >> UPDATE ps_product_lang SET name = 'CARTONCINO SAGOMATO - P720', description = '' WHERE id_product = '20505' 13/12/2022 02:34:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '20505' 13/12/2022 02:34:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '95', 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 = '20505' 13/12/2022 02:34:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '20505' 13/12/2022 02:35: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 ( '31' , 'A5170' , '2022-12-13' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '-0.02' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '461.09' , '377.94' , NOW() , NOW() ) 13/12/2022 02:35: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 = '77240' 13/12/2022 02:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '77240' 13/12/2022 02:35: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 ( '77240' , '19320' , 'QUADRO PIASTRELLA 20X20 SACRA FAMIGLIA - 2189/I0102' , '2' , '2' , '1' , '9.064' , '7.4295081967213' , '22' , '0' , '22.1162' ) 13/12/2022 02:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19320' AND id_supplier = '28' 13/12/2022 02:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19320' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '6' , '6' , '1' , '2.3835' , '1.9536885245902' , '22' , '0' , '17.4472' ) 13/12/2022 02:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '28' 13/12/2022 02:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '50' , '50' , '1' , '1.1880' , '0.97377049180328' , '22' , '0' , '72.4680' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '18276' , 'CINGOLO CON NODI - 3280' , '100' , '100' , '1' , '0.99' , '0.81147540983607' , '22' , '0' , '120.7800' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18276' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18276' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '20503' , 'CROCE PLEX - 3882' , '1' , '1' , '1' , '13.65' , '11.188524590164' , '22' , '0' , '16.6530' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20503' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20503' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '20504' , 'CROCE PLEX - 3886' , '1' , '1' , '1' , '14.7' , '12.049180327869' , '22' , '0' , '17.9340' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20504' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20504' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '500' , '500' , '1' , '0.0832' , '0.068196721311475' , '22' , '0' , '50.7520' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '5' , '5' , '1' , '1.6060' , '1.316393442623' , '22' , '0' , '9.7966' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '5' , '5' , '1' , '2.6180' , '2.1459016393443' , '22' , '0' , '15.9698' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15089' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15089' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '50' , '50' , '1' , '0.8712' , '0.71409836065574' , '22' , '0' , '53.1432' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '935' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '935' , '28' , '1' ) 13/12/2022 02:35: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 ( '77240' , '20505' , 'CARTONCINO SAGOMATO - P720' , '200' , '200' , '1' , '0.2625' , '0.21516393442623' , '22' , '0' , '64.0500' ) 13/12/2022 02:35:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20505' AND id_supplier = '28' 13/12/2022 02:35:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20505' , '28' , '1' ) 13/12/2022 02:35:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400322125' AND id_product != '20505' AND ean13 != '' 13/12/2022 02:35:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400322125', date_upd = NOW() WHERE id_product = '20505' 13/12/2022 02:35:46 pm >> UPDATE ps_product_lang SET name = 'CARTONCINO SAGOMATO - P720', description = '' WHERE id_product = '20505' 13/12/2022 02:35:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '20505' 13/12/2022 02:35:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '95', 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 = '20505' 13/12/2022 02:35:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '20505' 13/12/2022 02:35:47 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 = '20505' 13/12/2022 02:35:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20506' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 02:35:47 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 '20506' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20505' 13/12/2022 02:35:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20506' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20505' 13/12/2022 02:36:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839400079' AND id_product != '20414' AND ean13 != '' 13/12/2022 02:36:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839400079', date_upd = NOW() WHERE id_product = '20414' 13/12/2022 02:36:48 pm >> UPDATE ps_product_lang SET name = 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8', description = '' WHERE id_product = '20414' 13/12/2022 02:36:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98' WHERE id_product = '20414' 13/12/2022 02:36:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20414' 13/12/2022 02:36:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '20414' 13/12/2022 02:37: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 ( '33' , '2022000007048' , '2022-12-12' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '3' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.07' , '73.07' , NOW() , NOW() ) 13/12/2022 02:37: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 = '77241' 13/12/2022 02:37:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '77241' 13/12/2022 02:37: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 ( '77241' , '20414' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 13/12/2022 02:37:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20414' AND id_supplier = '107' 13/12/2022 02:37:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20414' , '107' , '1' ) 13/12/2022 02:40:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002081' AND id_product != '17287' AND ean13 != '' 13/12/2022 02:40:40 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '002081', date_upd = NOW() WHERE id_product = '17287' 13/12/2022 02:40:40 pm >> UPDATE ps_product_lang SET name = 'CAPOCULLA 7X9', description = '' WHERE id_product = '17287' 13/12/2022 02:40:40 pm >> UPDATE ps_product SET wholesale_price = '5.50', on_sale = '0', price = '11.885245901639344' WHERE id_product = '17287' 13/12/2022 02:40:40 pm >> UPDATE ps_product_shop SET wholesale_price = '5.50', price = '11.885245901639344', id_tax_rules_group = '1', id_category_default = '120', 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 = '17287' 13/12/2022 02:40:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '17287' 13/12/2022 02:40:43 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 = '17287' 13/12/2022 02:40:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20507' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 02:40:43 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 '20507' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '17287' 13/12/2022 02:40:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20507' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '17287' 13/12/2022 02:44:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '7290000098784' AND id_product != '16793' AND ean13 != '' 13/12/2022 02:44:06 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '7290000098784', date_upd = NOW() WHERE id_product = '16793' 13/12/2022 02:44:06 pm >> UPDATE ps_product_lang SET name = 'SOPRACULLA 9X13', description = '' WHERE id_product = '16793' 13/12/2022 02:44:07 pm >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '13.1148' WHERE id_product = '16793' 13/12/2022 02:44:07 pm >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '13.1148', id_tax_rules_group = '1', id_category_default = '120', 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 = '16793' 13/12/2022 02:44:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '16793' 13/12/2022 02:45:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8030913587246' AND id_product != '20507' AND ean13 != '' 13/12/2022 02:45:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8030913587246', date_upd = NOW() WHERE id_product = '20507' 13/12/2022 02:45:19 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL', description = '' WHERE id_product = '20507' 13/12/2022 02:45:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.950819672131146' WHERE id_product = '20507' 13/12/2022 02:45:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.950819672131146', id_tax_rules_group = '1', id_category_default = '120', 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 = '20507' 13/12/2022 02:45:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '20507' 13/12/2022 02:46:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8030913587246' AND id_product != '20507' AND ean13 != '' 13/12/2022 02:46:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8030913587246', date_upd = NOW() WHERE id_product = '20507' 13/12/2022 02:46:41 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL', description = '' WHERE id_product = '20507' 13/12/2022 02:46:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.950819672131146' WHERE id_product = '20507' 13/12/2022 02:46:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.950819672131146', id_tax_rules_group = '1', id_category_default = '120', 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 = '20507' 13/12/2022 02:46:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20507' 13/12/2022 02:48:54 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' , '1/5884' , '2022-12-13' , '5884' , '0' , '6' , '2601' , 'ZONO ASI SUD - CENTRO ORAFO \\\"IL TARÍ\\\" 81025 MARCIANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '67.10' , '55.00' , NOW() , NOW() ) 13/12/2022 02:48:54 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 = '77242' 13/12/2022 02:48:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '77242' 13/12/2022 02:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77242' , '17287' , 'CAPOCULLA 7X9' , '2' , '2' , '1' , '6' , '4.9180327868852' , '22' , '0' , '14.6400' ) 13/12/2022 02:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17287' AND id_supplier = '6' 13/12/2022 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17287' , '6' , '1' ) 13/12/2022 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77242' , '16793' , 'SOPRACULLA' , '1' , '1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '8.5400' ) 13/12/2022 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16793' AND id_supplier = '6' 13/12/2022 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16793' , '6' , '1' ) 13/12/2022 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77242' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '10.9800' ) 13/12/2022 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '6' 13/12/2022 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '6' , '1' ) 13/12/2022 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77242' , '20507' , 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '10.9800' ) 13/12/2022 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20507' AND id_supplier = '6' 13/12/2022 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20507' , '6' , '1' ) 13/12/2022 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77242' , '17290' , 'SPILLA PORTACIUCCIO' , '3' , '3' , '1' , '6' , '4.9180327868852' , '22' , '0' , '21.9600' ) 13/12/2022 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17290' AND id_supplier = '6' 13/12/2022 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17290' , '6' , '1' ) 13/12/2022 03:15:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '37' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 03:15:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '37' , '2022-12-13' , '' , '3812' , '0' , '4672633' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.46' , NOW() , NOW() ) 13/12/2022 03:15:32 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 = '77243' 13/12/2022 03:15:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77243' 13/12/2022 03:15: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 ( '77243' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 13/12/2022 03:15:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 03:15:57 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' , '3845' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 13/12/2022 03:15:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77244' 13/12/2022 03:15:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '77244' 13/12/2022 03:15:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77244' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 13/12/2022 03:15:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 13/12/2022 03:15:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 13/12/2022 03:27:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 03:27: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' , '3846' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.60' , '51.60' , NOW() , NOW() ) 13/12/2022 03:27: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 = '77245' 13/12/2022 03:27:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '77245' 13/12/2022 03:27: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 ( '77245' , '5592' , 'LECTIO DIVINA OGNI GIORNO - 2' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.83' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5592' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5592' , '' , '1' ) 13/12/2022 03:27: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 ( '77245' , '18376' , 'NOSTALGIA DEL PANE - L. EPICOCO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18376' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18376' , '' , '1' ) 13/12/2022 03:27: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 ( '77245' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '' , '1' ) 13/12/2022 03:27: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 ( '77245' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 13/12/2022 03:27: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 ( '77245' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' ) 13/12/2022 03:27: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 ( '77245' , '18385' , 'LETTERA A GESU NEL DESERTO - T. BELLO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 13/12/2022 03:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18385' AND id_supplier = '' 13/12/2022 03:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18385' , '' , '1' ) 13/12/2022 03:37: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' , '2022000007048' , '2022-12-12' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '3' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.07' , '73.07' , NOW() , NOW() ) 13/12/2022 03:37: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 = '77246' 13/12/2022 03:37:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '77246' 13/12/2022 03:37: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 ( '77246' , '20414' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8' , '1' , '1' , '4' , '98.00' , '98' , '0' , '28.5' , '70.0700' ) 13/12/2022 03:37:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20414' AND id_supplier = '107' 13/12/2022 03:37:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20414' , '107' , '1' ) 13/12/2022 03:40:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 13/12/2022 03:40:48 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '84.70', price_tax_excluded = '84.70', date_upd = NOW() WHERE id_document = '61794' 13/12/2022 03:40: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 = '61794' 13/12/2022 03:40:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 13/12/2022 03:40: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 ( '61794' , '20441' , 'AMEN - GEN. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 13/12/2022 03:40:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20441' AND id_supplier = '' 13/12/2022 03:40:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20441' , '' , '1' ) 13/12/2022 03:40: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 ( '61794' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 13/12/2022 03:40:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20440' AND id_supplier = '' 13/12/2022 03:40:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20440' , '' , '1' ) 13/12/2022 03:40: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 ( '61794' , '20443' , 'PAROLA E PREGHIERA - GEN. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 13/12/2022 03:40:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20443' AND id_supplier = '' 13/12/2022 03:40:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20443' , '' , '1' ) 13/12/2022 03:40:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 13/12/2022 03:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20462' AND id_supplier = '' 13/12/2022 03:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20462' , '' , '1' ) 13/12/2022 03:40:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 13/12/2022 03:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '' 13/12/2022 03:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '' , '1' ) 13/12/2022 03:40:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '20492' , 'AMORE IN UNO SGUARDO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 13/12/2022 03:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20492' AND id_supplier = '' 13/12/2022 03:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20492' , '' , '1' ) 13/12/2022 03:40:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '16980' , 'MARIA PRIMO AMORE DEL MONDO - F. SHEEN' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 13/12/2022 03:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16980' AND id_supplier = '' 13/12/2022 03:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16980' , '' , '1' ) 13/12/2022 03:44:38 pm >> DELETE FROM ps_document WHERE id_document = '77241' 13/12/2022 03:44:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '77241' 13/12/2022 03:48:30 pm >> 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('2022-12-13') 13/12/2022 03:48:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '20/L' , '2022-12-13' , 'L' , '3832' , '0' , '4673199' , 'PIAZZA S. ALFONSO 1 84016 PAGANI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1606.00' , '1606.00' , NOW() , NOW() ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77247' 13/12/2022 03:48:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '77247' 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20401' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 1' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20402' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 2' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20403' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 3' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20404' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 4' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20405' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 5' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20406' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 6' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20407' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 7' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20414' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20415' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 9' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20408' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 10' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20416' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20409' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 12' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20410' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 13' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20411' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 14' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20412' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 15' , '1' , '-1' , '4' , '98.00' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20413' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 16 indici' , '1' , '-1' , '4' , '136.00' , '136' , '0' , '0' , '136.00' ) 13/12/2022 03:48:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '' , 'FONDO EMERGENZA IMPRESE - BIBLIOTECHE anno 2022 DECRETO MINISTERIALE rep. 8 del 14/01/2022' , '0' , '0' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 13/12/2022 03:54:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3832' 13/12/2022 03:54:03 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 ( '3832' , '10' , '210' , 'ENTE PROV. NAPOLETANA CONG. SS. REDENTORE - BIBLIOTECA S.ALFONSO' , '' , '' , 'PIAZZA S. ALFONSO 1' , '' , '84016' , 'PAGANI' , 'Apollonia Califano - 3476032052\r\nBIBLIOTECA S. ALFONSO' , '' , '' , '' , '80044080630' , NOW() , NOW() ) 13/12/2022 03:54:03 pm >> UPDATE ps_customer SET email = 'bibliotecasantalfonso.pagani@redentoristi.it', sdi = '0000000', pec = 'bibliotecasantalfonso.pagani@pec.it', date_upd = NOW() WHERE id_customer = '3832' 13/12/2022 03:54:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/L' AND id_document != '77247' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 03:54:32 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '20/L', document_date = '2022-12-13', document_letter = 'L', id_customer = '3832', id_supplier = '0', id_address = '4677903', address1 = 'PIAZZA S. ALFONSO 1 84016 PAGANI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1606.00', price_tax_excluded = '1606.00', date_upd = NOW() WHERE id_document = '77247' 13/12/2022 03:54:32 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 = '77247' 13/12/2022 03:54:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '77247' 13/12/2022 03:54: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 ( '77247' , '20401' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 1' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54: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 ( '77247' , '20402' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 2' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54: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 ( '77247' , '20403' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 3' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54: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 ( '77247' , '20404' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 4' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20405' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 5' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20406' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 6' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20407' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 7' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20414' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 8' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20415' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 9' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20408' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 10' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20416' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20409' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 12' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20410' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 13' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20411' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 14' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20412' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 15' , '1' , '-1' , '4' , '98.0000' , '98' , '0' , '0' , '98.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '20413' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 16 indici' , '1' , '-1' , '4' , '136.0000' , '136' , '0' , '0' , '136.00' ) 13/12/2022 03:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77247' , '0' , 'FONDO EMERGENZA IMPRESE - BIBLIOTECHE anno 2022 DECRETO MINISTERIALE rep. 8 del 14/01/2022' , '0' , '0' , '4' , '0.0000' , '0' , '0' , '0' , '0.00' ) 13/12/2022 04:17:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '76115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-06') 13/12/2022 04:17:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '109/A', document_date = '2022-12-06', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA SAN LEONARDO', 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 = '210.40', price_tax_excluded = '175.37', date_upd = NOW() WHERE id_document = '76115' 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76115' 13/12/2022 04:17:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '76115' 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '25' , '-25' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '75.00' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19151' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19151' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/12/2022 04:17:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76115' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/12/2022 04:17:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/12/2022 04:17:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/12/2022 04:20:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 04:20: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' , '3847' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.80' , '77.42' , NOW() , NOW() ) 13/12/2022 04:20: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 = '77248' 13/12/2022 04:20:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '77248' 13/12/2022 04:20: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 ( '77248' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 13/12/2022 04:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 13/12/2022 04:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 13/12/2022 04:20: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 ( '77248' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 13/12/2022 04:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 13/12/2022 04:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 13/12/2022 04:31:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/12/2022 04:31:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20508' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 04:31:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20508' , '1' , '1' , '2' , NOW() , NOW() ) 13/12/2022 04:31:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20508' , '0' , '1' , '0' , '0' ) 13/12/2022 04:33:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002082' AND id_product != '20508' AND ean13 != '' 13/12/2022 04:33:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002082', date_upd = NOW() WHERE id_product = '20508' 13/12/2022 04:33:18 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO 30CM - E62/30', description = '' WHERE id_product = '20508' 13/12/2022 04:33:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '129.5081967213115' WHERE id_product = '20508' 13/12/2022 04:33:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '129.5081967213115', id_tax_rules_group = '1', id_category_default = '461', 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 = '20508' 13/12/2022 04:33:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '20508' 13/12/2022 04:33:20 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 = '20508' 13/12/2022 04:33:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20509' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 04:33:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20509' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20508' 13/12/2022 04:33:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20509' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20508' 13/12/2022 04:34:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002083' AND id_product != '20509' AND ean13 != '' 13/12/2022 04:34:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002083', date_upd = NOW() WHERE id_product = '20509' 13/12/2022 04:34:15 pm >> UPDATE ps_product_lang SET name = 'BAMBINO PASTA DI LEGNO CM40 - AC289N/40', description = '' WHERE id_product = '20509' 13/12/2022 04:34:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '532.7868852459017' WHERE id_product = '20509' 13/12/2022 04:34:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '532.7868852459017', id_tax_rules_group = '1', id_category_default = '461', 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 = '20509' 13/12/2022 04:34:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '20509' 13/12/2022 04:34:19 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 = '20509' 13/12/2022 04:34:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20510' , '1' , '' , 'nuovo-prodotto' ) 13/12/2022 04:34:19 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 '20510' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20509' 13/12/2022 04:34:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20510' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20509' 13/12/2022 04:34:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002084' AND id_product != '20510' AND ean13 != '' 13/12/2022 04:34:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002084', date_upd = NOW() WHERE id_product = '20510' 13/12/2022 04:34:42 pm >> UPDATE ps_product_lang SET name = 'CULLA CM 35', description = '' WHERE id_product = '20510' 13/12/2022 04:34:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.508196721311474' WHERE id_product = '20510' 13/12/2022 04:34:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.508196721311474', id_tax_rules_group = '1', id_category_default = '461', 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 = '20510' 13/12/2022 04:34:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20510' 13/12/2022 04:35:12 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' , '441/00' , '2022-12-07' , '00' , '0' , '136' , '4670814' , 'VIA LIBERO GRASSI, 6b 40036 RIOVEGGIO - MONZUNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '403.33' , '330.60' , NOW() , NOW() ) 13/12/2022 04:35: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 = '77249' 13/12/2022 04:35:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '77249' 13/12/2022 04:35: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 ( '77249' , '20508' , 'BAMBINELLO 30CM - E62/30' , '1' , '1' , '1' , '65' , '53.27868852459' , '22' , '5' , '75.3350' ) 13/12/2022 04:35:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20508' AND id_supplier = '136' 13/12/2022 04:35:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20508' , '136' , '1' ) 13/12/2022 04:35: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 ( '77249' , '20509' , 'BAMBINO PASTA DI LEGNO CM40 - AC289N/40' , '1' , '1' , '1' , '268' , '219.67213114754' , '22' , '5' , '310.6120' ) 13/12/2022 04:35:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20509' AND id_supplier = '136' 13/12/2022 04:35:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20509' , '136' , '1' ) 13/12/2022 04:35: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 ( '77249' , '20510' , 'CULLA CM 35' , '1' , '1' , '1' , '15' , '12.295081967213' , '22' , '5' , '17.3850' ) 13/12/2022 04:35:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20510' AND id_supplier = '136' 13/12/2022 04:35:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20510' , '136' , '1' ) 13/12/2022 04:43:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '113/A' AND id_document != '77243' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 04:43:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '113/A', document_date = '2022-12-13', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4672633', 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 = '14.00', price_tax_excluded = '13.46', date_upd = NOW() WHERE id_document = '77243' 13/12/2022 04:43:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77243' 13/12/2022 04:43:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '77243' 13/12/2022 04:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77243' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 13/12/2022 04:43:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 13/12/2022 04:43:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 13/12/2022 05:04:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 05:04:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3848' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 13/12/2022 05:04:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77250' 13/12/2022 05:04:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '77250' 13/12/2022 05:04:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77250' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 13/12/2022 05:04:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 13/12/2022 05:04:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 13/12/2022 05:40:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 05:40: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' , '3849' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 13/12/2022 05:40: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 = '77251' 13/12/2022 05:40:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '77251' 13/12/2022 05:40: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 ( '77251' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 13/12/2022 05:40:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 13/12/2022 05:40:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 13/12/2022 05:53:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862447706' AND id_product != '15816' AND ean13 != '' 13/12/2022 05:53:55 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/4', ean13 = '9788862447706', date_upd = NOW() WHERE id_product = '15816' 13/12/2022 05:53:55 pm >> UPDATE ps_product_lang SET name = 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ', description = '' WHERE id_product = '15816' 13/12/2022 05:53:55 pm >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '15816' 13/12/2022 05:53:55 pm >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '267', 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 = '15816' 13/12/2022 05:53:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '15816' 13/12/2022 06:14:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3850' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 06:14:22 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' , '3850' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 13/12/2022 06:14:22 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 = '77252' 13/12/2022 06:14:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '77252' 13/12/2022 06:14:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77252' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 13/12/2022 06:14:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20472' AND id_supplier = '' 13/12/2022 06:14:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20472' , '' , '1' ) 13/12/2022 06:15:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 06:15: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' , '3851' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '71.39' , NOW() , NOW() ) 13/12/2022 06:15: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 = '77253' 13/12/2022 06:15:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '77253' 13/12/2022 06:15: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 ( '77253' , '20147' , 'LAMPADA A SFERA AZZURRA - 049DK' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 13/12/2022 06:15:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20147' AND id_supplier = '' 13/12/2022 06:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20147' , '' , '1' ) 13/12/2022 06:15: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 ( '77253' , '17833' , 'LAMPADA SAN GIUSEPPE' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 13/12/2022 06:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17833' AND id_supplier = '' 13/12/2022 06:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17833' , '' , '1' ) 13/12/2022 06:15: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 ( '77253' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 13/12/2022 06:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 13/12/2022 06:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 13/12/2022 06:15: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 ( '77253' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 13/12/2022 06:15:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/12/2022 06:15:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 13/12/2022 06:21:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 06:21: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' , '3852' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 13/12/2022 06:21: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 = '77254' 13/12/2022 06:21:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '77254' 13/12/2022 06:21: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 ( '77254' , '15889' , 'CINGOLO ORO CANUTIGLIA' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 13/12/2022 06:21:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15889' AND id_supplier = '' 13/12/2022 06:21:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15889' , '' , '1' ) 13/12/2022 07:03:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 07:03:02 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' , '3853' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '10.12' , NOW() , NOW() ) 13/12/2022 07:03:02 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 = '77255' 13/12/2022 07:03:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77255' 13/12/2022 07:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77255' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 13/12/2022 07:03:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18005' AND id_supplier = '' 13/12/2022 07:03:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18005' , '' , '1' ) 13/12/2022 07:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77255' , '16124' , 'SAN GIOVANNI PAOLO II BABY - GP2-BB' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 13/12/2022 07:03:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16124' AND id_supplier = '' 13/12/2022 07:03:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16124' , '' , '1' ) 13/12/2022 07:03:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77255' , '13319' , 'VIVI LA VITA - 30' , '3' , '-3' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.45' ) 13/12/2022 07:03:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13319' AND id_supplier = '' 13/12/2022 07:03:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13319' , '' , '1' ) 13/12/2022 07:08:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-13') 13/12/2022 07:08:41 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' , '3854' , '2022-12-13' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 13/12/2022 07:08:41 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 = '77256' 13/12/2022 07:08:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '77256' 13/12/2022 07:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77256' , '17290' , 'SPILLA PORTACIUCCIO' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 13/12/2022 07:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17290' AND id_supplier = '' 13/12/2022 07:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17290' , '' , '1' ) 13/12/2022 07:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77256' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 13/12/2022 07:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 13/12/2022 07:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )