07/05/2024 09:04:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '61/2024' , '2024-05-02' , '2024' , '0' , '139' , '4670854' , 'VIA SAN SILVESTRO 16 06053 DERUTA ' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '154.45' , '126.60' , NOW() , NOW() ) 07/05/2024 09:04:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91652' 07/05/2024 09:04:08 am >> DELETE FROM ps_document_detail WHERE id_document = '91652' 07/05/2024 09:04:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91652' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '6' , '6' , '1' , '18.6' , '15.245901639344' , '22' , '0' , '136.1520' ) 07/05/2024 09:04:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '16761' AND id_supplier = '139' 07/05/2024 09:04:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16761' , '139' , '1' ) 07/05/2024 09:25:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 09:25:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1462' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.11' , '38.05' , NOW() , NOW() ) 07/05/2024 09:25: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 = '91653' 07/05/2024 09:25:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91653' 07/05/2024 09:25: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 ( '91653' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 07/05/2024 09:25: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 ( '91653' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 07/05/2024 09:25: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 ( '91653' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '5' , '15.96' ) 07/05/2024 09:25: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 ( '91653' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/05/2024 09:25: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 ( '91653' , '22390' , 'ROSARIO DELLA GUARIGIONE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/05/2024 09:25: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 ( '91653' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 07/05/2024 09:25: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 ( '91653' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 07/05/2024 09:25: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 ( '91653' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 07/05/2024 09:42:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1460' AND id_document != '91650' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 07/05/2024 09:42:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1460', document_date = '2024-05-06', 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 = '5.80', price_tax_excluded = '4.75', date_upd = NOW() WHERE id_document = '91650' 07/05/2024 09:42:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91650' 07/05/2024 09:42:03 am >> DELETE FROM ps_document_detail WHERE id_document = '91650' 07/05/2024 09:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91650' , '13364' , 'CORONA MM 6 ' , '2' , '-2' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '5.80' ) 07/05/2024 09:47:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001463' AND id_product != '16761' AND ean13 != '' 07/05/2024 09:47:59 am >> UPDATE ps_product SET id_supplier = '139', reference = '', ean13 = '001463', date_upd = NOW() WHERE id_product = '16761' 07/05/2024 09:47:59 am >> UPDATE ps_product_lang SET name = 'LAMPADA MARIANA - 096DP2K', description = '' WHERE id_product = '16761' 07/05/2024 09:47:59 am >> UPDATE ps_product SET wholesale_price = '17.70', on_sale = '0', price = '36.885245901639344' WHERE id_product = '16761' 07/05/2024 09:47:59 am >> UPDATE ps_product_shop SET wholesale_price = '17.70', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '228', 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 = '16761' 07/05/2024 09:47:59 am >> DELETE FROM ps_specific_price WHERE id_product = '16761' 07/05/2024 09:53:18 am >> SELECT document_num FROM ps_document WHERE document_num = '57/A' AND id_document != '91587' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-03') 07/05/2024 09:53:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '57/A', document_date = '2024-05-03', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '1357.00', price_tax_excluded = '1121.31', date_upd = NOW() WHERE id_document = '91587' 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91587' 07/05/2024 09:53:18 am >> DELETE FROM ps_document_detail WHERE id_document = '91587' 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91587' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '16.00' ) 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91587' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91587' , '22462' , 'ROSARIO SAN MICHELE PERSONALIZZATO CRISTALLO - RL 7537C' , '132' , '-132' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '594.00' ) 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91587' , '22461' , 'ROSARIO SAN MICHELE PERSONALIZZATO LEGNO - RL 753' , '168' , '-168' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '672.00' ) 07/05/2024 09:53:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91587' , '' , 'suppliche' , '5' , '-5' , '0' , '10' , '10' , '' , '0' , '50.00' ) 07/05/2024 09:59:47 am >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '90464' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-22') 07/05/2024 09:59:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9', document_date = '2024-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESA - n. c. ricevuta', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '233.30', price_tax_excluded = '233.30', date_upd = NOW() WHERE id_document = '90464' 07/05/2024 09:59:47 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 = '90464' 07/05/2024 09:59:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90464' 07/05/2024 09:59:47 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 ( '90464' , '21474' , 'QUESTA CASA E TUA PICCOLISSIMI - 3/5 ANNI' , '2' , '-2' , '4' , '16.5000' , '16.5' , '0' , '0' , '33.00' ) 07/05/2024 09:59:47 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 ( '90464' , '21471' , 'QUESTA CASA E TUA 2 - 9/11 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 07/05/2024 09:59:47 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 ( '90464' , '203' , 'ACCOMPAGNARE I MINISTRANTI' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '0' , '6.90' ) 07/05/2024 09:59:47 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 ( '90464' , '21771' , 'UNA VOCE CI GUIDA - 7/10 ANNI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 07/05/2024 09:59:47 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 ( '90464' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 07/05/2024 09:59:47 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 ( '90464' , '21472' , 'EFFETTO DOMINO - 15/18 ANNI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 07/05/2024 09:59:47 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 ( '90464' , '19836' , 'MISTERO MISTAGOGIA MISTICA - Y DE ANDIA' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 07/05/2024 09:59:48 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 ( '90464' , '19916' , 'VINO NUOVO IN OTRI NUOVI ANNO A - R. GIUE' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 07/05/2024 09:59:48 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 ( '90464' , '21551' , 'PRIMA NASCITA E LA SECONDA - G. ANGELINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 07/05/2024 09:59:48 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 ( '90464' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '1' , '-1' , '4' , '15.9000' , '15.9' , '0' , '0' , '15.90' ) 07/05/2024 09:59:48 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 ( '90464' , '19957' , 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 07/05/2024 09:59:48 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 ( '90464' , '19451' , 'CHE COSA VUOI CHE IO FACCIA? - E. MANICARDI' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 07/05/2024 09:59:48 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 ( '90464' , '21427' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 07/05/2024 09:59:48 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 ( '90464' , '19200' , 'SANTI, INSIEME NELLAMORE - V. FORTINI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 07/05/2024 10:00:03 am >> DELETE FROM ps_document WHERE id_document = '90601' 07/05/2024 10:00:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90601' 07/05/2024 10:01:02 am >> SELECT document_num FROM ps_document WHERE document_num = '57/A' AND id_document != '91587' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-03') 07/05/2024 10:01:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '57/A', document_date = '2024-05-03', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '1364.00', price_tax_excluded = '1128.04', date_upd = NOW() WHERE id_document = '91587' 07/05/2024 10:01:02 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 = '91587' 07/05/2024 10:01:02 am >> DELETE FROM ps_document_detail WHERE id_document = '91587' 07/05/2024 10:01:02 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 ( '91587' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '16.00' ) 07/05/2024 10:01:02 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 ( '91587' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 07/05/2024 10:01:02 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 ( '91587' , '22462' , 'ROSARIO SAN MICHELE PERSONALIZZATO CRISTALLO - RL 7537C' , '132' , '-132' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '594.00' ) 07/05/2024 10:01:02 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 ( '91587' , '22461' , 'ROSARIO SAN MICHELE PERSONALIZZATO LEGNO - RL 753' , '168' , '-168' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '672.00' ) 07/05/2024 10:01:02 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 ( '91587' , '0' , 'suppliche' , '5' , '-5' , '0' , '10.0000' , '10' , '0' , '0' , '50.00' ) 07/05/2024 10:01:02 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 ( '91587' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 07/05/2024 10:50:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1463' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 10:50:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1463' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '239.00' , '195.90' , NOW() , NOW() ) 07/05/2024 10:50: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 = '91654' 07/05/2024 10:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91654' 07/05/2024 10:50: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 ( '91654' , '19751' , 'INCENSO JOHANNES' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 07/05/2024 10:50: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 ( '91654' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 07/05/2024 10:50: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 ( '91654' , '18902' , 'TURIBOLO CM 24' , '1' , '-1' , '1' , '165.00' , '135.24590163934' , '22' , '0' , '165.00' ) 07/05/2024 10:50: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 ( '91654' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 07/05/2024 11:02:50 am >> UPDATE ps_document SET id_document_type = '33', document_num = '1967', document_date = '2024-04-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = '', price_shipping = '5.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 = '58.90', price_tax_excluded = '58.90', date_upd = NOW() WHERE id_document = '91369' 07/05/2024 11:02: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 = '91369' 07/05/2024 11:02:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91369' 07/05/2024 11:02: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 ( '91369' , '22427' , 'ALLASCOLTO DELLA PAROLA - M. DELBREL' , '1' , '1' , '4' , '9.5000' , '9.5' , '0' , '30' , '6.65' ) 07/05/2024 11:02: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 ( '91369' , '22428' , 'PRETE SI CONFESSA - A. PRONZATO' , '1' , '1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 07/05/2024 11:02: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 ( '91369' , '22429' , 'DAVIDE IL BAMBINO - C. SIGNORELLI' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 07/05/2024 11:02: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 ( '91369' , '22432' , 'IN SINU JESU' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 07/05/2024 11:02: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 ( '91369' , '22430' , 'MADONNA DI FATIMA - W. WALSH' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 07/05/2024 11:02: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 ( '91369' , '22431' , 'TANTO LAMORE SI E CHINATO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 07/05/2024 11:02: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 ( '91369' , '22109' , 'QUINDICI MINUTI S. ANTONIO MARIA CLARET' , '5' , '5' , '4' , '0.5000' , '0.5' , '0' , '30' , '1.7500' ) 07/05/2024 11:02:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '962' , '2024-04-30' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.27' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.17' , '59.17' , NOW() , NOW() ) 07/05/2024 11:02: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 = '91655' 07/05/2024 11:02:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91655' 07/05/2024 11:42:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1436' AND id_document != '91618' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 07/05/2024 11:42:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1436', document_date = '2024-05-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91618' 07/05/2024 11:42:48 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 = '91618' 07/05/2024 11:42:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91618' 07/05/2024 11:42:48 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 ( '91618' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 07/05/2024 11:43:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1464' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 11:43: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' , '1464' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 07/05/2024 11:43: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 = '91656' 07/05/2024 11:43:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91656' 07/05/2024 11:43: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 ( '91656' , '7442' , 'PANE QUOTIDIANO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/05/2024 11:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1445' AND id_document != '91633' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 07/05/2024 11:45:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1445', document_date = '2024-05-06', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '91633' 07/05/2024 11:45:21 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 = '91633' 07/05/2024 11:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91633' 07/05/2024 11:45:21 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 ( '91633' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 07/05/2024 12:15:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 12:15:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1465' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.90' , '49.66' , NOW() , NOW() ) 07/05/2024 12:15:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91657' 07/05/2024 12:15:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '91657' 07/05/2024 12:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91657' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 07/05/2024 12:15:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91657' , '21082' , 'BRACCIALE ARG. ESAGONALE - 1941CAV' , '1' , '-1' , '1' , '23.50' , '19.262295081967' , '22' , '0' , '23.50' ) 07/05/2024 02:35:01 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 07/05/2024 02:35:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22507' , '1' , '' , 'nuovo-prodotto' ) 07/05/2024 02:35:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22507' , '1' , '1' , '2' , NOW() , NOW() ) 07/05/2024 02:35:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22507' , '0' , '1' , '0' , '0' ) 07/05/2024 02:35:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608969' AND id_product != '22507' AND ean13 != '' 07/05/2024 02:35:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608969', date_upd = NOW() WHERE id_product = '22507' 07/05/2024 02:35:38 pm >> UPDATE ps_product_lang SET name = 'SPES NON CONFUNDIT', description = '' WHERE id_product = '22507' 07/05/2024 02:35:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '22507' 07/05/2024 02:35:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22507' 07/05/2024 02:35:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22507' 07/05/2024 02:35:38 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 = '22507' 07/05/2024 02:35:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22508' , '1' , '' , 'nuovo-prodotto' ) 07/05/2024 02:35:39 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 '22508' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22507' 07/05/2024 02:35:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22508' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22507' 07/05/2024 02:35:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024-DL001613' , '2024-05-06' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 07/05/2024 02:35:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91658' 07/05/2024 02:35:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '91658' 07/05/2024 02:35:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91658' , '22507' , 'SPES NON CONFUNDIT' , '30' , '30' , '4' , '2.00' , '2' , '0' , '45' , '33.0000' ) 07/05/2024 02:35:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 07/05/2024 02:35:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 07/05/2024 02:37:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024DL001630' , '2024-05-06' , '' , '2983' , '0' , '4669436' , 'VIA DELLA POSTA 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.75' , '153.75' , NOW() , NOW() ) 07/05/2024 02:37:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91659' 07/05/2024 02:37:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91659' 07/05/2024 02:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91659' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 07/05/2024 02:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91659' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '2' , '2' , '4' , '90.00' , '90' , '0' , '35' , '117.0000' ) 07/05/2024 02:37:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91659' , '10565' , 'TEOLOGIA DELLA LITURGIA - J. RATZINGER' , '1' , '1' , '4' , '55.00' , '55' , '0' , '45' , '30.2500' ) 07/05/2024 03:05:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 03:05: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' , '1466' , '2024-05-07' , '' , '0' , '0' , '0' , 'VIA GIUDECA 84022 CAMPAGNA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '214.89' , '185.86' , NOW() , NOW() ) 07/05/2024 03:05: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 = '91660' 07/05/2024 03:05:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91660' 07/05/2024 03:05: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 ( '91660' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 07/05/2024 03:05: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 ( '91660' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '16' , '-16' , '4' , '2.4000' , '2.4' , '0' , '15' , '32.64' ) 07/05/2024 03:05: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 ( '91660' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '18' , '-18' , '1' , '0.7000' , '0.5738' , '22' , '0' , '12.60' ) 07/05/2024 03:05: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 ( '91660' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '16' , '-16' , '1' , '0.5000' , '0.4098' , '22' , '0' , '8.00' ) 07/05/2024 03:05: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 ( '91660' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '19' , '-19' , '1' , '2.0000' , '1.6393' , '22' , '0' , '38.00' ) 07/05/2024 03:05: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 ( '91660' , '15399' , 'CONF. CARTONCINO SIMBOLO MADRE PERLA CONFESSIONE - 1907/J44' , '16' , '-16' , '1' , '2.8000' , '2.2951' , '22' , '0' , '44.80' ) 07/05/2024 03:05: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 ( '91660' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '18' , '-18' , '1' , '3.2000' , '2.623' , '22' , '0' , '57.60' ) 07/05/2024 03:24:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 03:24:01 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' , '1467' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.05' , '0.04' , NOW() , NOW() ) 07/05/2024 03:24:01 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 = '91661' 07/05/2024 03:24:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91661' 07/05/2024 03:24:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91661' , '5538' , 'LACCIO MARRONE' , '1' , '-1' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.05' ) 07/05/2024 03:27:24 pm >> DELETE FROM ps_document WHERE id_document = '91596' 07/05/2024 03:27:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91596' 07/05/2024 03:51:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 03:51:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1468' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.40' , '38.55' , NOW() , NOW() ) 07/05/2024 03:51:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91662' 07/05/2024 03:51:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '91662' 07/05/2024 03:51:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91662' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 07/05/2024 03:51:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91662' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 07/05/2024 04:15:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 04:15:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1469' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 07/05/2024 04:15:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91663' 07/05/2024 04:15:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91663' 07/05/2024 04:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91663' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 07/05/2024 05:00:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 05:00:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1470' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.55' , '5.37' , NOW() , NOW() ) 07/05/2024 05:00:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91664' 07/05/2024 05:00:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91664' 07/05/2024 05:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91664' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 07/05/2024 05:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91664' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 07/05/2024 05:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91664' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 07/05/2024 05:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91664' , '20065' , 'CATENINA IN ACCIAIO - NS054' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/05/2024 05:09:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 05:09:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1471' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '9.78' , NOW() , NOW() ) 07/05/2024 05:09:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91665' 07/05/2024 05:09:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91665' 07/05/2024 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91665' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '6' , '-6' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.20' ) 07/05/2024 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91665' , '11837' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 07/05/2024 05:09:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91665' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 07/05/2024 05:11:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1472' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 05:11: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' , '1472' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.20' , '8.36' , NOW() , NOW() ) 07/05/2024 05:11: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 = '91666' 07/05/2024 05:11:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91666' 07/05/2024 05:11: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 ( '91666' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 07/05/2024 05:11: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 ( '91666' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '2' , '-2' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '5.40' ) 07/05/2024 06:02:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1473' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 06:02:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1473' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 07/05/2024 06:02:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91667' 07/05/2024 06:02:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91667' 07/05/2024 06:02:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91667' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 07/05/2024 06:03:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1474' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 06:03:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1474' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91668' 07/05/2024 06:03:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91668' 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91668' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91668' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91668' , '21097' , 'BRACCIALE DECINA - BC1768N' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91668' , '20072' , 'BRACCIALE - BC1759N' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 07/05/2024 06:03:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91668' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 07/05/2024 06:28:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1475' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 06:28:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1475' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.90' , '31.89' , NOW() , NOW() ) 07/05/2024 06:28:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91669' 07/05/2024 06:28:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '91669' 07/05/2024 06:28:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91669' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 07/05/2024 06:28:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91669' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '22' , '-22' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '26.40' ) 07/05/2024 06:43:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1476' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 06:43:22 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' , '1476' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 07/05/2024 06:43: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 = '91670' 07/05/2024 06:43:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91670' 07/05/2024 06:43: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 ( '91670' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/05/2024 07:08:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1477' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 07:08:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1477' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.20' , '56.08' , NOW() , NOW() ) 07/05/2024 07:08:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91671' 07/05/2024 07:08:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91671' 07/05/2024 07:08:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91671' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 07/05/2024 07:08:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91671' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 07/05/2024 07:08:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91671' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 07/05/2024 07:18:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002271' AND id_product != '22508' AND ean13 != '' 07/05/2024 07:18:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002272' AND id_product != '22508' AND ean13 != '' 07/05/2024 07:18:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002272', date_upd = NOW() WHERE id_product = '22508' 07/05/2024 07:18:30 pm >> UPDATE ps_product_lang SET name = 'POLO PIQUET - M06', description = '' WHERE id_product = '22508' 07/05/2024 07:18:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40' WHERE id_product = '22508' 07/05/2024 07:18:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40', id_tax_rules_group = '4', id_category_default = '462', 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 = '22508' 07/05/2024 07:18:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '22508' 07/05/2024 07:19:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002272' AND id_product != '22508' AND ean13 != '' 07/05/2024 07:19:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002272', date_upd = NOW() WHERE id_product = '22508' 07/05/2024 07:19:34 pm >> UPDATE ps_product_lang SET name = 'POLO PIQUET - M06', description = '' WHERE id_product = '22508' 07/05/2024 07:19:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40' WHERE id_product = '22508' 07/05/2024 07:19:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40', id_tax_rules_group = '4', id_category_default = '462', 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 = '22508' 07/05/2024 07:19:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22508' 07/05/2024 07:27:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1478' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 07:27: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 ( '11' , '1478' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 07/05/2024 07:27: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 = '91672' 07/05/2024 07:27:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91672' 07/05/2024 07:27: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 ( '91672' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 07/05/2024 07:30:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1479' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-07') 07/05/2024 07:30:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1479' , '2024-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 07/05/2024 07:30:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91673' 07/05/2024 07:30:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91673' 07/05/2024 07:30:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91673' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/05/2024 07:30:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91673' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/05/2024 07:39:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358015028' AND id_product != '1425' AND ean13 != '' 07/05/2024 07:39:57 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '8002358015028', date_upd = NOW() WHERE id_product = '1425' 07/05/2024 07:39:57 pm >> UPDATE ps_product_lang SET name = 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM', description = '' WHERE id_product = '1425' 07/05/2024 07:39:58 pm >> UPDATE ps_product SET wholesale_price = '3.95', on_sale = '0', price = '8.19672131147541' WHERE id_product = '1425' 07/05/2024 07:39:58 pm >> UPDATE ps_product_shop SET wholesale_price = '3.95', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '169', 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 = '1425' 07/05/2024 07:39:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '1425'