22/10/2024 09:13:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2945' AND id_document != '93495' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 22/10/2024 09:13:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2945', document_date = '2024-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.00', price_tax_excluded = '29.51', date_upd = NOW() WHERE id_document = '93495' 22/10/2024 09:13:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93495' 22/10/2024 09:13:30 am >> DELETE FROM ps_document_detail WHERE id_document = '93495' 22/10/2024 09:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93495' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '30' , '-30' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '18.00' ) 22/10/2024 09:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93495' , '21555' , 'CAPOCULLA SMALTATO CELESTE' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 22/10/2024 09:20:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 09:20:08 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' , '3127' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.10' , '5.82' , NOW() , NOW() ) 22/10/2024 09:20:08 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 = '93750' 22/10/2024 09:20:08 am >> DELETE FROM ps_document_detail WHERE id_document = '93750' 22/10/2024 09:20:08 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 ( '93750' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 22/10/2024 09:20:08 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 ( '93750' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '2' , '-2' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '5.80' ) 22/10/2024 09:21:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 22/10/2024 09:21:45 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4060' , '10' , '229' , 'PARROCCHIA DI CADEGLIOPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CA DEGLI OPPI DI OPPEANO ' , '' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 22/10/2024 09:21:45 am >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 22/10/2024 09:26:37 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 22/10/2024 09:26:37 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4060' , '10' , '229' , 'PARROCCHIA DI CA DEGLI OPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CA DEGLI OPPI DI OPPEANO ' , '' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 22/10/2024 09:26:37 am >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 22/10/2024 09:52:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 09:52:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3128' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.45' , '10.45' , NOW() , NOW() ) 22/10/2024 09:52:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93751' 22/10/2024 09:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '93751' 22/10/2024 09:52: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 ( '93751' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 22/10/2024 09:52: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 ( '93751' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/10/2024 09:53:11 am >> SELECT document_num FROM ps_document WHERE document_num = '3129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 09:53: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' , '3129' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 22/10/2024 09:53: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 = '93752' 22/10/2024 09:53:11 am >> DELETE FROM ps_document_detail WHERE id_document = '93752' 22/10/2024 09:53: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 ( '93752' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/10/2024 10:38:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063516' AND id_product != '3881' AND ean13 != '' 22/10/2024 10:38:57 am >> UPDATE ps_product SET id_supplier = '', reference = '2/1', ean13 = '9788801063516', date_upd = NOW() WHERE id_product = '3881' 22/10/2024 10:38:57 am >> UPDATE ps_product_lang SET name = 'ENTRIAMO NELLA STORIA DELLA SALVEZZA - GUIDA - PROGETTO EMMAUS', description = '' WHERE id_product = '3881' 22/10/2024 10:38:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '3881' 22/10/2024 10:38:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '171', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3881' 22/10/2024 10:38:57 am >> DELETE FROM ps_specific_price WHERE id_product = '3881' 22/10/2024 10:39:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037074' AND id_product != '3882' AND ean13 != '' 22/10/2024 10:39:05 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/1', ean13 = '9788801037074', date_upd = NOW() WHERE id_product = '3882' 22/10/2024 10:39:05 am >> UPDATE ps_product_lang SET name = 'ENTRIAMO NELLA STORIA DELLA SALVEZZA - PROGETTO EMMAUS', description = '' WHERE id_product = '3882' 22/10/2024 10:39:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '3882' 22/10/2024 10:39:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '171', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3882' 22/10/2024 10:39:05 am >> DELETE FROM ps_specific_price WHERE id_product = '3882' 22/10/2024 10:49:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 10:49:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3130' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 22/10/2024 10:49: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 = '93753' 22/10/2024 10:49:05 am >> DELETE FROM ps_document_detail WHERE id_document = '93753' 22/10/2024 10:49: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 ( '93753' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/10/2024 11:05:17 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3573' 22/10/2024 11:05:17 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3573' , '10' , '210' , 'PARR. SPIRITO SANTO E S. FILIPPO' , '' , '' , 'VIA RECCO 1' , '' , '84096' , 'MONTECORVINO ROVELLA' , '' , '' , '' , '' , '95006260657' , NOW() , NOW() ) 22/10/2024 11:05:17 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3573' 22/10/2024 11:38:03 am >> SELECT document_num FROM ps_document WHERE document_num = '172' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 11:38:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '172' , '2024-10-22' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '53.55' , '53.55' , NOW() , NOW() ) 22/10/2024 11:38:03 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 = '93754' 22/10/2024 11:38:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93754' 22/10/2024 11:38:03 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 ( '93754' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '21' , '-21' , '4' , '3.00' , '3' , '0' , '15' , '53.55' ) 22/10/2024 11:38:27 am >> SELECT document_num FROM ps_document WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 11:38:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '173' , '2024-10-22' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '102.00' , '102.00' , NOW() , NOW() ) 22/10/2024 11:38:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93755' 22/10/2024 11:38:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93755' 22/10/2024 11:38:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93755' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '15' , '102.00' ) 22/10/2024 11:49:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 11:49:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3131' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.00' , '98.20' , NOW() , NOW() ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93756' 22/10/2024 11:49:01 am >> DELETE FROM ps_document_detail WHERE id_document = '93756' 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 22/10/2024 11:49:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93756' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 22/10/2024 11:51:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2978' AND id_document != '93537' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-09') 22/10/2024 11:51:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2978', document_date = '2024-10-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '159.78', price_tax_excluded = '143.77', date_upd = NOW() WHERE id_document = '93537' 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93537' 22/10/2024 11:51:15 am >> DELETE FROM ps_document_detail WHERE id_document = '93537' 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '3' , '-3' , '1' , '13.5' , '11.065573770492' , '22' , '0' , '40.50' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '5' , '11.40' ) 22/10/2024 11:51:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 22/10/2024 11:51:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93537' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 22/10/2024 11:52:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 11:52:14 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' , '3132' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.45' , '16.80' , NOW() , NOW() ) 22/10/2024 11:52:14 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 = '93757' 22/10/2024 11:52:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93757' 22/10/2024 11:52:14 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 ( '93757' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/10/2024 11:52:14 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 ( '93757' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 22/10/2024 11:58:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 11:58:58 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' , '3133' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '211.72' , '211.72' , NOW() , NOW() ) 22/10/2024 11:58:58 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 = '93758' 22/10/2024 11:58:58 am >> DELETE FROM ps_document_detail WHERE id_document = '93758' 22/10/2024 11:58:58 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 ( '93758' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '32' , '-32' , '4' , '5.00' , '5' , '0' , '5' , '152.00' ) 22/10/2024 11:58:58 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 ( '93758' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '100' , '0.00' ) 22/10/2024 11:58:58 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 ( '93758' , '22875' , 'AMEN - DIC 24' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 22/10/2024 11:58:58 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 ( '93758' , '22876' , 'AMEN - NOV 24' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 22/10/2024 11:58:58 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 ( '93758' , '22754' , 'MESSA MEDITAZIONE - NOV/DIC 2024' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 22/10/2024 12:02:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/L' AND id_document != '93749' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-21') 22/10/2024 12:02:29 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/L', document_date = '2024-10-21', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA BATTIPAGLIA', 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 = '114.60', price_tax_excluded = '107.51', date_upd = NOW() WHERE id_document = '93749' 22/10/2024 12:02:29 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 = '93749' 22/10/2024 12:02:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93749' 22/10/2024 12:02:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '6.60' ) 22/10/2024 12:02:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/10/2024 12:02:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 22/10/2024 12:02:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/10/2024 12:02: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 ( '93749' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/10/2024 12:02: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 ( '93749' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/10/2024 12:02: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 ( '93749' , '0' , 'IMMAGINI' , '2' , '-2' , '3' , '7.0000' , '6.7307692307692' , '4' , '0' , '14.00' ) 22/10/2024 12:02: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 ( '93749' , '23060' , 'GIUBILEO DEI MALATI E DEI SOFFERENTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/10/2024 12:02: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 ( '93749' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 22/10/2024 12:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/L' AND id_document != '93749' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-21') 22/10/2024 12:05:17 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '19/L', document_date = '2024-10-21', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA BATTIPAGLIA', 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 = '114.60', price_tax_excluded = '105.53', date_upd = NOW() WHERE id_document = '93749' 22/10/2024 12:05:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93749' 22/10/2024 12:05:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '93749' 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '6.60' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '23060' , 'GIUBILEO DEI MALATI E DEI SOFFERENTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/10/2024 12:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93749' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 22/10/2024 12:23:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 12:23:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3134' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.90' , '22.90' , NOW() , NOW() ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93759' 22/10/2024 12:23:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93759' 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '3' , '-3' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '4.20' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.7' , '4.7' , '0' , '0' , '4.70' ) 22/10/2024 12:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93759' , '6014' , 'LUMINO BIANCO - 10B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 22/10/2024 12:59:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2921' AND id_document != '93462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-04') 22/10/2024 12:59:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2921', document_date = '2024-10-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.50', price_tax_excluded = '21.50', date_upd = NOW() WHERE id_document = '93462' 22/10/2024 12:59:09 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 = '93462' 22/10/2024 12:59:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93462' 22/10/2024 12:59:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93462' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '5' , '-5' , '4' , '4.3' , '4.3' , '0' , '0' , '21.50' ) 22/10/2024 12:59:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3134' AND id_document != '93759' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 12:59:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3134', document_date = '2024-10-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.90', price_tax_excluded = '22.90', date_upd = NOW() WHERE id_document = '93759' 22/10/2024 12:59: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 = '93759' 22/10/2024 12:59:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '93759' 22/10/2024 12:59: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 ( '93759' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '5.00' ) 22/10/2024 12:59: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 ( '93759' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 22/10/2024 12:59: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 ( '93759' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/10/2024 12:59: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 ( '93759' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '2.60' ) 22/10/2024 12:59: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 ( '93759' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 22/10/2024 12:59: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 ( '93759' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 22/10/2024 12:59: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 ( '93759' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '3' , '-3' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '4.20' ) 22/10/2024 12:59: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 ( '93759' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 22/10/2024 12:59: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 ( '93759' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '4.7' , '4.7' , '0' , '0' , '4.70' ) 22/10/2024 12:59: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 ( '93759' , '6014' , 'LUMINO BIANCO - 10B' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 22/10/2024 02:43:35 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/10/2024 02:43:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23085' , '1' , '' , 'nuovo-prodotto' ) 22/10/2024 02:43:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23085' , '1' , '1' , '2' , NOW() , NOW() ) 22/10/2024 02:43:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23085' , '0' , '1' , '0' , '0' ) 22/10/2024 02:45:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861390829' AND id_product != '23085' AND ean13 != '' 22/10/2024 02:45:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788861390829', date_upd = NOW() WHERE id_product = '23085' 22/10/2024 02:45:09 pm >> UPDATE ps_product_lang SET name = 'GESU\' INSEGNACI A PREGARE', description = '' WHERE id_product = '23085' 22/10/2024 02:45:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '23085' 22/10/2024 02:45:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '264', 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 = '23085' 22/10/2024 02:45:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '23085' 22/10/2024 02:45: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 = '23085' 22/10/2024 02:45:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23086' , '1' , '' , 'nuovo-prodotto' ) 22/10/2024 02:45:20 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 '23086' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23085' 22/10/2024 02:45:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23086' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23085' 22/10/2024 02:46: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 ( '31' , '29/003' , '2024-10-21' , '003' , '0' , '49' , '2644' , 'VIA DELLA STAZIONE, 23 01030 VITORCHIANO' , '' , '' , '7.5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '61.50' , '61.50' , NOW() , NOW() ) 22/10/2024 02:46: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 = '93760' 22/10/2024 02:46:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93760' 22/10/2024 02:46: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 ( '93760' , '23085' , 'GESU INSEGNACI A PREGARE' , '60' , '60' , '4' , '1.50' , '1.5' , '0' , '40' , '54.0000' ) 22/10/2024 02:46:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23085' AND id_supplier = '49' 22/10/2024 02:46:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23085' , '49' , '1' ) 22/10/2024 03:00:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609126' AND id_product != '23086' AND ean13 != '' 22/10/2024 03:00:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788826609126', date_upd = NOW() WHERE id_product = '23086' 22/10/2024 03:00:31 pm >> UPDATE ps_product_lang SET name = 'GLORIA DEI BUONI A NULLA - S. DETOC', description = '' WHERE id_product = '23086' 22/10/2024 03:00:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23086' 22/10/2024 03:00:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23086' 22/10/2024 03:00:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '23086' 22/10/2024 03:00:32 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 = '23086' 22/10/2024 03:00:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23087' , '1' , '' , 'nuovo-prodotto' ) 22/10/2024 03:00:32 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 '23087' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23086' 22/10/2024 03:00:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23087' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23086' 22/10/2024 03:02:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL003194' , '2024-10-21' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '178.45' , '178.45' , NOW() , NOW() ) 22/10/2024 03:02:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93761' 22/10/2024 03:02:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '93761' 22/10/2024 03:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93761' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '5' , '5' , '4' , '13.00' , '13' , '0' , '45' , '35.7500' ) 22/10/2024 03:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15024' AND id_supplier = '79' 22/10/2024 03:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15024' , '79' , '1' ) 22/10/2024 03:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93761' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '2' , '4' , '30.00' , '30' , '0' , '35' , '39.0000' ) 22/10/2024 03:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 22/10/2024 03:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 22/10/2024 03:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93761' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '2' , '4' , '40.00' , '40' , '0' , '35' , '52.0000' ) 22/10/2024 03:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 22/10/2024 03:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 22/10/2024 03:02:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93761' , '22507' , 'SPES NON CONFUNDIT' , '40' , '40' , '4' , '2.00' , '2' , '0' , '45' , '44.0000' ) 22/10/2024 03:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 22/10/2024 03:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 22/10/2024 03:02:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93761' , '23086' , 'GLORIA DEI BUONI A NULLA - S. DETOC' , '1' , '1' , '4' , '14.00' , '14' , '0' , '45' , '7.7000' ) 22/10/2024 03:02:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23086' AND id_supplier = '79' 22/10/2024 03:02:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23086' , '79' , '1' ) 22/10/2024 03:11:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 03:11:43 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' , '3135' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/10/2024 03:11:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93762' 22/10/2024 03:11:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93762' 22/10/2024 03:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93762' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/10/2024 03:12:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 03:12:28 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' , '3136' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.06' , '56.06' , NOW() , NOW() ) 22/10/2024 03:12:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93763' 22/10/2024 03:12:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93763' 22/10/2024 03:12:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93763' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 22/10/2024 03:12:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93763' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 22/10/2024 03:12:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93763' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 22/10/2024 03:46:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 03:46:00 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' , '3137' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '36.06' , NOW() , NOW() ) 22/10/2024 03:46:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93764' 22/10/2024 03:46:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '93764' 22/10/2024 03:46:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93764' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/10/2024 03:46:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93764' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/10/2024 03:51:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 03:51:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '174' , '2024-10-22' , '' , '3905' , '0' , '4674897' , 'PIAZZA VITTORIO EMANUELE II 1 24040 BONATE SOPRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '138.63' , '138.63' , NOW() , NOW() ) 22/10/2024 03:51:23 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 = '93765' 22/10/2024 03:51:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93765' 22/10/2024 03:51:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93765' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '15' , '53.13' ) 22/10/2024 03:51:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93765' , '23085' , 'GESU\' INSEGNACI A PREGARE' , '60' , '-60' , '4' , '1.50' , '1.5' , '0' , '5' , '85.50' ) 22/10/2024 06:02:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 06:02: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' , '3138' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 22/10/2024 06:02: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 = '93766' 22/10/2024 06:02:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93766' 22/10/2024 06:02: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 ( '93766' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 22/10/2024 06:02: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 ( '93766' , '16986' , 'QUADRETTO SMUSSATO 7X10 SACRO CUORE' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/10/2024 06:02: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 ( '93766' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 22/10/2024 06:05:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2948' AND id_document != '93498' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 22/10/2024 06:05:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2948', document_date = '2024-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '230.00', price_tax_excluded = '188.52', date_upd = NOW() WHERE id_document = '93498' 22/10/2024 06:05:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93498' 22/10/2024 06:05:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93498' 22/10/2024 06:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93498' , '22993' , 'SAN LEOPOLDO MANDIC CM 30 - 599' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 22/10/2024 06:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93498' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '-1' , '1' , '175' , '143.44262295082' , '22' , '0' , '175.00' ) 22/10/2024 06:37:22 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '80/03', document_date = '2024-10-21', document_letter = '03', id_customer = '0', id_supplier = '', id_address = '2644', address1 = 'VIA DELLA STAZIONE, 23 01030 VITORCHIANO', address2 = '', note = '', price_shipping = '7.50', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '61.50', price_tax_excluded = '61.50', date_upd = NOW() WHERE id_document = '93760' 22/10/2024 06:37: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 = '93760' 22/10/2024 06:37:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93760' 22/10/2024 06:37: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 ( '93760' , '23085' , 'GESU INSEGNACI A PREGARE' , '60' , '60' , '4' , '1.5000' , '1.5' , '0' , '40' , '54.00' ) 22/10/2024 07:05:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 07:05:21 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' , '3139' , '2024-10-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 22/10/2024 07:05:21 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 = '93767' 22/10/2024 07:05:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93767' 22/10/2024 07:05:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93767' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 22/10/2024 07:15:26 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '0JVtEaRZCWfEkE2A' , NOW() , NOW() ) 22/10/2024 07:15:27 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4129' , '1' ) 22/10/2024 07:15:27 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4129' , '2' ) 22/10/2024 07:15:27 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4129' , '3' ) 22/10/2024 07:17:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4129' 22/10/2024 07:17:37 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 ( '4129' , '10' , '199' , 'PARR. S. MARTINO VESCOVO E S CUORE DI GESU\'' , '' , '' , 'VIA FABRICIO 3' , '' , '33090' , 'CLAUZETTO' , '' , '' , '333.5763559' , '' , '90003080935' , NOW() , NOW() ) 22/10/2024 07:17:37 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4129' 22/10/2024 07:24:45 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4129' 22/10/2024 07:24:45 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 ( '4129' , '10' , '199' , 'PARR. S. MARTINO VESCOVO E S CUORE DI GESU\'' , '' , '' , 'VIA FABRICIO 3' , '' , '33090' , 'CLAUZETTO' , 'Don Italico José Gerometta \r\nVia Barquet 2/a \r\n33090 ANDUINS di Vito d\'Asio (Pordenone). \r\nCellulare 333.5763559 \r\n' , '' , '333.5763559' , '' , '90003080935' , NOW() , NOW() ) 22/10/2024 07:24:45 pm >> UPDATE ps_customer SET email = 'italicojose@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4129' 22/10/2024 07:25:56 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4129' 22/10/2024 07:25:56 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 ( '4129' , '10' , '199' , 'PARR. S. MARTINO VESCOVO E S CUORE DI GESU\'' , 'GEREMETTA' , 'DON ITALICO JOSE\'' , 'VIA FABRICIO 3' , '' , '33090' , 'CLAUZETTO' , 'Don Italico José Gerometta \r\nVia Barquet 2/a \r\n33090 ANDUINS di Vito d\'Asio (Pordenone). \r\nCellulare 333.5763559 \r\n' , '' , '333.5763559' , '' , '90003080935' , NOW() , NOW() ) 22/10/2024 07:25:56 pm >> UPDATE ps_customer SET email = 'italicojose@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4129' 22/10/2024 07:26:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '175' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-22') 22/10/2024 07:26:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '175' , '2024-10-22' , '' , '4129' , '0' , '4679395' , 'VIA FABRICIO 3 33090 CLAUZETTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 22/10/2024 07:26:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93768' 22/10/2024 07:26:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '93768' 22/10/2024 07:26:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93768' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '100' , '-100' , '4' , '1.00' , '1' , '0' , '15' , '85.00' ) 22/10/2024 07:26:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4129' 22/10/2024 07:26:44 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 ( '4129' , '10' , '199' , 'PARR. S. MARTINO VESCOVO E S CUORE DI GESU\'' , 'GEREMETTA' , 'DON ITALICO JOSE\'' , 'VIA FABRICIO 3' , '' , '33090' , 'CLAUZETTO' , 'Don Italico José Gerometta \r\nVia Barquet 2/a \r\n33090 ANDUINS di Vito d\'Asio (Pordenone). \r\nCellulare 333.5763559 \r\n' , '' , '333.5763559' , '' , '90003080935' , NOW() , NOW() ) 22/10/2024 07:26:44 pm >> UPDATE ps_customer SET email = 'italicojose@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4129' 22/10/2024 07:33:28 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4129' 22/10/2024 07:33:28 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 ( '4129' , '10' , '199' , 'PARR. S. MARTINO VESCOVO E S CUORE DI GESU\'' , 'GEREMETTA' , 'DON ITALICO JOSE\'' , 'VIA FABRICIO 3' , '' , '33090' , 'CLAUZETTO' , 'Don Italico José Gerometta \r\nVia Barquet 2/a \r\n33090 ANDUINS di Vito d\'Asio (Pordenone). \r\nCellulare 333.5763559 \r\n' , '' , '333.5763559' , '' , '90003080935' , NOW() , NOW() ) 22/10/2024 07:33:28 pm >> UPDATE ps_customer SET email = 'italicojose@yahoo.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4129' 22/10/2024 07:55:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '128' AND id_document != '93298' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-26') 22/10/2024 07:55:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '128', document_date = '2024-09-26', document_letter = '', id_customer = '4045', id_supplier = '', id_address = '4679361', address1 = 'VIA ROMOLO BALZANI 74 00177 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '142.80', price_tax_excluded = '142.80', date_upd = NOW() WHERE id_document = '93298' 22/10/2024 07:55: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 = '93298' 22/10/2024 07:55:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93298' 22/10/2024 07:55: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 ( '93298' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '60' , '-60' , '4' , '2.8000' , '2.8' , '0' , '15' , '142.80' )