09/05/2024 08:21:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049308' AND id_product != '22509' AND ean13 != '' 09/05/2024 08:21:37 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884049308', date_upd = NOW() WHERE id_product = '22509' 09/05/2024 08:21:37 am >> UPDATE ps_product_lang SET name = 'SANTA GEMMA E IL DIAVOLO - 8607', description = '' WHERE id_product = '22509' 09/05/2024 08:21:37 am >> UPDATE ps_product SET wholesale_price = '5.40', on_sale = '0', price = '9.0000' WHERE id_product = '22509' 09/05/2024 08:21:37 am >> UPDATE ps_product_shop SET wholesale_price = '5.40', price = '9.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22509' 09/05/2024 08:21:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22509' 09/05/2024 08:55:30 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/05/2024 08:55:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22510' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 08:55:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22510' , '1' , '1' , '2' , NOW() , NOW() ) 09/05/2024 08:55:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22510' , '0' , '1' , '0' , '0' ) 09/05/2024 08:56:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788888609546' AND id_product != '22510' AND ean13 != '' 09/05/2024 08:56:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788888609546', date_upd = NOW() WHERE id_product = '22510' 09/05/2024 08:56:08 am >> UPDATE ps_product_lang SET name = 'DA CUORE A CUORE - M. CROVETTO', description = '' WHERE id_product = '22510' 09/05/2024 08:56:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '22510' 09/05/2024 08:56:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '99', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22510' 09/05/2024 08:56:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22510' 09/05/2024 08:56:31 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 ( '33' , '2273' , '2024-05-07' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '22.40' , NOW() , NOW() ) 09/05/2024 08:56:31 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 = '91698' 09/05/2024 08:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91698' 09/05/2024 08:56:31 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 ( '91698' , '22432' , 'IN SINU JESU' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 09/05/2024 08:56:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47' 09/05/2024 08:56:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' ) 09/05/2024 08:56:31 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 ( '91698' , '22510' , 'DA CUORE A CUORE - M. CROVETTO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 09/05/2024 08:56:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '22510' AND id_supplier = '47' 09/05/2024 08:56:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22510' , '47' , '1' ) 09/05/2024 08:57:23 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 ( '33' , '10331' , '2024-05-07' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , 'CONTO DEPOSITO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '637.00' , '637.00' , NOW() , NOW() ) 09/05/2024 08:57:23 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 = '91699' 09/05/2024 08:57:23 am >> DELETE FROM ps_document_detail WHERE id_document = '91699' 09/05/2024 08:57:23 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 ( '91699' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '70' , '70' , '4' , '13.00' , '13' , '0' , '30' , '637.0000' ) 09/05/2024 08:57:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22214' AND id_supplier = '47' 09/05/2024 08:57:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22214' , '47' , '1' ) 09/05/2024 09:12:43 am >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 09:12:43 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 ( '24' , '58/A' , '2024-05-09' , 'A' , '319' , '0' , '4671020' , 'P.ZZA DON GERARDO FIORE 84080 CAPEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1099.00' , '1099.00' , NOW() , NOW() ) 09/05/2024 09:12:43 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 = '91700' 09/05/2024 09:12:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91700' 09/05/2024 09:12:43 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 ( '91700' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '71' , '-71' , '4' , '13.00' , '13' , '0' , '0' , '923.00' ) 09/05/2024 09:12:43 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 ( '91700' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '11' , '-11' , '4' , '16.00' , '16' , '0' , '0' , '176.00' ) 09/05/2024 09:56:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 09:56:04 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' , '1501' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.20' , '10.20' , NOW() , NOW() ) 09/05/2024 09:56:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91701' 09/05/2024 09:56:04 am >> DELETE FROM ps_document_detail WHERE id_document = '91701' 09/05/2024 09:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91701' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 09:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91701' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 09:56:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91701' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 09/05/2024 10:03:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1330' AND id_document != '91486' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-29') 09/05/2024 10:03:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1330', document_date = '2024-04-29', 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 = '225.00', price_tax_excluded = '184.43', date_upd = NOW() WHERE id_document = '91486' 09/05/2024 10:03:54 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 = '91486' 09/05/2024 10:03:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91486' 09/05/2024 10:03:54 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 ( '91486' , '16070' , 'CASULA - PCA020' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 09/05/2024 10:03:54 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 ( '91486' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 09/05/2024 10:03:54 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 ( '91486' , '18129' , 'TAU COLORATO - T56' , '15' , '-15' , '1' , '1' , '0.81967213114754' , '22' , '0' , '15.00' ) 09/05/2024 10:05:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1358' AND id_document != '91524' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 09/05/2024 10:05:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1358', document_date = '2024-04-30', 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 = '91.15', price_tax_excluded = '84.69', date_upd = NOW() WHERE id_document = '91524' 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91524' 09/05/2024 10:05:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91524' 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11178' , 'VENI CREATOR - 16 - OGGETTI' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11379' , 'VIENI SPIRITO SANTO - 35 ' , '38' , '-38' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '5.70' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/05/2024 10:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '18129' , 'TAU COLORATO - T56' , '5' , '-5' , '1' , '1.01' , '0.82786885245902' , '22' , '0' , '5.05' ) 09/05/2024 10:10:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 10:10:17 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' , '1502' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 09/05/2024 10:10:17 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 = '91702' 09/05/2024 10:10:17 am >> DELETE FROM ps_document_detail WHERE id_document = '91702' 09/05/2024 10:10:17 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 ( '91702' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 10:10:17 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 ( '91702' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 10:39:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 10:39:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1503' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 09/05/2024 10:39:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91703' 09/05/2024 10:39:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91703' 09/05/2024 10:39:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91703' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 09/05/2024 10:41:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1474' AND id_document != '91668' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 09/05/2024 10:41:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1474', document_date = '2024-05-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '91668' 09/05/2024 10:41: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 = '91668' 09/05/2024 10:41:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91668' 09/05/2024 10:41: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 ( '91668' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/05/2024 10:41: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 ( '91668' , '20062' , 'BRACCIALE DECINA - BD018' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 09/05/2024 10:41: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 ( '91668' , '20072' , 'BRACCIALE - BC1759N' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 09/05/2024 10:41: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 ( '91668' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/05/2024 10:41:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1152' AND id_document != '91269' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-15') 09/05/2024 10:41:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1152', document_date = '2024-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '231.20', price_tax_excluded = '196.46', date_upd = NOW() WHERE id_document = '91269' 09/05/2024 10:41:57 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 = '91269' 09/05/2024 10:41:57 am >> DELETE FROM ps_document_detail WHERE id_document = '91269' 09/05/2024 10:41:57 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 ( '91269' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '21' , '-21' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '25.20' ) 09/05/2024 10:41:57 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 ( '91269' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/05/2024 10:41:57 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 ( '91269' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/05/2024 10:41:57 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 ( '91269' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 09/05/2024 10:41:57 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 ( '91269' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '15' , '-15' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '112.50' ) 09/05/2024 10:41:57 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 ( '91269' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 09/05/2024 10:41:57 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 ( '91269' , '7202' , 'ARTICOLI RELIGIOSI' , '7' , '-7' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '52.50' ) 09/05/2024 10:42:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3797' AND id_document != '89226' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 09/05/2024 10:42:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3797', document_date = '2023-11-29', 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 = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '89226' 09/05/2024 10:42:40 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 = '89226' 09/05/2024 10:42:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89226' 09/05/2024 10:42:40 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 ( '89226' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' ) 09/05/2024 10:43:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '89037' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 09/05/2024 10:43:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3662', document_date = '2023-11-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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '89037' 09/05/2024 10:43:29 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 = '89037' 09/05/2024 10:43:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89037' 09/05/2024 10:43:29 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 ( '89037' , '7930' , 'PERGAMENE - BATTESIMO MOD. D' , '24' , '-24' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.00' ) 09/05/2024 10:43:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3383' AND id_document != '88614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-30') 09/05/2024 10:43:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3383', document_date = '2023-10-30', 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 = '42.90', price_tax_excluded = '37.22', date_upd = NOW() WHERE id_document = '88614' 09/05/2024 10:43:49 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 = '88614' 09/05/2024 10:43:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88614' 09/05/2024 10:43:49 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 ( '88614' , '20965' , 'STATUA SAN MICHELE - ST332-SM' , '1' , '-1' , '1' , '19.5000' , '15.983606557377' , '22' , '0' , '19.50' ) 09/05/2024 10:43:49 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 ( '88614' , '11223' , 'VERGINE DI GUADALUPE - 8590' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 09/05/2024 10:43:49 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 ( '88614' , '17005' , 'BIGLIETTO AUGURALE medio' , '12' , '-12' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '12.00' ) 09/05/2024 10:44:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1190' AND id_document != '91316' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 09/05/2024 10:44:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1190', document_date = '2024-04-17', 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 = '49.40', price_tax_excluded = '40.49', date_upd = NOW() WHERE id_document = '91316' 09/05/2024 10:44:50 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 = '91316' 09/05/2024 10:44:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91316' 09/05/2024 10:44:50 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 ( '91316' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '20' , '-20' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '24.00' ) 09/05/2024 10:44:50 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 ( '91316' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 09/05/2024 10:44:50 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 ( '91316' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 09/05/2024 10:44:50 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 ( '91316' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 09/05/2024 10:44:50 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 ( '91316' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 09/05/2024 10:45:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1236' AND id_document != '91370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-22') 09/05/2024 10:45:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1236', document_date = '2024-04-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '162.60', price_tax_excluded = '133.28', date_upd = NOW() WHERE id_document = '91370' 09/05/2024 10:45:22 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 = '91370' 09/05/2024 10:45:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91370' 09/05/2024 10:45:22 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 ( '91370' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '40' , '-40' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '140.00' ) 09/05/2024 10:45:23 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 ( '91370' , '12142' , 'MADONNA DI FATIMA - 157BIS' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 09/05/2024 10:45:23 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 ( '91370' , '20516' , 'CROCE COMUNIONE - 42/08' , '12' , '-12' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '15.60' ) 09/05/2024 10:54:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 10:54:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1504' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '22.40' , NOW() , NOW() ) 09/05/2024 10:54:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91704' 09/05/2024 10:54:14 am >> DELETE FROM ps_document_detail WHERE id_document = '91704' 09/05/2024 10:54:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91704' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.04' , '0.04' , '0' , '0' , '22.40' ) 09/05/2024 10:56:31 am >> SELECT document_num FROM ps_document WHERE document_num = '776' AND id_document != '90789' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 09/05/2024 10:56:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '776', document_date = '2024-03-16', 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 = '180.40', price_tax_excluded = '151.77', date_upd = NOW() WHERE id_document = '90789' 09/05/2024 10:56:31 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 = '90789' 09/05/2024 10:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '90789' 09/05/2024 10:56:31 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 ( '90789' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 09/05/2024 10:56:31 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 ( '90789' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 09/05/2024 10:56:31 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 ( '90789' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 09/05/2024 10:56:31 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 ( '90789' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 09/05/2024 10:56:31 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 ( '90789' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 09/05/2024 10:56:31 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 ( '90789' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 09/05/2024 10:56:31 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 ( '90789' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/05/2024 10:56:56 am >> SELECT document_num FROM ps_document WHERE document_num = '576' AND id_document != '90524' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-27') 09/05/2024 10:56:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '576', document_date = '2024-02-27', 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 = '55.50', price_tax_excluded = '46.34', date_upd = NOW() WHERE id_document = '90524' 09/05/2024 10:56: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 = '90524' 09/05/2024 10:56:56 am >> DELETE FROM ps_document_detail WHERE id_document = '90524' 09/05/2024 10:56: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 ( '90524' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '10' , '27.00' ) 09/05/2024 10:56: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 ( '90524' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '150' , '-150' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '22.50' ) 09/05/2024 10:56: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 ( '90524' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 09/05/2024 11:03:50 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' , '242/1' , '2022-04-21' , '1' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '223.26' , '183.00' , NOW() , NOW() ) 09/05/2024 11:03:50 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 = '91705' 09/05/2024 11:03:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91705' 09/05/2024 11:03:50 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 ( '91705' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '30' , '30' , '1' , '10' , '8.1967213114754' , '22' , '50' , '183.0000' ) 09/05/2024 11:03:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '50' 09/05/2024 11:03:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '50' , '1' ) 09/05/2024 11:03:51 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 ( '91705' , '' , 'arrotondamento' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '0' , '21.9600' ) 09/05/2024 11:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '50' 09/05/2024 11:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '50' , '1' ) 09/05/2024 11:05:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 11:05:29 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' , '1505' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.84' , NOW() , NOW() ) 09/05/2024 11:05:29 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 = '91706' 09/05/2024 11:05:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91706' 09/05/2024 11:05:29 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 ( '91706' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 09/05/2024 11:05: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 ( '91706' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/05/2024 11:11:39 am >> SELECT document_num FROM ps_document WHERE document_num = '777' AND id_document != '90790' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-16') 09/05/2024 11:11:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '777', document_date = '2024-03-16', 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 = '145.00', price_tax_excluded = '118.85', date_upd = NOW() WHERE id_document = '90790' 09/05/2024 11:11: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 = '90790' 09/05/2024 11:11:39 am >> DELETE FROM ps_document_detail WHERE id_document = '90790' 09/05/2024 11:11: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 ( '90790' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 09/05/2024 11:11: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 ( '90790' , '19860' , 'FERMAGLIO - B250/CA' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 09/05/2024 11:11: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 ( '90790' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/05/2024 11:16:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 11:16:54 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' , '1506' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '119.00' , NOW() , NOW() ) 09/05/2024 11:16:54 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 = '91707' 09/05/2024 11:16:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91707' 09/05/2024 11:16:54 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 ( '91707' , '22506' , 'DIGNITAS INFINITA' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '5' , '119.00' ) 09/05/2024 11:21:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 11:21:31 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' , '1507' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.10' , '12.10' , NOW() , NOW() ) 09/05/2024 11:21:31 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 = '91708' 09/05/2024 11:21:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91708' 09/05/2024 11:21:31 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 ( '91708' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 09/05/2024 11:21:31 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 ( '91708' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '5' , '8.60' ) 09/05/2024 12:24:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 12:24:51 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' , '1508' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 09/05/2024 12:24:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91709' 09/05/2024 12:24:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91709' 09/05/2024 12:24:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91709' , '22046' , 'CLERGY HARMONIUS ML - C 27' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 09/05/2024 12:24:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91709' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 09/05/2024 12:34:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 12:34:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1509' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 09/05/2024 12:34:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91710' 09/05/2024 12:34:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91710' 09/05/2024 12:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91710' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 09/05/2024 02:33:51 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/05/2024 02:33:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22511' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 02:33:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22511' , '1' , '1' , '2' , NOW() , NOW() ) 09/05/2024 02:33:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22511' , '0' , '1' , '0' , '0' ) 09/05/2024 02:34:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618107' AND id_product != '22511' AND ean13 != '' 09/05/2024 02:34:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281618107', date_upd = NOW() WHERE id_product = '22511' 09/05/2024 02:34:42 pm >> UPDATE ps_product_lang SET name = 'VIVE - CD', description = '' WHERE id_product = '22511' 09/05/2024 02:34:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '22511' 09/05/2024 02:34:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22511' 09/05/2024 02:34:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22511' 09/05/2024 02:34:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22511' 09/05/2024 02:34:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22512' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 02:34:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22512' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22511' 09/05/2024 02:34:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22512' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22511' 09/05/2024 02:35:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618077' AND id_product != '22512' AND ean13 != '' 09/05/2024 02:35:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281618077', date_upd = NOW() WHERE id_product = '22512' 09/05/2024 02:35:11 pm >> UPDATE ps_product_lang SET name = 'VIVE - AGGIUNTA CANTI', description = '' WHERE id_product = '22512' 09/05/2024 02:35:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '22512' 09/05/2024 02:35:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22512' 09/05/2024 02:35:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '22512' 09/05/2024 02:35:12 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22512' 09/05/2024 02:35:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22513' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 02:35:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22513' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22512' 09/05/2024 02:35:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22513' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22512' 09/05/2024 02:35:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618091' AND id_product != '22513' AND ean13 != '' 09/05/2024 02:35:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281618091', date_upd = NOW() WHERE id_product = '22513' 09/05/2024 02:35:36 pm >> UPDATE ps_product_lang SET name = 'VIVE - SPARTITO', description = '' WHERE id_product = '22513' 09/05/2024 02:35:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.538461538461538' WHERE id_product = '22513' 09/05/2024 02:35:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.538461538461538', id_tax_rules_group = '3', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22513' 09/05/2024 02:35:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '22513' 09/05/2024 02:35:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22513' 09/05/2024 02:35:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22514' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 02:35:37 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22514' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22513' 09/05/2024 02:35:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22514' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22513' 09/05/2024 02:36:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618039' AND id_product != '22514' AND ean13 != '' 09/05/2024 02:36:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281618039', date_upd = NOW() WHERE id_product = '22514' 09/05/2024 02:36:12 pm >> UPDATE ps_product_lang SET name = 'VIVE - AGGIUNTA SPARTITI', description = '' WHERE id_product = '22514' 09/05/2024 02:36:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.615384615384615' WHERE id_product = '22514' 09/05/2024 02:36:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.615384615384615', id_tax_rules_group = '3', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22514' 09/05/2024 02:36:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22514' 09/05/2024 02:36:13 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22514' 09/05/2024 02:36:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22515' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 02:36:13 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22515' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22514' 09/05/2024 02:36:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22515' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22514' 09/05/2024 02:38:33 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' , '664202' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '7' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '262.85' , '260.32' , NOW() , NOW() ) 09/05/2024 02:38:33 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 = '91711' 09/05/2024 02:38:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91711' 09/05/2024 02:38: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 ( '91711' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 09/05/2024 02:38: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 ( '91711' , '22511' , 'VIVE - CD' , '12' , '12' , '4' , '16.90' , '16.9' , '0' , '27' , '148.0440' ) 09/05/2024 02:38: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 ( '91711' , '22511' , 'VIVE - CD' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '100' , '0.0000' ) 09/05/2024 02:38: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 ( '91711' , '22513' , 'VIVE - SPARTITO' , '5' , '5' , '3' , '11.53' , '11.086538461538' , '4' , '27' , '43.7679' ) 09/05/2024 02:38: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 ( '91711' , '22512' , 'VIVE - AGGIUNTA CANTI' , '12' , '12' , '4' , '4.50' , '4.5' , '0' , '27' , '39.4200' ) 09/05/2024 02:38: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 ( '91711' , '22512' , 'VIVE - AGGIUNTA CANTI' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '100' , '0.0000' ) 09/05/2024 02:38:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22514' , 'VIVE - AGGIUNTA SPARTITI' , '3' , '3' , '3' , '9.61' , '9.2403846153846' , '4' , '27' , '21.8877' ) 09/05/2024 03:04:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 03:04:31 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' , '1510' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 09/05/2024 03:04:31 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 = '91712' 09/05/2024 03:04:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91712' 09/05/2024 03:04:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91712' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 03:04:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91712' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2024 03:24:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016864' AND id_product != '22515' AND ean13 != '' 09/05/2024 03:24:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016864', date_upd = NOW() WHERE id_product = '22515' 09/05/2024 03:24:28 pm >> UPDATE ps_product_lang SET name = 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L', description = '' WHERE id_product = '22515' 09/05/2024 03:24:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '83.60655737704919' WHERE id_product = '22515' 09/05/2024 03:24:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '83.60655737704919', id_tax_rules_group = '1', id_category_default = '147', 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 = '22515' 09/05/2024 03:24:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22515' 09/05/2024 03:25:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016864' AND id_product != '22515' AND ean13 != '' 09/05/2024 03:25:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016864', date_upd = NOW() WHERE id_product = '22515' 09/05/2024 03:25:04 pm >> UPDATE ps_product_lang SET name = 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L', description = '' WHERE id_product = '22515' 09/05/2024 03:25:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '83.60655737704919' WHERE id_product = '22515' 09/05/2024 03:25:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '83.60655737704919', id_tax_rules_group = '1', id_category_default = '147', 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 = '22515' 09/05/2024 03:25:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22515' 09/05/2024 03:25:05 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22515' 09/05/2024 03:25:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22516' , '1' , '' , 'nuovo-prodotto' ) 09/05/2024 03:25:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22516' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22515' 09/05/2024 03:25:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22516' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22515' 09/05/2024 03:26:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 03:26: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' , '1511' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 09/05/2024 03:26: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 = '91713' 09/05/2024 03:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91713' 09/05/2024 03:26: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 ( '91713' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 09/05/2024 03:28:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000013542' AND id_product != '22516' AND ean13 != '' 09/05/2024 03:28:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000013542', date_upd = NOW() WHERE id_product = '22516' 09/05/2024 03:28:52 pm >> UPDATE ps_product_lang SET name = 'completo battesimo - 525', description = '' WHERE id_product = '22516' 09/05/2024 03:28:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '22516' 09/05/2024 03:28:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '147', 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 = '22516' 09/05/2024 03:28:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22516' 09/05/2024 03:29:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000050' AND id_product != '2532' AND ean13 != '' 09/05/2024 03:29:30 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000050', date_upd = NOW() WHERE id_product = '2532' 09/05/2024 03:29:30 pm >> UPDATE ps_product_lang SET name = 'COMPLETO BATTESIMO - 525', description = '' WHERE id_product = '2532' 09/05/2024 03:29:30 pm >> UPDATE ps_product SET wholesale_price = '44.65', on_sale = '0', price = '102.45901639344262' WHERE id_product = '2532' 09/05/2024 03:29:30 pm >> UPDATE ps_product_shop SET wholesale_price = '44.65', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '147', 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 = '2532' 09/05/2024 03:29:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '2532' 09/05/2024 03:31:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000067' AND id_product != '1364' AND ean13 != '' 09/05/2024 03:31:23 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000067', date_upd = NOW() WHERE id_product = '1364' 09/05/2024 03:31:23 pm >> UPDATE ps_product_lang SET name = 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680', description = '' WHERE id_product = '1364' 09/05/2024 03:31:23 pm >> UPDATE ps_product SET wholesale_price = '85.03', on_sale = '0', price = '179.5081967213115' WHERE id_product = '1364' 09/05/2024 03:31:23 pm >> UPDATE ps_product_shop SET wholesale_price = '85.03', price = '179.5081967213115', id_tax_rules_group = '1', id_category_default = '147', 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 = '1364' 09/05/2024 03:31:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '1364' 09/05/2024 03:34:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1535' , '2024-05-07' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '455.01' , '372.96' , NOW() , NOW() ) 09/05/2024 03:34:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91714' 09/05/2024 03:34:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91714' 09/05/2024 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91714' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '1' , '1' , '38' , '31.147540983607' , '22' , '5' , '44.0420' ) 09/05/2024 03:34:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16051' AND id_supplier = '12' 09/05/2024 03:34:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16051' , '12' , '1' ) 09/05/2024 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91714' , '19108' , 'PORTATECA COMPLETA - 947' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 09/05/2024 03:34:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19108' AND id_supplier = '12' 09/05/2024 03:34:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19108' , '12' , '1' ) 09/05/2024 03:34:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91714' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '1' , '1' , '41.5' , '34.016393442623' , '22' , '5' , '48.0985' ) 09/05/2024 03:34:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '12' , '1' ) 09/05/2024 03:34: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 ( '91714' , '22515' , 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L' , '2' , '2' , '1' , '42' , '34.426229508197' , '22' , '5' , '97.3560' ) 09/05/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22515' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22515' , '12' , '1' ) 09/05/2024 03:34: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 ( '91714' , '2532' , 'COMPLETO BATTESIMO - 525' , '1' , '1' , '1' , '54' , '44.262295081967' , '22' , '5' , '62.5860' ) 09/05/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2532' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2532' , '12' , '1' ) 09/05/2024 03:34: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 ( '91714' , '22052' , 'CUSTODIA BIBBIA GERUSALEMME STUDIO - 744' , '1' , '1' , '1' , '15.5' , '12.704918032787' , '22' , '5' , '17.9645' ) 09/05/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22052' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22052' , '12' , '1' ) 09/05/2024 03:34: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 ( '91714' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '1' , '1' , '94' , '77.049180327869' , '22' , '5' , '108.9460' ) 09/05/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1364' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1364' , '12' , '1' ) 09/05/2024 03:34: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 ( '91714' , '22218' , 'PISSIDE MINI - 896' , '1' , '1' , '1' , '33' , '27.049180327869' , '22' , '5' , '38.2470' ) 09/05/2024 03:34:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22218' AND id_supplier = '12' 09/05/2024 03:34:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22218' , '12' , '1' ) 09/05/2024 04:06:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 04:06:31 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' , '1512' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 09/05/2024 04:06:31 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 = '91715' 09/05/2024 04:06:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91715' 09/05/2024 04:06:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91715' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 09/05/2024 04:17:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1513' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 04:17:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1513' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.39' , '27.49' , NOW() , NOW() ) 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91716' 09/05/2024 04:17:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91716' 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91716' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91716' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91716' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91716' , '370' , 'ALBUM DELLA MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 09/05/2024 04:17:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91716' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 09/05/2024 04:20:22 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '664202', document_date = '2024-05-08', document_letter = '', id_customer = '0', id_supplier = '7', id_address = '2602', address1 = '', address2 = '', note = '', price_shipping = '7.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 = '262.85', price_tax_excluded = '260.32', date_upd = NOW() WHERE id_document = '91711' 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91711' 09/05/2024 04:20:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91711' 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22511' , 'VIVE - CD' , '12' , '12' , '4' , '16.9000' , '16.9' , '0' , '27' , '148.04' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22511' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22511' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22511' , 'VIVE - CD' , '1' , '1' , '4' , '16.9000' , '16.9' , '0' , '100' , '0.00' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22511' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22511' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22513' , 'VIVE - SPARTITO' , '5' , '5' , '3' , '11.5300' , '11.086538461538' , '4' , '27' , '43.77' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22513' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22513' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22512' , 'VIVE - AGGIUNTA CANTI' , '12' , '12' , '4' , '4.5000' , '4.5' , '0' , '27' , '39.42' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22512' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22512' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22512' , 'VIVE - AGGIUNTA CANTI' , '1' , '1' , '4' , '4.5000' , '4.5' , '0' , '100' , '0.00' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22512' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22512' , '7' , '1' ) 09/05/2024 04:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91711' , '22514' , 'VIVE - AGGIUNTA SPARTITI' , '3' , '3' , '3' , '9.6100' , '9.2403846153846' , '4' , '27' , '21.89' ) 09/05/2024 04:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22514' AND id_supplier = '7' 09/05/2024 04:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22514' , '7' , '1' ) 09/05/2024 04:44:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 04:44:40 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' , '22' , '2024-05-09' , '' , '7084' , '0' , '172691778' , 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.90' , '142.90' , NOW() , NOW() ) 09/05/2024 04:44:40 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 = '14468' 09/05/2024 04:44:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '14468' 09/05/2024 04:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '50' , '-50' , '4' , '1.80' , '1.8' , '0' , '5' , '85.50' ) 09/05/2024 04:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '5' , '47.50' ) 09/05/2024 04:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '' , 'immagini' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 09/05/2024 04:53:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 04:53:39 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' , '1514' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '59.41' , NOW() , NOW() ) 09/05/2024 04:53:39 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 = '91717' 09/05/2024 04:53:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91717' 09/05/2024 04:53:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91717' , '17841' , 'QUADRO DECORATO 42X32' , '1' , '-1' , '1' , '58.75' , '48.155737704918' , '22' , '0' , '58.75' ) 09/05/2024 04:53:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91717' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '15' , '-15' , '4' , '0.75' , '0.75' , '0' , '0' , '11.25' ) 09/05/2024 05:17:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '90934' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-25') 09/05/2024 05:17:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2024-03-25', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '306.82', price_tax_excluded = '272.13', date_upd = NOW() WHERE id_document = '90934' 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90934' 09/05/2024 05:17:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90934' 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '6019' , 'LUMINO ROSSO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.50' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '6014' , 'LUMINO BIANCO - 10B' , '18' , '-18' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '9.00' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '20437' , 'LUMINO BIANCO 10BTS000' , '9' , '-9' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '4.50' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '' , '09/05/2024' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '29' , '-29' , '4' , '2.80' , '2.8' , '0' , '15' , '69.02' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '26' , '-26' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '18.20' ) 09/05/2024 05:17:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 09/05/2024 05:19:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '14468' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 05:19:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '22', document_date = '2024-05-09', document_letter = '', id_customer = '7084', id_supplier = '', id_address = '172691778', address1 = 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '142.90', price_tax_excluded = '142.90', date_upd = NOW() WHERE id_document = '14468' 09/05/2024 05:19:39 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 = '14468' 09/05/2024 05:19:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '14468' 09/05/2024 05:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '50' , '-50' , '4' , '1.8000' , '1.8' , '0' , '5' , '85.50' ) 09/05/2024 05:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '5' , '47.50' ) 09/05/2024 05:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14468' , '0' , 'immagini' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 09/05/2024 05:23:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 05:23:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1515' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 09/05/2024 05:23:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91718' 09/05/2024 05:23:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91718' 09/05/2024 05:23:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91718' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 09/05/2024 06:12:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 06:12:56 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' , '1516' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 09/05/2024 06:12:56 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 = '91719' 09/05/2024 06:12:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '91719' 09/05/2024 06:12: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 ( '91719' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 09/05/2024 06:12: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 ( '91719' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 09/05/2024 06:41:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-09') 09/05/2024 06:41:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1517' , '2024-05-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.20' , NOW() , NOW() ) 09/05/2024 06:41:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91720' 09/05/2024 06:41:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91720' 09/05/2024 06:41:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91720' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' )