La guida propone indicazioni e suggerimenti di carattere didattico e contenutistico per meglio annunciare il messaggio ai fanciulli. In allegato le partizioni musicali dei canti suggeriti nel testo.
' WHERE id_product = '8489' 15/11/2022 12:51:19 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '8' WHERE id_product = '8489' 15/11/2022 12:51:19 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8489' 15/11/2022 12:51:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '8489' 15/11/2022 12:51:19 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '8489' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 15/11/2022 12:51:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423144' AND id_product != '5446' AND ean13 != '' 15/11/2022 12:51:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '4/2', ean13 = '9788886423144', date_upd = NOW() WHERE id_product = '5446' 15/11/2022 12:51:39 pm >> UPDATE ps_product_lang SET name = 'IO SONO CON VOI - GUIDA', description = 'La guida accompagna i catechisti nel compito di annunciare la fede.
Lo schema proposto prevede i seguenti momenti:
- Obiettivo dell\'incontro
- Esperienza del fanciullo
- Annuncio
- Preghiera
- Attività
' WHERE id_product = '5446' 15/11/2022 12:51:39 pm >> UPDATE ps_product SET wholesale_price = '0.20', on_sale = '0', price = '8' WHERE id_product = '5446' 15/11/2022 12:51:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.20', price = '8', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5446' 15/11/2022 12:51:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '5446' 15/11/2022 12:51:39 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '5446' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 15/11/2022 01:02:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 01:02: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 ( '11' , '3466' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 15/11/2022 01:02: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 = '73123' 15/11/2022 01:02:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '73123' 15/11/2022 01:02: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 ( '73123' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 15/11/2022 01:02:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '' 15/11/2022 01:02:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '' , '1' ) 15/11/2022 02:09:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002064' AND id_product != '20321' AND ean13 != '' 15/11/2022 02:09:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002064', date_upd = NOW() WHERE id_product = '20321' 15/11/2022 02:09:32 pm >> UPDATE ps_product_lang SET name = 'CASULA TESSUTO OPERATO - 65/023957', description = '' WHERE id_product = '20321' 15/11/2022 02:09:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '663.9344262295082' WHERE id_product = '20321' 15/11/2022 02:09:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '663.9344262295082', id_tax_rules_group = '1', id_category_default = '468', 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 = '20321' 15/11/2022 02:09:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20321' 15/11/2022 02:10:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002065' AND id_product != '20322' AND ean13 != '' 15/11/2022 02:10:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002065', date_upd = NOW() WHERE id_product = '20322' 15/11/2022 02:10:22 pm >> UPDATE ps_product_lang SET name = 'AMITTO MISTO COTONE - 86/000030', description = '' WHERE id_product = '20322' 15/11/2022 02:10:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '20322' 15/11/2022 02:10:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '468', 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 = '20322' 15/11/2022 02:10:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '20322' 15/11/2022 02:11:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002066' AND id_product != '20323' AND ean13 != '' 15/11/2022 02:11:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002066', date_upd = NOW() WHERE id_product = '20323' 15/11/2022 02:11:16 pm >> UPDATE ps_product_lang SET name = 'CAMICE IN LINO PIZZO MACRAME\' - 70/000068', description = '' WHERE id_product = '20323' 15/11/2022 02:11:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '500' WHERE id_product = '20323' 15/11/2022 02:11:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '500', id_tax_rules_group = '1', id_category_default = '468', 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 = '20323' 15/11/2022 02:11:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '20323' 15/11/2022 02:11:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002068' AND id_product != '20325' AND ean13 != '' 15/11/2022 02:11:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002068', date_upd = NOW() WHERE id_product = '20325' 15/11/2022 02:11:50 pm >> UPDATE ps_product_lang SET name = 'AMITTO IN LINO - 86/000030', description = '' WHERE id_product = '20325' 15/11/2022 02:11:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0327868852459' WHERE id_product = '20325' 15/11/2022 02:11:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0327868852459', id_tax_rules_group = '1', id_category_default = '468', 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 = '20325' 15/11/2022 02:11:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20325' 15/11/2022 02:13:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002067' AND id_product != '20324' AND ean13 != '' 15/11/2022 02:13:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002067', date_upd = NOW() WHERE id_product = '20324' 15/11/2022 02:13:58 pm >> UPDATE ps_product_lang SET name = 'STOLA MARIANA SFUMATA - 80/049030', description = '' WHERE id_product = '20324' 15/11/2022 02:13:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '176.22950819672133' WHERE id_product = '20324' 15/11/2022 02:13:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '176.22950819672133', id_tax_rules_group = '1', id_category_default = '468', 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 = '20324' 15/11/2022 02:13:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '20324' 15/11/2022 02:15:16 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' , '474' , '2022-11-10' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '2870.93' , '2353.22' , NOW() , NOW() ) 15/11/2022 02:15:16 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 = '73124' 15/11/2022 02:15:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '73124' 15/11/2022 02:15:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '18369' , 'CAMICE MISTO COT. - 70/005212' , '2' , '2' , '1' , '118' , '96.72131147541' , '22' , '3' , '279.2824' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18369' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18369' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '18370' , 'CAMICE MISTO LANA - 70/000214' , '3' , '3' , '1' , '101' , '82.786885245902' , '22' , '3' , '358.5702' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18370' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18370' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '20321' , 'CASULA TESSUTO OPERATO - 65/023957' , '4' , '4' , '1' , '360' , '295.08196721311' , '22' , '3' , '1704.0960' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20321' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20321' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '20322' , 'AMITTO MISTO COTONE - 86/000030' , '3' , '3' , '1' , '7' , '5.7377049180328' , '22' , '3' , '24.8514' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20322' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20322' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '20323' , 'CAMICE IN LINO PIZZO MACRAME - 70/000068' , '1' , '1' , '1' , '265' , '217.2131147541' , '22' , '3' , '313.6010' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20323' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20323' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '20325' , 'AMITTO IN LINO - 86/000030' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '3' , '10.6506' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20325' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20325' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '17407' , 'STOLA MARIANA - 80/002005' , '1' , '1' , '1' , '63' , '51.639344262295' , '22' , '3' , '74.5542' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17407' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17407' , '143' , '1' ) 15/11/2022 02:15:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73124' , '20324' , 'STOLA MARIANA SFUMATA - 80/049030' , '1' , '1' , '1' , '89' , '72.950819672131' , '22' , '3' , '105.3226' ) 15/11/2022 02:15:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20324' AND id_supplier = '143' 15/11/2022 02:15:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20324' , '143' , '1' ) 15/11/2022 02:24:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3466' AND id_document != '73123' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 02:24:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3466', document_date = '2022-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '73123' 15/11/2022 02:24: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 = '73123' 15/11/2022 02:24:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '73123' 15/11/2022 02:24: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 ( '73123' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 15/11/2022 02:24:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/11/2022 02:24:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/11/2022 03:20:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 03:20: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' , '3467' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '168.00' , '139.12' , NOW() , NOW() ) 15/11/2022 03:20: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 = '73125' 15/11/2022 03:20:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '73125' 15/11/2022 03:20: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 ( '73125' , '18984' , 'POLO FELPATO ML ' , '2' , '-2' , '1' , '57.5' , '47.131147540984' , '22' , '0' , '115.00' ) 15/11/2022 03:20:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 15/11/2022 03:20:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 15/11/2022 03:20: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 ( '73125' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/11/2022 03:20:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/11/2022 03:20:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/11/2022 03:20: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 ( '73125' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '1' , '-1' , '1' , '43.00' , '35.245901639344' , '22' , '0' , '43.00' ) 15/11/2022 03:20:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16765' AND id_supplier = '' 15/11/2022 03:20:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16765' , '' , '1' ) 15/11/2022 03:42:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3218' 15/11/2022 03:42:12 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 ( '3218' , '10' , '197' , 'PARR. S. MARIA ASSUNTA' , 'FALCHI' , 'DON ANGELO' , 'P. ZZA GARIBALDI, 2' , '' , '56035' , 'CASCIANA TERME LARI' , 'SOLO CONTRASSEGNO' , '3476662742' , '3476662742' , '' , '90004850500' , NOW() , NOW() ) 15/11/2022 03:42:12 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3218' 15/11/2022 03:42:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3218' 15/11/2022 03:42:34 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 ( '3218' , '10' , '197' , 'PARR. S. MARIA ASSUNTA' , 'FALCHI' , 'DON ANGELO' , 'P. ZZA GARIBALDI, 2' , '' , '56035' , 'CASCIANA TERME LARI' , 'SOLO CONTRASSEGNO' , '' , '3476662742' , '' , '90004850500' , NOW() , NOW() ) 15/11/2022 03:42:34 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3218' 15/11/2022 03:43:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '280' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 03:43:14 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' , '280' , '2022-11-15' , '' , '3218' , '0' , '4677181' , 'P. ZZA GARIBALDI, 2 56035 CASCIANA TERME LARI' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '50.90' , '50.90' , NOW() , NOW() ) 15/11/2022 03:43:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73126' 15/11/2022 03:43:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '73126' 15/11/2022 03:43: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 ( '73126' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '14' , '-14' , '4' , '3.50' , '3.5' , '0' , '15' , '41.65' ) 15/11/2022 03:43: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 ( '73126' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 15/11/2022 04:18:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 04:18:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3468' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.70' , '16.70' , NOW() , NOW() ) 15/11/2022 04:18:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73127' 15/11/2022 04:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '73127' 15/11/2022 04:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73127' , '3663' , 'DONI DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/11/2022 04:18:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3663' AND id_supplier = '' 15/11/2022 04:18:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3663' , '' , '1' ) 15/11/2022 04:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73127' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/11/2022 04:18:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 15/11/2022 04:18:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 15/11/2022 04:41:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788898032755' AND id_product != '19452' AND ean13 != '' 15/11/2022 04:41:34 pm >> UPDATE ps_product SET id_supplier = '161', reference = '', ean13 = '9788898032755', date_upd = NOW() WHERE id_product = '19452' 15/11/2022 04:41:34 pm >> UPDATE ps_product_lang SET name = 'LIBERI NELLA VERITA\' - M. DE MAIO', description = '' WHERE id_product = '19452' 15/11/2022 04:41:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.0000' WHERE id_product = '19452' 15/11/2022 04:41:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.0000', id_tax_rules_group = '4', id_category_default = '495', id_argoment_default = '338', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19452' 15/11/2022 04:41:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '19452' 15/11/2022 04:45:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 04:45:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3469' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.98' , '14.98' , NOW() , NOW() ) 15/11/2022 04:45:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73128' 15/11/2022 04:45:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '73128' 15/11/2022 04:45:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '16425' , 'IO HO SCELTO VOI - CAT. GIOVANI 1' , '1' , '-1' , '4' , '6.46' , '6.46' , '0' , '5' , '6.14' ) 15/11/2022 04:45:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16425' AND id_supplier = '' 15/11/2022 04:45:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16425' , '' , '1' ) 15/11/2022 04:45:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.30' , '9.3' , '0' , '5' , '8.84' ) 15/11/2022 04:45:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = '' 15/11/2022 04:45:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' ) 15/11/2022 04:46:42 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' , '128' , '2022-11-15' , '' , '0' , '161' , '4673833' , 'VIA TORRIONE 125 84127 SALERNO' , '' , 'CONTO DEPOSITO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 15/11/2022 04:46:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73129' 15/11/2022 04:46:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '73129' 15/11/2022 04:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73129' , '19452' , 'LIBERI NELLA VERITA\' - M. DE MAIO' , '1' , '1' , '4' , '32.00' , '32' , '0' , '25' , '24.0000' ) 15/11/2022 04:46:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19452' AND id_supplier = '161' 15/11/2022 04:46:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19452' , '161' , '1' ) 15/11/2022 04:58:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 04:58:19 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' , '3470' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 15/11/2022 04:58:19 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 = '73130' 15/11/2022 04:58:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '73130' 15/11/2022 04:58:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73130' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 15/11/2022 04:58:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 15/11/2022 04:58:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 15/11/2022 05:09:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '94/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 05:09:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '94/A' , '2022-11-15' , 'A' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.80' , '149.11' , NOW() , NOW() ) 15/11/2022 05:09: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 = '73131' 15/11/2022 05:09:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '73131' 15/11/2022 05:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73131' , '' , 'ordine del 02/11/2022' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 15/11/2022 05:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73131' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '100' , '-100' , '4' , '1.60' , '1.6' , '0' , '40' , '96.00' ) 15/11/2022 05:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73131' , '' , 'ordine del 15/11/2022' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0' ) 15/11/2022 05:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73131' , '12849' , 'LIBRO DELLE SS. MESSE' , '3' , '-3' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '36.00' ) 15/11/2022 05:09:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73131' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '4' , '-4' , '1' , '12.00' , '9.8360655737705' , '22' , '40' , '28.80' ) 15/11/2022 06:16:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3469' AND id_document != '73128' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 06:16:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3469', document_date = '2022-11-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.98', price_tax_excluded = '14.98', date_upd = NOW() WHERE id_document = '73128' 15/11/2022 06:16:20 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 = '73128' 15/11/2022 06:16:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '73128' 15/11/2022 06:16:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.14' , '6.14' , '0' , '0' , '6.14' ) 15/11/2022 06:16:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/11/2022 06:16:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/11/2022 06:16:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73128' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.3000' , '9.3' , '0' , '5' , '8.84' ) 15/11/2022 06:16:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = '' 15/11/2022 06:16:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' ) 15/11/2022 06:31:17 pm >> DELETE FROM ps_document WHERE id_document = '73103' 15/11/2022 06:31:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '73103' 15/11/2022 06:31:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 06:31:55 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' , '3471' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '29.81' , NOW() , NOW() ) 15/11/2022 06:31:55 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 = '73132' 15/11/2022 06:31:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '73132' 15/11/2022 06:31: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 ( '73132' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/11/2022 06:31:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/11/2022 06:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/11/2022 06:31: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 ( '73132' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 15/11/2022 06:31:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/11/2022 06:31:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/11/2022 06:44:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3472' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 06:44: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' , '3472' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 15/11/2022 06:44: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 = '73133' 15/11/2022 06:44:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '73133' 15/11/2022 06:44: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 ( '73133' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/11/2022 06:44:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '' 15/11/2022 06:44:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '' , '1' ) 15/11/2022 06:46:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3473' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 06:46: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' , '3473' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 15/11/2022 06:46: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 = '73134' 15/11/2022 06:46:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '73134' 15/11/2022 06:46: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 ( '73134' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 15/11/2022 06:46:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 15/11/2022 06:46:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 15/11/2022 07:20:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '32' AND id_document != '67978' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-19') 15/11/2022 07:20:05 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '32', document_date = '2022-10-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA - n. c. ricevuta', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '243.70', price_tax_excluded = '243.70', date_upd = NOW() WHERE id_document = '67978' 15/11/2022 07:20:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '67978' 15/11/2022 07:20:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '67978' 15/11/2022 07:20: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 ( '67978' , '17815' , 'LITURGIA: CHIAMATA PER TUTTI ... ' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/11/2022 07:20:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17815' AND id_supplier = '' 15/11/2022 07:20:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17815' , '' , '1' ) 15/11/2022 07:20: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 ( '67978' , '17917' , 'NELLA BOTTEGA DI SAN GIUSEPPE - FARI/CURCIO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 15/11/2022 07:20:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17917' AND id_supplier = '' 15/11/2022 07:20:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17917' , '' , '1' ) 15/11/2022 07:20: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 ( '67978' , '17808' , 'AFFASCINANTE MORTE DI GESU ' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 15/11/2022 07:20:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17808' AND id_supplier = '' 15/11/2022 07:20:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17808' , '' , '1' ) 15/11/2022 07:20: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 ( '67978' , '17822' , 'VIA CRUCIS OLTRE LE SBARRE ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/11/2022 07:20:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17822' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17822' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '15947' , 'CANTARE LA MESSA - E. MASSIMI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15947' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15947' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17817' , 'SEGNO DEL SACRO NELLAGRO NOCERINO - N. BRUNO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17817' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17817' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17202' , 'SANTA MARIA MADDALENA -PIERRE/OLIVIER' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17202' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17202' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17676' , 'MAESTRO DI SAPIENZA - F. DI STASIO' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17676' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17676' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '14327' , 'TRATTATO SULLA PREPARAZIONE ALLA MESSA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14327' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14327' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17683' , 'FAMIGLIA IN ASCOLTO ... - L.S. GIUSTI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17683' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17683' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '16645' , 'ZACCHEO - E. DAL PANE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16645' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16645' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '18074' , 'FRANCESCO GIULLARE DI DIO - R. CANTALAMESSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18074' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18074' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17264' , 'TESTIMONIANZA CRISTIANA NEL MAGISTERO DI GIOVANNI PAOLO II - R. BELLIZIO' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17264' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17264' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17813' , 'GIUSEPPE (GEN 37-50)' , '1' , '-1' , '4' , '20.5000' , '20.5' , '0' , '0' , '20.50' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17813' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17813' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '16828' , 'INIZIAZIONE CRISTIANA - P.A. MURONI' , '1' , '-1' , '4' , '13.8000' , '13.8' , '0' , '0' , '13.80' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16828' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16828' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17386' , 'SACERDOZIO - G. SUMMA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17386' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17386' , '' , '1' ) 15/11/2022 07:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '67978' , '17667' , 'CAMMINARE NELLA VERITA - E.M. PALMA' , '1' , '-1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 15/11/2022 07:20:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17667' AND id_supplier = '' 15/11/2022 07:20:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17667' , '' , '1' ) 15/11/2022 07:20:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '64642' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-05') 15/11/2022 07:20:24 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28', document_date = '2022-10-05', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '7600.00', price_tax_excluded = '7600.00', date_upd = NOW() WHERE id_document = '64642' 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64642' 15/11/2022 07:20:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '64642' 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '5446' , 'IO SONO CON VOI - GUIDA' , '10' , '-10' , '4' , '6.0000' , '6' , '0' , '0' , '60.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '11183' , 'VENITE CON ME - GUIDA' , '50' , '-50' , '4' , '6.0000' , '6' , '0' , '0' , '300.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '42' , '-42' , '4' , '10.0000' , '10' , '0' , '0' , '420.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '30' , '-30' , '4' , '6.0000' , '6' , '0' , '0' , '180.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '8408' , 'PRENDETE E MANGIATE' , '1120' , '-1120' , '4' , '3.0000' , '3' , '0' , '0' , '3360.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '40' , '-40' , '4' , '12.0000' , '12' , '0' , '0' , '480.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '17257' , 'IO TI BATTEZZO ' , '500' , '-500' , '4' , '1.8000' , '1.8' , '0' , '0' , '900.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '40' , '-40' , '4' , '35.0000' , '35' , '0' , '0' , '1400.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 15/11/2022 07:20:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64642' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '200' , '-200' , '4' , '2.5000' , '2.5' , '0' , '0' , '500.00' ) 15/11/2022 07:20:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '' 15/11/2022 07:20:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '' , '1' ) 15/11/2022 07:20:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '68621' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-25') 15/11/2022 07:20:36 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '33', document_date = '2022-10-25', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '5880.00', price_tax_excluded = '5663.61', date_upd = NOW() WHERE id_document = '68621' 15/11/2022 07:20: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 = '68621' 15/11/2022 07:20:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '68621' 15/11/2022 07:20: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 ( '68621' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '240' , '-240' , '4' , '3.5000' , '3.5' , '0' , '0' , '840.00' ) 15/11/2022 07:20:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 15/11/2022 07:20:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 15/11/2022 07:20: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 ( '68621' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '800' , '-800' , '4' , '1.6000' , '1.6' , '0' , '0' , '1280.00' ) 15/11/2022 07:20:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 15/11/2022 07:20:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 15/11/2022 07:20: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 ( '68621' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1200' , '-1200' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1200.00' ) 15/11/2022 07:20:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 15/11/2022 07:20:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 15/11/2022 07:20: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 ( '68621' , '13397' , 'MIO GESU\'' , '160' , '-160' , '4' , '3.5000' , '3.5' , '0' , '0' , '560.00' ) 15/11/2022 07:20:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 15/11/2022 07:20:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 15/11/2022 07:20: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 ( '68621' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '200' , '-200' , '4' , '10.0000' , '10' , '0' , '0' , '2000.00' ) 15/11/2022 07:20:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20231' AND id_supplier = '' 15/11/2022 07:20:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20231' , '' , '1' ) 15/11/2022 07:20:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '73122' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 07:20:48 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34', document_date = '2022-11-15', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '25400.00', price_tax_excluded = '25400.00', date_upd = NOW() WHERE id_document = '73122' 15/11/2022 07:20: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 = '73122' 15/11/2022 07:20:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '73122' 15/11/2022 07:20: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 ( '73122' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '600' , '-600' , '4' , '2.4000' , '2.4' , '0' , '0' , '1440.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '9675' , 'SARETE MIEI TESTIMONI' , '546' , '-546' , '4' , '3.0000' , '3' , '0' , '0' , '1638.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4300' , '-4300' , '4' , '2.5000' , '2.5' , '0' , '0' , '10750.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '11192' , 'VENITE CON ME 2 PARTE' , '3360' , '-3360' , '4' , '2.5000' , '2.5' , '0' , '0' , '8400.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '30' , '-30' , '4' , '8.0000' , '8' , '0' , '0' , '240.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '2679' , 'CONOSCERE GESU\'' , '600' , '-600' , '4' , '3.5000' , '3.5' , '0' , '0' , '2100.00' ) 15/11/2022 07:20:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 15/11/2022 07:20:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '160' , '-160' , '4' , '3.5000' , '3.5' , '0' , '0' , '560.00' ) 15/11/2022 07:20:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 15/11/2022 07:20:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 15/11/2022 07:20: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 ( '73122' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.8000' , '0.8' , '0' , '0' , '272.00' ) 15/11/2022 07:20:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 15/11/2022 07:20:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 15/11/2022 07:21:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '70325' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-03') 15/11/2022 07:21:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2022-11-03', document_letter = 'A', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.', 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 = '420.31', price_tax_excluded = '420.31', date_upd = NOW() WHERE id_document = '70325' 15/11/2022 07:21:20 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 = '70325' 15/11/2022 07:21:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '70325' 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '2679' , 'CONOSCERE GESU\'' , '24' , '-24' , '4' , '3.5000' , '3.5' , '0' , '15' , '71.40' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5444' , 'IO SONO CON VOI - CAT.' , '21' , '-21' , '4' , '5.5000' , '5.5' , '0' , '10' , '103.95' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5458' , 'IO SONO CON VOI 2 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 15/11/2022 07:21:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '11193' , 'VENITE CON ME CAT.' , '16' , '-16' , '4' , '5.5000' , '5.5' , '0' , '10' , '79.20' ) 15/11/2022 07:21:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 15/11/2022 07:21:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 15/11/2022 07:21: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 ( '70325' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 15/11/2022 07:21:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 15/11/2022 07:21:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 15/11/2022 07:25:14 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' , '128' , '2022-11-15' , '' , '0' , '161' , '4673833' , 'VIA TORRIONE 125 84127 SALERNO' , '' , 'CONTO DEPOSITO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '24.00' , NOW() , NOW() ) 15/11/2022 07:25:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73135' 15/11/2022 07:25:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '73135' 15/11/2022 07:25: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 ( '73135' , '19452' , 'LIBERI NELLA VERITA\' - M. DE MAIO' , '1' , '1' , '4' , '32.00' , '32' , '0' , '25' , '24.0000' ) 15/11/2022 07:25:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19452' AND id_supplier = '161' 15/11/2022 07:25:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19452' , '161' , '1' ) 15/11/2022 07:49:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-15') 15/11/2022 07:49: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' , '3474' , '2022-11-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 15/11/2022 07:49: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 = '73136' 15/11/2022 07:49:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '73136' 15/11/2022 07:49: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 ( '73136' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 15/11/2022 07:49:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 15/11/2022 07:49:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' )