21/05/2025 08:49:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1752' AND id_document != '97282' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 21/05/2025 08:49:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1752', document_date = '2025-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.60', price_tax_excluded = '26.60', date_upd = NOW() WHERE id_document = '97282' 21/05/2025 08:49:09 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 = '97282' 21/05/2025 08:49:09 am >> DELETE FROM ps_document_detail WHERE id_document = '97282' 21/05/2025 08:49:09 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 ( '97282' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '4' , '-4' , '4' , '4.00' , '4' , '0' , '5' , '15.20' ) 21/05/2025 08:49:09 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 ( '97282' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '4' , '4' , '0' , '5' , '11.40' ) 21/05/2025 08:49:55 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1220' 21/05/2025 08:49:55 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 ( '1220' , '10' , '210' , 'PARROCCHIA SAN VITO' , 'ORLANDO ' , 'DON DONATO' , 'P.ZZA SANTINI 19' , '' , '84040' , 'CAPACCIO SCALO' , '' , '0828/725182' , '' , '' , '90002370659' , NOW() , NOW() ) 21/05/2025 08:49:55 am >> UPDATE ps_customer SET email = 'davisa@email.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1220' 21/05/2025 08:50:13 am >> SELECT document_num FROM ps_document WHERE document_num = '69' AND id_document != '97264' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-19') 21/05/2025 08:50:13 am >> UPDATE ps_document SET id_document_type = '21', document_num = '69', document_date = '2025-05-19', document_letter = '', id_customer = '1220', id_supplier = '', id_address = '4679323', address1 = 'P.ZZA SANTINI,19 84040 CAPACCIO SCALO', 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 = '71.40', price_tax_excluded = '71.40', date_upd = NOW() WHERE id_document = '97264' 21/05/2025 08:50:13 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 = '97264' 21/05/2025 08:50:13 am >> DELETE FROM ps_document_detail WHERE id_document = '97264' 21/05/2025 08:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97264' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' ) 21/05/2025 09:23:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1767' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 09:23:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1767' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 21/05/2025 09:23:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97297' 21/05/2025 09:23:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97297' 21/05/2025 09:23:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97297' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 21/05/2025 09:25:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1641' AND id_document != '97153' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 21/05/2025 09:25:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1641', document_date = '2025-05-13', 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 = '48.00', price_tax_excluded = '39.81', date_upd = NOW() WHERE id_document = '97153' 21/05/2025 09:25:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97153' 21/05/2025 09:25:34 am >> DELETE FROM ps_document_detail WHERE id_document = '97153' 21/05/2025 09:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.6000' , '2.6' , '0' , '0' , '2.60' ) 21/05/2025 09:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 21/05/2025 09:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24.2' , '19.83606557377' , '22' , '0' , '24.20' ) 21/05/2025 09:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97153' , '23383' , 'BRACCIALE DECINA - BD020' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 21/05/2025 10:35:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1768' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 10:35:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1768' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.40' , '6.07' , NOW() , NOW() ) 21/05/2025 10:35: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 = '97298' 21/05/2025 10:35:15 am >> DELETE FROM ps_document_detail WHERE id_document = '97298' 21/05/2025 10:35: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 ( '97298' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 21/05/2025 10:35: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 ( '97298' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '1' , '-1' , '1' , '2.60' , '2.1311475409836' , '22' , '0' , '2.60' ) 21/05/2025 10:35: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 ( '97298' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 21/05/2025 10:35: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 ( '97298' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 21/05/2025 10:36:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1769' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 10:36:53 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' , '1769' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 21/05/2025 10:36:53 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 = '97299' 21/05/2025 10:36:53 am >> DELETE FROM ps_document_detail WHERE id_document = '97299' 21/05/2025 10:36:53 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 ( '97299' , '23700' , 'AMEN - LUG 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 21/05/2025 10:36:53 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 ( '97299' , '23699' , 'AMEN - AGO 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 21/05/2025 10:57:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1770' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 10:57:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1770' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.80' , '43.22' , NOW() , NOW() ) 21/05/2025 10:57:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97300' 21/05/2025 10:57:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97300' 21/05/2025 10:57:38 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 ( '97300' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 21/05/2025 10:57:38 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 ( '97300' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 21/05/2025 10:57:38 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 ( '97300' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 21/05/2025 10:57:38 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 ( '97300' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/05/2025 10:57:38 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 ( '97300' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 21/05/2025 11:06:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1771' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 11:06:18 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' , '1771' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.77' , NOW() , NOW() ) 21/05/2025 11:06:18 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 = '97301' 21/05/2025 11:06:18 am >> DELETE FROM ps_document_detail WHERE id_document = '97301' 21/05/2025 11:06:18 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 ( '97301' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 21/05/2025 11:09:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190765' AND id_product != '9486' AND ean13 != '' 21/05/2025 11:09:56 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190765', date_upd = NOW() WHERE id_product = '9486' 21/05/2025 11:09:56 am >> UPDATE ps_product_lang SET name = 'S. MICHELE ARC. BABY - PB19076', description = '' WHERE id_product = '9486' 21/05/2025 11:09:56 am >> UPDATE ps_product SET wholesale_price = '4.30', on_sale = '0', price = '9.836065573770492' WHERE id_product = '9486' 21/05/2025 11:09:56 am >> UPDATE ps_product_shop SET wholesale_price = '4.30', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9486' 21/05/2025 11:09:56 am >> DELETE FROM ps_specific_price WHERE id_product = '9486' 21/05/2025 11:12:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190772' AND id_product != '9464' AND ean13 != '' 21/05/2025 11:12:23 am >> UPDATE ps_product SET id_supplier = '58', reference = '2016', ean13 = '8022934190772', date_upd = NOW() WHERE id_product = '9464' 21/05/2025 11:12:23 am >> UPDATE ps_product_lang SET name = 'S. GIUSEPPE BABY - PB19077', description = '' WHERE id_product = '9464' 21/05/2025 11:12:23 am >> UPDATE ps_product SET wholesale_price = '3.60', on_sale = '0', price = '8.114754098360656' WHERE id_product = '9464' 21/05/2025 11:12:23 am >> UPDATE ps_product_shop SET wholesale_price = '3.60', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '164', 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 = '9464' 21/05/2025 11:12:23 am >> DELETE FROM ps_specific_price WHERE id_product = '9464' 21/05/2025 11:13:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190772' AND id_product != '9464' AND ean13 != '' 21/05/2025 11:13:01 am >> UPDATE ps_product SET id_supplier = '134', reference = '2016', ean13 = '8022934190772', date_upd = NOW() WHERE id_product = '9464' 21/05/2025 11:13:01 am >> UPDATE ps_product_lang SET name = 'S. GIUSEPPE BABY - PB19077', description = '' WHERE id_product = '9464' 21/05/2025 11:13:01 am >> UPDATE ps_product SET wholesale_price = '3.60', on_sale = '0', price = '8.114754098360656' WHERE id_product = '9464' 21/05/2025 11:13:01 am >> UPDATE ps_product_shop SET wholesale_price = '3.60', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '458', 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 = '9464' 21/05/2025 11:13:01 am >> DELETE FROM ps_specific_price WHERE id_product = '9464' 21/05/2025 11:15:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190789' AND id_product != '9205' AND ean13 != '' 21/05/2025 11:15:59 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190789', date_upd = NOW() WHERE id_product = '9205' 21/05/2025 11:15:59 am >> UPDATE ps_product_lang SET name = 'S. ANTONIO BABY - PB19078', description = '' WHERE id_product = '9205' 21/05/2025 11:15:59 am >> UPDATE ps_product SET wholesale_price = '3.33', on_sale = '0', price = '8.114754098360656' WHERE id_product = '9205' 21/05/2025 11:15:59 am >> UPDATE ps_product_shop SET wholesale_price = '3.33', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9205' 21/05/2025 11:15:59 am >> DELETE FROM ps_specific_price WHERE id_product = '9205' 21/05/2025 11:17:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190796' AND id_product != '9212' AND ean13 != '' 21/05/2025 11:17:55 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190796', date_upd = NOW() WHERE id_product = '9212' 21/05/2025 11:17:55 am >> UPDATE ps_product_lang SET name = 'S. FRANCESCO BABY - PB19079', description = '' WHERE id_product = '9212' 21/05/2025 11:17:55 am >> UPDATE ps_product SET wholesale_price = '3.25', on_sale = '0', price = '8.114754098360656' WHERE id_product = '9212' 21/05/2025 11:17:55 am >> UPDATE ps_product_shop SET wholesale_price = '3.25', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9212' 21/05/2025 11:17:55 am >> DELETE FROM ps_specific_price WHERE id_product = '9212' 21/05/2025 11:21:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190802' AND id_product != '9209' AND ean13 != '' 21/05/2025 11:21:35 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190802', date_upd = NOW() WHERE id_product = '9209' 21/05/2025 11:21:35 am >> UPDATE ps_product_lang SET name = 'SACRA FAMIGLIA BABY - PB19080', description = '' WHERE id_product = '9209' 21/05/2025 11:21:35 am >> UPDATE ps_product SET wholesale_price = '4.30', on_sale = '0', price = '10.573770491803279' WHERE id_product = '9209' 21/05/2025 11:21:35 am >> UPDATE ps_product_shop SET wholesale_price = '4.30', price = '10.573770491803279', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9209' 21/05/2025 11:21:35 am >> DELETE FROM ps_specific_price WHERE id_product = '9209' 21/05/2025 11:22:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190802' AND id_product != '9209' AND ean13 != '' 21/05/2025 11:22:50 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190802', date_upd = NOW() WHERE id_product = '9209' 21/05/2025 11:22:50 am >> UPDATE ps_product_lang SET name = 'SACRA FAMIGLIA BABY - PB19080', description = '' WHERE id_product = '9209' 21/05/2025 11:22:50 am >> UPDATE ps_product SET wholesale_price = '4.30', on_sale = '0', price = '10.573770491803279' WHERE id_product = '9209' 21/05/2025 11:22:50 am >> UPDATE ps_product_shop SET wholesale_price = '4.30', price = '10.573770491803279', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9209' 21/05/2025 11:22:50 am >> DELETE FROM ps_specific_price WHERE id_product = '9209' 21/05/2025 11:23:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190819' AND id_product != '6075' AND ean13 != '' 21/05/2025 11:23:31 am >> UPDATE ps_product SET id_supplier = '134', reference = '2015', ean13 = '8022934190819', date_upd = NOW() WHERE id_product = '6075' 21/05/2025 11:23:31 am >> UPDATE ps_product_lang SET name = 'LOURDES BABY - PB19081', description = '' WHERE id_product = '6075' 21/05/2025 11:23:31 am >> UPDATE ps_product SET wholesale_price = '2.99', on_sale = '0', price = '8.114754098360656' WHERE id_product = '6075' 21/05/2025 11:23:31 am >> UPDATE ps_product_shop SET wholesale_price = '2.99', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '163', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6075' 21/05/2025 11:23:31 am >> DELETE FROM ps_specific_price WHERE id_product = '6075' 21/05/2025 11:25:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190833' AND id_product != '14623' AND ean13 != '' 21/05/2025 11:25:23 am >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934190833', date_upd = NOW() WHERE id_product = '14623' 21/05/2025 11:25:23 am >> UPDATE ps_product_lang SET name = 'BAMBINO DI PRAGA BABY - PB19083', description = '' WHERE id_product = '14623' 21/05/2025 11:25:23 am >> UPDATE ps_product SET wholesale_price = '3.35', on_sale = '0', price = '8.114754098360656' WHERE id_product = '14623' 21/05/2025 11:25:24 am >> UPDATE ps_product_shop SET wholesale_price = '3.35', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '458', 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 = '14623' 21/05/2025 11:25:24 am >> DELETE FROM ps_specific_price WHERE id_product = '14623' 21/05/2025 11:27:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934190857' AND id_product != '13111' AND ean13 != '' 21/05/2025 11:27:40 am >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934190857', date_upd = NOW() WHERE id_product = '13111' 21/05/2025 11:27:40 am >> UPDATE ps_product_lang SET name = 'FATIMA BABY - PB19085', description = '' WHERE id_product = '13111' 21/05/2025 11:27:40 am >> UPDATE ps_product SET wholesale_price = '4.82', on_sale = '0', price = '9.8361' WHERE id_product = '13111' 21/05/2025 11:27:40 am >> UPDATE ps_product_shop SET wholesale_price = '4.82', price = '9.8361', id_tax_rules_group = '1', id_category_default = '458', 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 = '13111' 21/05/2025 11:27:40 am >> DELETE FROM ps_specific_price WHERE id_product = '13111' 21/05/2025 11:33:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '00' , '2025-05-19' , '' , '0' , '134' , '4670785' , 'VIA ROMA 44 00053 CIVITAVECCHIA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.79' , '197.37' , NOW() , NOW() ) 21/05/2025 11:33:09 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 = '97302' 21/05/2025 11:33:09 am >> DELETE FROM ps_document_detail WHERE id_document = '97302' 21/05/2025 11:33:09 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 ( '97302' , '9486' , 'S. MICHELE ARC. BABY - PB19076' , '6' , '6' , '1' , '4.75' , '3.8934426229508' , '22' , '5' , '33.0315' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9486' AND id_supplier = '134' 21/05/2025 11:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9486' , '134' , '1' ) 21/05/2025 11:33:09 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 ( '97302' , '9464' , 'S. GIUSEPPE BABY - PB19077' , '6' , '6' , '1' , '3.88' , '3.1803278688525' , '22' , '5' , '26.9815' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9464' AND id_supplier = '134' 21/05/2025 11:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9464' , '134' , '1' ) 21/05/2025 11:33:09 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 ( '97302' , '9205' , 'S. ANTONIO BABY - PB19078' , '6' , '6' , '1' , '3.98' , '3.2622950819672' , '22' , '5' , '27.6769' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9205' AND id_supplier = '134' 21/05/2025 11:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9205' , '134' , '1' ) 21/05/2025 11:33:09 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 ( '97302' , '9212' , 'S. FRANCESCO BABY - PB19079' , '6' , '6' , '1' , '3.68' , '3.016393442623' , '22' , '5' , '25.5907' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9212' AND id_supplier = '134' 21/05/2025 11:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9212' , '134' , '1' ) 21/05/2025 11:33:09 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 ( '97302' , '9209' , 'SACRA FAMIGLIA BABY - PB19080' , '6' , '6' , '1' , '5.28' , '4.327868852459' , '22' , '5' , '36.7171' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '9209' AND id_supplier = '134' 21/05/2025 11:33:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9209' , '134' , '1' ) 21/05/2025 11:33:09 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 ( '97302' , '6075' , 'LOURDES BABY - PB19081' , '6' , '6' , '1' , '3.28' , '2.6885245901639' , '22' , '5' , '22.8091' ) 21/05/2025 11:33:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '6075' AND id_supplier = '134' 21/05/2025 11:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6075' , '134' , '1' ) 21/05/2025 11:33:10 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 ( '97302' , '14623' , 'BAMBINO DI PRAGA BABY - PB19083' , '6' , '6' , '1' , '3.86' , '3.1639344262295' , '22' , '5' , '26.8424' ) 21/05/2025 11:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '134' 21/05/2025 11:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '134' , '1' ) 21/05/2025 11:33:10 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 ( '97302' , '13111' , 'FATIMA BABY - PB19085' , '6' , '6' , '1' , '4.18' , '3.4262295081967' , '22' , '5' , '29.0677' ) 21/05/2025 11:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '13111' AND id_supplier = '134' 21/05/2025 11:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13111' , '134' , '1' ) 21/05/2025 11:33:10 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 ( '97302' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '9.9' , '8.1147540983607' , '22' , '0' , '12.0780' ) 21/05/2025 11:33:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '134' 21/05/2025 11:33:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '134' , '1' ) 21/05/2025 11:42:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 11:42:26 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' , '1772' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 21/05/2025 11:42:26 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 = '97303' 21/05/2025 11:42:26 am >> DELETE FROM ps_document_detail WHERE id_document = '97303' 21/05/2025 11:42:26 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 ( '97303' , '19316' , 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159' , '14' , '-14' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '42.00' ) 21/05/2025 12:15:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 12:15:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1773' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 21/05/2025 12:15: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 = '97304' 21/05/2025 12:15:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '97304' 21/05/2025 12:15: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 ( '97304' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 21/05/2025 12:20: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 ( '33' , '2344/00' , '2025-05-19' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4091.60' , '4091.60' , NOW() , NOW() ) 21/05/2025 12:20: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 = '14815' 21/05/2025 12:20:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '14815' 21/05/2025 12:20: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 ( '14815' , '69' , ' LA CASA DEI RAGAZZI' , '48' , '48' , '4' , '7.00' , '7' , '0' , '0' , '336.0000' ) 21/05/2025 12:20: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 ( '14815' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '13' , '13' , '4' , '1.50' , '1.5' , '0' , '0' , '19.5000' ) 21/05/2025 12:20: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 ( '14815' , '40' , 'A TAVOLA CON GESU\'' , '26' , '26' , '4' , '2.50' , '2.5' , '0' , '0' , '65.0000' ) 21/05/2025 12:20: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 ( '14815' , '98' , 'ANGELO DI DIO PREGHIERE' , '8' , '8' , '4' , '1.50' , '1.5' , '0' , '0' , '12.0000' ) 21/05/2025 12:20: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 ( '14815' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '15' , '15' , '4' , '1.50' , '1.5' , '0' , '0' , '22.5000' ) 21/05/2025 12:20: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 ( '14815' , '54' , 'BENEDETTO XVI ° ..... UNA PAGINA DI STORIA' , '43' , '43' , '4' , '2.50' , '2.5' , '0' , '0' , '107.5000' ) 21/05/2025 12:20: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 ( '14815' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '0' , '7.5000' ) 21/05/2025 12:20: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 ( '14815' , '74' , 'DIO È , IN DIECI PAROLE' , '3' , '3' , '4' , '4.50' , '4.5' , '0' , '0' , '13.5000' ) 21/05/2025 12:20: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 ( '14815' , '28' , 'DON CARLO GNOCCHI' , '38' , '38' , '4' , '2.00' , '2' , '0' , '0' , '76.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '39' , 'FEDE E SALVEZZA' , '16' , '16' , '4' , '2.00' , '2' , '0' , '0' , '32.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '72' , 'FEDE, SPERANZA E CARITA\'' , '32' , '32' , '4' , '6.00' , '6' , '0' , '0' , '192.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '73' , 'FRANCESCO AI GIOVANI' , '49' , '49' , '4' , '2.50' , '2.5' , '0' , '0' , '122.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '88' , 'GESÙ È RISORTO' , '8' , '8' , '4' , '2.00' , '2' , '0' , '0' , '16.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '61' , 'GIOVANNI PAOLO II° SANTO' , '49' , '49' , '4' , '2.50' , '2.5' , '0' , '0' , '122.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '62' , 'GIOVANNI XXIII° SANTO .....IL PAPA BUONO' , '49' , '49' , '4' , '2.50' , '2.5' , '0' , '0' , '122.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '91' , 'I 10 COMANDAMENTI' , '67' , '67' , '4' , '2.00' , '2' , '0' , '0' , '134.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '10' , 'I miracoli da colorare. Gesù cammina sulle acque' , '15' , '15' , '4' , '2.00' , '2' , '0' , '0' , '30.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '5' , 'I miracoli da colorare. Gesù e la tempesta sedata' , '24' , '24' , '4' , '1.50' , '1.5' , '0' , '0' , '36.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '6' , 'I miracoli da colorare. Il figlio della vedova' , '23' , '23' , '4' , '2.00' , '2' , '0' , '0' , '46.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '4' , 'I miracoli da colorare. Le nozze di Cana' , '23' , '23' , '4' , '2.00' , '2' , '0' , '0' , '46.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '48' , 'I SANTI E GLI ANIMALI' , '30' , '30' , '4' , '3.00' , '3' , '0' , '0' , '90.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '85' , 'Il Buon Samaritano' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '36' , 'IL CANTICO DEI CANTICI' , '34' , '34' , '4' , '2.50' , '2.5' , '0' , '0' , '85.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '18' , 'IL NOSTRO VIAGGIO IN TERRASANTA + 80 FIG.' , '8' , '8' , '4' , '9.50' , '9.5' , '0' , '0' , '76.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '84' , 'L\'AVVENTO' , '4' , '4' , '4' , '2.00' , '2' , '0' , '0' , '8.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '4' , '4' , '4' , '9.00' , '9' , '0' , '0' , '36.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '15' , 'LA BIBBIA: GENESI ALBUM+FIGURINE' , '49' , '49' , '4' , '15.00' , '15' , '0' , '0' , '735.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '31' , 'LA BIBBIA:ED.REGALO ANTICO TESTAMENTO' , '10' , '10' , '4' , '12.00' , '12' , '0' , '0' , '120.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '21' , 'LA COMUNIONE' , '16' , '16' , '4' , '2.00' , '2' , '0' , '0' , '32.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '95' , 'LA PICCOLA MATITA' , '95' , '95' , '4' , '1.50' , '1.5' , '0' , '0' , '142.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '70' , 'La storia della salvezza raccontata ai bambini. 2 Caino e Abele' , '79' , '79' , '4' , '2.00' , '2' , '0' , '0' , '158.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '82' , 'LAUDATO SI\'' , '124' , '124' , '4' , '2.00' , '2' , '0' , '0' , '248.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '102' , 'LE BEATITUDINI N.EDIZ.' , '2' , '2' , '4' , '2.00' , '2' , '0' , '0' , '4.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '1' , '1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '41' , '41' , '4' , '2.60' , '2.6' , '0' , '0' , '106.6000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '56' , 'MARIA LA MAMMA DI GESU\'' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '16' , 'MARIA DALLA NASCITA ALL\'ASSUNZIONE' , '39' , '39' , '4' , '2.50' , '2.5' , '0' , '0' , '97.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '22' , 'SAN PAOLO DI TARSO' , '15' , '15' , '4' , '2.50' , '2.5' , '0' , '0' , '37.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '12' , 'SANTA CATERINA DA SIENA' , '27' , '27' , '4' , '2.00' , '2' , '0' , '0' , '54.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '63' , 'STORIA D.SALVEZZA 1°ADAMO ED EVA' , '80' , '80' , '4' , '2.00' , '2' , '0' , '0' , '160.0000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '27' , 'TU SEI PIETRO' , '37' , '37' , '4' , '2.50' , '2.5' , '0' , '0' , '92.5000' ) 21/05/2025 12:20:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14815' , '45' , 'UN ANGELO DI NOME AMADEUS' , '16' , '16' , '4' , '15.00' , '15' , '0' , '0' , '240.0000' ) 21/05/2025 03:43:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '97147' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-12') 21/05/2025 03:43:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2025-05-12', document_letter = 'A', id_customer = '540', id_supplier = '', id_address = '4673023', address1 = 'CORSO GARIBALDI, 6 84025 EBOLI', 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 = '521.00', price_tax_excluded = '521.00', date_upd = NOW() WHERE id_document = '97147' 21/05/2025 03:43: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 = '97147' 21/05/2025 03:43:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97147' 21/05/2025 03:43: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 ( '97147' , '21134' , 'TUNICA 2 PIEGONI - S 11' , '10' , '-10' , '0' , '45.0000' , '45' , '0' , '0' , '450.00' ) 21/05/2025 03:43: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 ( '97147' , '21134' , 'TUNICA 2 PIEGONI - S 11 - EXTRA' , '1' , '-1' , '0' , '50.0000' , '50' , '0' , '0' , '50.00' ) 21/05/2025 03:43: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 ( '97147' , '18276' , 'CINGOLO CON NODI - 3280' , '3' , '-3' , '0' , '5' , '5' , '' , '0' , '15.00' ) 21/05/2025 03:43: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 ( '97147' , '20516' , 'CROCE COMUNIONE - 42/08' , '3' , '-3' , '0' , '2' , '2' , '' , '0' , '6.00' ) 21/05/2025 03:44:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 03:44:08 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' , '1774' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 21/05/2025 03:44:08 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 = '97305' 21/05/2025 03:44:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97305' 21/05/2025 03:44:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97305' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 21/05/2025 03:48:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 03:48: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' , '1775' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 21/05/2025 03:48: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 = '97306' 21/05/2025 03:48:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97306' 21/05/2025 03:48: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 ( '97306' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 21/05/2025 03:50:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 03:50: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 ( '11' , '1776' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '18.75' , NOW() , NOW() ) 21/05/2025 03:50: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 = '97307' 21/05/2025 03:50:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '97307' 21/05/2025 03:50: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 ( '97307' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/05/2025 03:50: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 ( '97307' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 21/05/2025 05:20:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 05:20: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' , '1777' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 21/05/2025 05:20: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 = '97308' 21/05/2025 05:20:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97308' 21/05/2025 05:20: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 ( '97308' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 21/05/2025 05:20: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 ( '97308' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 21/05/2025 05:20: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 ( '97308' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 21/05/2025 05:20: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 ( '97308' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 21/05/2025 06:11:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 06: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' , '1778' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 21/05/2025 06: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 = '97309' 21/05/2025 06:11:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97309' 21/05/2025 06: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 ( '97309' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 21/05/2025 06:20:21 pm >> DELETE FROM ps_document WHERE id_document = '97147' 21/05/2025 06:20:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97147' 21/05/2025 06:29:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 06:29: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' , '1779' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 21/05/2025 06:29: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 = '97310' 21/05/2025 06:29:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '97310' 21/05/2025 06:29: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 ( '97310' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 21/05/2025 06:44:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 06:44:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '70' , '2025-05-21' , '' , '3573' , '0' , '4679392' , 'VIA RECCO 1 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '49.98' , '49.98' , NOW() , NOW() ) 21/05/2025 06:44:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97311' 21/05/2025 06:44:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '97311' 21/05/2025 06:44:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97311' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '21' , '-21' , '4' , '2.80' , '2.8' , '0' , '15' , '49.98' ) 21/05/2025 06:45:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 06:45: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 ( '11' , '1780' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 21/05/2025 06:45: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 = '97312' 21/05/2025 06:45:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97312' 21/05/2025 06:45: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 ( '97312' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 21/05/2025 07:12:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:12:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1781' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 21/05/2025 07:12:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97313' 21/05/2025 07:12:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97313' 21/05/2025 07:12:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97313' , '22255' , 'STATUA SAN GIUSEPPE CM 40 - 804' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 21/05/2025 07:13:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:13:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1782' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 21/05/2025 07:13:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97314' 21/05/2025 07:13:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97314' 21/05/2025 07:13: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 ( '97314' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 21/05/2025 07:14:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:14:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1783' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 21/05/2025 07:14:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97315' 21/05/2025 07:14:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97315' 21/05/2025 07:14:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97315' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 21/05/2025 07:14:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 21/05/2025 07:17:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:17: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' , '1784' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 21/05/2025 07:17: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 = '97316' 21/05/2025 07:17:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97316' 21/05/2025 07:17: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 ( '97316' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 21/05/2025 07:44:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:44:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1785' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 21/05/2025 07:44: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 = '97317' 21/05/2025 07:44:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97317' 21/05/2025 07:44: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 ( '97317' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 21/05/2025 07:47:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-21') 21/05/2025 07:47:47 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' , '1786' , '2025-05-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 21/05/2025 07:47:47 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 = '97318' 21/05/2025 07:47:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97318' 21/05/2025 07:47:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97318' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' )