10/04/2024 09:44:04 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'qom110ms7QKL1CpI' , NOW() , NOW() ) 10/04/2024 09:44:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4098' , '1' ) 10/04/2024 09:44:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4098' , '2' ) 10/04/2024 09:44:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4098' , '3' ) 10/04/2024 09:46:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4098' 10/04/2024 09:46:28 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 ( '4098' , '10' , '210' , 'PARROCCHIA SS. GUGLIELMO E PELLEGRINO' , '' , '' , 'PIAZZA ALDO MORO ' , '' , '71121' , 'FOGGIA' , 'ORDINA: CISTERNINO SIMONA VIA LUCERA 87/B \r\nsimo67.fg@gmail.com' , '' , '' , '' , '94004720713' , NOW() , NOW() ) 10/04/2024 09:46:28 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4098' 10/04/2024 09:50:58 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4098' 10/04/2024 09:50:58 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 ( '4098' , '10' , '210' , 'PARROCCHIA SS. GUGLIELMO E PELLEGRINO' , '' , '' , 'PIAZZA ALDO MORO ' , '' , '71121' , 'FOGGIA' , 'ORDINA: CISTERNINO SIMONA VIA LUCERA 87/B \r\nsimo67.fg@gmail.com' , '' , '' , '' , '94004720713' , NOW() , NOW() ) 10/04/2024 09:50:58 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4098' 10/04/2024 09:53:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 09:53:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1085' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.89' , '42.89' , NOW() , NOW() ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91185' 10/04/2024 09:53:27 am >> DELETE FROM ps_document_detail WHERE id_document = '91185' 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '7127' , 'NOVENE IN ONORE DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '22368' , 'UN FIORETTO PER MARIA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/04/2024 09:53:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91185' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 10/04/2024 10:00:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4098' 10/04/2024 10:00:44 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 ( '4098' , '10' , '210' , 'PARROCCHIA SS. GUGLIELMO E PELLEGRINO' , '' , '' , 'PIAZZA ALDO MORO ' , '' , '71121' , 'FOGGIA' , 'ORDINA: CISTERNINO SIMONA VIA LUCERA 87/B \r\nsimo67.fg@gmail.com' , '' , '' , '' , '94004720713' , NOW() , NOW() ) 10/04/2024 10:00:44 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4098' 10/04/2024 10:01:30 am >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 10:01:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '70' , '2024-04-10' , '' , '4098' , '0' , '4679305' , 'PIAZZA ALDO MORO 71121 FOGGIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '123.00' , '123.00' , NOW() , NOW() ) 10/04/2024 10:01:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91186' 10/04/2024 10:01:30 am >> DELETE FROM ps_document_detail WHERE id_document = '91186' 10/04/2024 10:01:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91186' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '52' , '-52' , '4' , '2.80' , '2.8' , '0' , '15' , '123.76' ) 10/04/2024 10:01:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91186' , '' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.76' , '-0.76' , '0' , '0' , '-0.76' ) 10/04/2024 10:15:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 10:15:07 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' , '1086' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.33' , NOW() , NOW() ) 10/04/2024 10:15:07 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 = '91187' 10/04/2024 10:15:07 am >> DELETE FROM ps_document_detail WHERE id_document = '91187' 10/04/2024 10:15:07 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 ( '91187' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 10/04/2024 10:15:07 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 ( '91187' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '2' , '-2' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.40' ) 10/04/2024 10:28:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 10:28:39 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' , '1087' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 10/04/2024 10:28:39 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 = '91188' 10/04/2024 10:28:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91188' 10/04/2024 10:28:39 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 ( '91188' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 10/04/2024 10:44:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040053' AND id_product != '7127' AND ean13 != '' 10/04/2024 10:44:39 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040053', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:44:39 am >> UPDATE ps_product_lang SET name = 'NOVENE IN ONORE DELLO SPIRITO SANTO', description = '' WHERE id_product = '7127' 10/04/2024 10:44:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.0000' WHERE id_product = '7127' 10/04/2024 10:44:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:44:39 am >> DELETE FROM ps_specific_price WHERE id_product = '7127' 10/04/2024 10:46:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040053' AND id_product != '7127' AND ean13 != '' 10/04/2024 10:46:14 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040053', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:46:14 am >> UPDATE ps_product_lang SET name = 'NOVENE IN ONORE DELLO SPIRITO SANTO - 8237', description = '' WHERE id_product = '7127' 10/04/2024 10:46:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.0000' WHERE id_product = '7127' 10/04/2024 10:46:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:46:14 am >> DELETE FROM ps_specific_price WHERE id_product = '7127' 10/04/2024 10:47:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040053' AND id_product != '7127' AND ean13 != '' 10/04/2024 10:47:16 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040053', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:47:16 am >> UPDATE ps_product_lang SET name = 'NOVENE IN ONORE DELLO SPIRITO SANTO - 8237', description = '' WHERE id_product = '7127' 10/04/2024 10:47:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.0000' WHERE id_product = '7127' 10/04/2024 10:47:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7127' 10/04/2024 10:47:16 am >> DELETE FROM ps_specific_price WHERE id_product = '7127' 10/04/2024 10:48:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 10:48: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' , '1088' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.90' , NOW() , NOW() ) 10/04/2024 10:48: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 = '91189' 10/04/2024 10:48:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91189' 10/04/2024 10:48: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 ( '91189' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 10/04/2024 11:02:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 11:02: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 ( '11' , '1089' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.65' , '67.62' , NOW() , NOW() ) 10/04/2024 11:02: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 = '91190' 10/04/2024 11:02:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91190' 10/04/2024 11:02: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 ( '91190' , '22287' , 'CIONDOLO SI - ARGENTO' , '13' , '-13' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '39.00' ) 10/04/2024 11:02: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 ( '91190' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 10/04/2024 11:02: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 ( '91190' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/04/2024 11:02: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 ( '91190' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 10/04/2024 11:10:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 11:10:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1090' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 10/04/2024 11:10:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91191' 10/04/2024 11:10:19 am >> DELETE FROM ps_document_detail WHERE id_document = '91191' 10/04/2024 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91191' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/04/2024 11:10:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91191' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/04/2024 12:05:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 12:05:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1091' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.40' , '87.21' , NOW() , NOW() ) 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91192' 10/04/2024 12:05:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91192' 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91192' , '21349' , 'MENSA BIANCA 80X300 - M8030' , '3' , '-3' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '45.00' ) 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91192' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91192' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91192' , '15387' , 'VESTINA BATTESIMALE ' , '8' , '-8' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '24.00' ) 10/04/2024 12:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91192' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '8' , '-8' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '11.20' ) 10/04/2024 12:05:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 12:05:52 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' , '1092' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 10/04/2024 12:05:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91193' 10/04/2024 12:05:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '91193' 10/04/2024 12:05:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91193' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 10/04/2024 12:12:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 12:12:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1093' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.20' , '78.85' , NOW() , NOW() ) 10/04/2024 12:12:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91194' 10/04/2024 12:12:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91194' 10/04/2024 12:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91194' , '15104' , 'ROSARIO BOTTIGLIA ' , '31' , '-31' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '68.20' ) 10/04/2024 12:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91194' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 10/04/2024 12:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91194' , '20183' , 'TESTA ANGELI CM 8 - AR05' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/04/2024 12:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91194' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/04/2024 12:13:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 12:13: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' , '1094' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 10/04/2024 12:13: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 = '91195' 10/04/2024 12:13:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91195' 10/04/2024 12:13: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 ( '91195' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 10/04/2024 12:15:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 12:15:06 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' , '1095' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.71' , '18.71' , NOW() , NOW() ) 10/04/2024 12:15:06 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 = '91196' 10/04/2024 12:15:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91196' 10/04/2024 12:15: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 ( '91196' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 10/04/2024 12:15: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 ( '91196' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 10/04/2024 12:55:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000001984' , '2024-04-09' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '103.50' , '103.50' , NOW() , NOW() ) 10/04/2024 12:55:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91197' 10/04/2024 12:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '91197' 10/04/2024 12:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91197' , '22275' , 'THE CHOSEN. TI HO CHIAMATO PER NOME' , '2' , '2' , '4' , '20.00' , '20' , '0' , '35' , '26.0000' ) 10/04/2024 12:55:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22275' AND id_supplier = '107' 10/04/2024 12:55:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22275' , '107' , '1' ) 10/04/2024 12:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91197' , '22274' , 'CANTO DEL TRIDUO PASQUALE - S. MILITELLO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 10/04/2024 12:55:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22274' AND id_supplier = '107' 10/04/2024 12:55:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22274' , '107' , '1' ) 10/04/2024 12:55:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91197' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '30' , '4' , '3.00' , '3' , '0' , '35' , '58.5000' ) 10/04/2024 12:55:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 10/04/2024 12:55:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 10/04/2024 12:56:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000001985' , '2024-04-09' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '22.75' , '22.75' , NOW() , NOW() ) 10/04/2024 12:56:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91198' 10/04/2024 12:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91198' 10/04/2024 12:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91198' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 10/04/2024 12:56:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 10/04/2024 12:56:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 10/04/2024 01:03:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 01:03: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 ( '11' , '1096' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1700.00' , '1393.44' , NOW() , NOW() ) 10/04/2024 01:03: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 = '91199' 10/04/2024 01:03:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91199' 10/04/2024 01:03: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 ( '91199' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1700' , '1393.4426229508' , '22' , '0' , '1700.00' ) 10/04/2024 01:05:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 01:05:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1097' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 10/04/2024 01:05:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91200' 10/04/2024 01:05:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91200' 10/04/2024 01:05:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91200' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/04/2024 03:04:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024010000562' , '2024-03-29' , '' , '0' , '0' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6.00' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '186.32' , '186.32' , NOW() , NOW() ) 10/04/2024 03:04:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91201' 10/04/2024 03:04:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '91201' 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22274' , 'CANTO DEL TRIDUO PASQUALE - S. MILITELLO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22275' , 'THE CHOSEN. TI HO CHIAMATO PER NOME' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22276' , 'VITA IN DIO - M. ZANOTTI' , '1' , '0' , '4' , '15.5000' , '15.5' , '0' , '35' , '10.08' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22277' , 'DIVINA PERCEPTIO - J. REGO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22278' , 'MARIA NEL MISTERO DI CRISTO - C. MAGGIONI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '13.00' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '22279' , 'CARISMA SALESIANO E BUONE PRATICHE - S. FERNANDO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '17201' , 'DOMANDE GRANDI DEI BAMBINI - COFANETTO' , '1' , '0' , '4' , '24.9000' , '24.9' , '0' , '35' , '16.19' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '18181' , 'MARCELLINO PANE E VINO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '18410' , 'SAN GIUSEPPE IL CUSTODE DELLAMORE - D. DEL GAUDIO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 10/04/2024 03:04:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91201' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '30' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '58.50' ) 10/04/2024 03:04:39 pm >> DELETE FROM ps_document WHERE id_document = '91024' 10/04/2024 03:04:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91024' 10/04/2024 03:12:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL001093' , '2024-04-03' , '' , '0' , '0' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.90' , '42.90' , NOW() , NOW() ) 10/04/2024 03:12:38 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 = '91202' 10/04/2024 03:12:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91202' 10/04/2024 03:12:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91202' , '22370' , 'DIGNITAS INFINITA' , '20' , '20' , '4' , '3.9000' , '3.9' , '0' , '45' , '42.90' ) 10/04/2024 03:12:42 pm >> DELETE FROM ps_document WHERE id_document = '91115' 10/04/2024 03:12:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91115' 10/04/2024 03:58:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1068' AND id_document != '91156' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-08') 10/04/2024 03:58:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1068', document_date = '2024-04-08', 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 = '43.00', price_tax_excluded = '35.25', date_upd = NOW() WHERE id_document = '91156' 10/04/2024 03:58:38 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 = '91156' 10/04/2024 03:58:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91156' 10/04/2024 03:58:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91156' , '18276' , 'CINGOLO CON NODI - 3280' , '14' , '-14' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '35.00' ) 10/04/2024 03:58:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91156' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/04/2024 03:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1046' AND id_document != '91126' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 10/04/2024 03:58:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1046', document_date = '2024-04-05', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91126' 10/04/2024 03:58:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91126' 10/04/2024 03:58:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91126' 10/04/2024 03:58:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91126' , '20516' , 'CROCE COMUNIONE - 42/08' , '45' , '-45' , '1' , '1' , '0.81967213114754' , '22' , '0' , '45.00' ) 10/04/2024 04:57:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1096' AND id_document != '91199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 04:57:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1096', document_date = '2024-04-10', 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 = '1700.00', price_tax_excluded = '1393.44', date_upd = NOW() WHERE id_document = '91199' 10/04/2024 04:57:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91199' 10/04/2024 04:57:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91199' 10/04/2024 04:57:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91199' , '18203' , 'CASULA SETA CON INTAGLIO - 70/521-1' , '1' , '-1' , '1' , '1700' , '1393.4426229508' , '22' , '0' , '1700.00' ) 10/04/2024 04:58:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/521-1' AND id_product != '18203' AND ean13 != '' 10/04/2024 04:58:05 pm >> UPDATE ps_product SET id_supplier = '129', reference = '', ean13 = '70/521-1', date_upd = NOW() WHERE id_product = '18203' 10/04/2024 04:58:05 pm >> UPDATE ps_product_lang SET name = 'CASULA SETA CON INTAGLIO - 70/521-1', description = '' WHERE id_product = '18203' 10/04/2024 04:58:05 pm >> UPDATE ps_product SET wholesale_price = '893.37', on_sale = '0', price = '1516.393442622951' WHERE id_product = '18203' 10/04/2024 04:58:05 pm >> UPDATE ps_product_shop SET wholesale_price = '893.37', price = '1516.393442622951', id_tax_rules_group = '1', id_category_default = '450', 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 = '18203' 10/04/2024 04:58:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '18203' 10/04/2024 05:51:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 05:51:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1098' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '135.25' , NOW() , NOW() ) 10/04/2024 05:51:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91203' 10/04/2024 05:51:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91203' 10/04/2024 05:51:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91203' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '55' , '45.081967213115' , '22' , '0' , '165.00' ) 10/04/2024 07:09:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 10/04/2024 07:09:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1099' , '2024-04-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 10/04/2024 07:09:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91204' 10/04/2024 07:09:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91204' 10/04/2024 07:09:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91204' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '49.00' )