26/04/2023 08:32:02 am >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '82919' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-21') 26/04/2023 08:32:02 am >> UPDATE ps_document SET id_document_type = '21', document_num = '76', document_date = '2023-04-21', document_letter = '', id_customer = '3834', id_supplier = '', id_address = '4673024', address1 = 'VIA CHIOSTRO DELLA CATTEDRALE 14 55100 LUCCA', 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 = '367.50', price_tax_excluded = '367.50', date_upd = NOW() WHERE id_document = '82919' 26/04/2023 08:32: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 = '82919' 26/04/2023 08:32:02 am >> DELETE FROM ps_document_detail WHERE id_document = '82919' 26/04/2023 08:32: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 ( '82919' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '35' , '-35' , '4' , '15.0000' , '15' , '0' , '30' , '367.50' ) 26/04/2023 08:32:19 am >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '82919' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-21') 26/04/2023 08:32:19 am >> UPDATE ps_document SET id_document_type = '21', document_num = '76', document_date = '2023-04-21', document_letter = '', id_customer = '3834', id_supplier = '', id_address = '4673024', address1 = 'VIA CHIOSTRO DELLA CATTEDRALE 14 55100 LUCCA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '367.50', price_tax_excluded = '367.50', date_upd = NOW() WHERE id_document = '82919' 26/04/2023 08:32:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82919' 26/04/2023 08:32:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82919' 26/04/2023 08:32:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82919' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '35' , '-35' , '4' , '15.0000' , '15' , '0' , '30' , '367.50' ) 26/04/2023 09:05:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 09: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' , '1355' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '14.23' , NOW() , NOW() ) 26/04/2023 09: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 = '82941' 26/04/2023 09:05:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82941' 26/04/2023 09: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 ( '82941' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 26/04/2023 09: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 ( '82941' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 26/04/2023 09:17:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616577' AND id_product != '8387' AND ean13 != '' 26/04/2023 09:17:43 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616577', date_upd = NOW() WHERE id_product = '8387' 26/04/2023 09:17:43 am >> UPDATE ps_product_lang SET name = 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147', description = '' WHERE id_product = '8387' 26/04/2023 09:17:43 am >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '12' WHERE id_product = '8387' 26/04/2023 09:17:43 am >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8387' 26/04/2023 09:17:43 am >> DELETE FROM ps_specific_price WHERE id_product = '8387' 26/04/2023 09:19:21 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' , '6843/00/2023' , '2023-04-21' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '122.22' , '122.04' , NOW() , NOW() ) 26/04/2023 09:19: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 = '82942' 26/04/2023 09:19:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82942' 26/04/2023 09:19: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 ( '82942' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '25' , '25' , '4' , '5.00' , '5' , '0' , '40' , '75.0000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20795' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20795' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '3' , '3' , '4' , '9.00' , '9' , '0' , '40' , '16.2000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '10712' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10712' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '8387' , 'PREGHIERE PER LE ANIME DEI DEFUNTI - 8147' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '8387' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8387' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '5' , '5' , '4' , '2.00' , '2' , '0' , '40' , '6.0000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '5461' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5461' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '14141' , 'BEATO BARTOLO LONGO - 8859' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14141' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14141' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '11880' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11880' , '38' , '1' ) 26/04/2023 09:19: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 ( '82942' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '10' , '10' , '1' , '0.13934' , '0.1142131147541' , '22' , '40' , '1.0200' ) 26/04/2023 09:19:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '38' 26/04/2023 09:19:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '38' , '1' ) 26/04/2023 09:33:53 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '82897' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-04-20') 26/04/2023 09:33:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '20', document_date = '2023-04-20', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3792.00', price_tax_excluded = '3792.00', date_upd = NOW() WHERE id_document = '82897' 26/04/2023 09:33:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82897' 26/04/2023 09:33:53 am >> DELETE FROM ps_document_detail WHERE id_document = '82897' 26/04/2023 09:33: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 ( '82897' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '80' , '-80' , '4' , '15.0000' , '15' , '0' , '0' , '1200.00' ) 26/04/2023 09:33: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 ( '82897' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1080' , '-1080' , '4' , '2.4000' , '2.4' , '0' , '0' , '2592.00' ) 26/04/2023 09:36:33 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '82763' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-12') 26/04/2023 09:36:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2023-04-12', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 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 = '118.40', price_tax_excluded = '111.55', date_upd = NOW() WHERE id_document = '82763' 26/04/2023 09:36:33 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 = '82763' 26/04/2023 09:36:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82763' 26/04/2023 09:36:33 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 ( '82763' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 26/04/2023 09:36:33 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 ( '82763' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.0000' , '49' , '0' , '5' , '46.55' ) 26/04/2023 09:36:33 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 ( '82763' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 26/04/2023 09:36:33 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 ( '82763' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 26/04/2023 09:36:33 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 ( '82763' , '11151' , 'LIBRI immagini misericordioso' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/04/2023 09:36:33 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 ( '82763' , '' , '27/03/2023' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 26/04/2023 09:36:33 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 ( '82763' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '32.00' ) 26/04/2023 09:36:43 am >> DELETE FROM ps_document WHERE id_document = '82478' 26/04/2023 09:36:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82478' 26/04/2023 09:43:26 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '82710' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-06') 26/04/2023 09:43:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2023-04-06', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '353.50', price_tax_excluded = '290.61', date_upd = NOW() WHERE id_document = '82710' 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82710' 26/04/2023 09:43:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82710' 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '66.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1041' , 'BENEDIZIONI' , '700' , '-700' , '1' , '0.1200' , '0.098360655737705' , '22' , '0' , '84.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 26/04/2023 09:43:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 26/04/2023 09:45:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 09:45:10 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' , '1356' , '2023-04-26' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '353.50' , '290.61' , NOW() , NOW() ) 26/04/2023 09:45:10 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 = '82943' 26/04/2023 09:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82943' 26/04/2023 09:45: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 ( '82943' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.6557' , '22' , '0' , '135.00' ) 26/04/2023 09:45: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 ( '82943' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.0328' , '22' , '0' , '66.00' ) 26/04/2023 09:45: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 ( '82943' , '1041' , 'BENEDIZIONI' , '700' , '-700' , '1' , '0.1200' , '0.0984' , '22' , '0' , '84.00' ) 26/04/2023 09:45:11 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 ( '82943' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.7705' , '22' , '0' , '29.00' ) 26/04/2023 09:45:11 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 ( '82943' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.0164' , '22' , '0' , '9.80' ) 26/04/2023 09:45:11 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 ( '82943' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.3279' , '22' , '0' , '6.50' ) 26/04/2023 09:45:11 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 ( '82943' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 26/04/2023 09:45:11 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 ( '82943' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8462' , '4' , '0' , '4.00' ) 26/04/2023 09:45:11 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 ( '82943' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016' , '22' , '0' , '2.20' ) 26/04/2023 09:45:11 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 ( '82943' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.5000' , '6.1475' , '22' , '0' , '15.00' ) 26/04/2023 09:47:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 09:47:00 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' , '1357' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 26/04/2023 09:47:00 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 = '82944' 26/04/2023 09:47:00 am >> DELETE FROM ps_document_detail WHERE id_document = '82944' 26/04/2023 09:47:00 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 ( '82944' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 26/04/2023 09:50:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '82943' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 09:50:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1356', document_date = '2023-04-26', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '353.50', price_tax_excluded = '290.61', date_upd = NOW() WHERE id_document = '82943' 26/04/2023 09:50:16 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 = '82943' 26/04/2023 09:50:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82943' 26/04/2023 09:50:16 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 ( '82943' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 26/04/2023 09:50:16 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 ( '82943' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '66.00' ) 26/04/2023 09:50:16 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 ( '82943' , '1041' , 'BENEDIZIONI' , '700' , '-700' , '1' , '0.1200' , '0.098360655737705' , '22' , '0' , '84.00' ) 26/04/2023 09:50:16 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 ( '82943' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 26/04/2023 09:50:16 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 ( '82943' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 26/04/2023 09:50:16 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 ( '82943' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 26/04/2023 09:50: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 ( '82943' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 26/04/2023 09:50: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 ( '82943' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 26/04/2023 09:50: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 ( '82943' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 26/04/2023 09:50: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 ( '82943' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 26/04/2023 09:52:12 am >> DELETE FROM ps_document WHERE id_document = '82710' 26/04/2023 09:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '82710' 26/04/2023 09:59:06 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' , '171/23' , '2023-04-19' , '23' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '527.28' , '507.00' , NOW() , NOW() ) 26/04/2023 09:59:06 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 = '82945' 26/04/2023 09:59:06 am >> DELETE FROM ps_document_detail WHERE id_document = '82945' 26/04/2023 09:59:06 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 ( '82945' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '200' , '0' , '3' , '2.535' , '2.4375' , '4' , '0' , '527.2800' ) 26/04/2023 09:59:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '20951' AND id_supplier = '159' 26/04/2023 09:59:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20951' , '159' , '1' ) 26/04/2023 10:21:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 10:21:36 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' , '1358' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/04/2023 10:21:36 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 = '82946' 26/04/2023 10:21:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82946' 26/04/2023 10:21:37 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 ( '82946' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/04/2023 10:42:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 10:42:16 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' , '1359' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.50' , '64.30' , NOW() , NOW() ) 26/04/2023 10:42:16 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 = '82947' 26/04/2023 10:42:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82947' 26/04/2023 10:42:16 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 ( '82947' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '13' , '-13' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '18.20' ) 26/04/2023 10:42:16 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 ( '82947' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 26/04/2023 10:42:16 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 ( '82947' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/04/2023 10:42:16 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 ( '82947' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 26/04/2023 10:42:16 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 ( '82947' , '11151' , 'LIBRI' , '7' , '-7' , '4' , '1.9' , '1.9' , '0' , '0' , '13.30' ) 26/04/2023 11:09:31 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 11:09: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 ( '24' , '21' , '2023-04-26' , '' , '0' , '176' , '4678847' , 'LARGO GEMELLI 1 20123 MILANO' , '' , 'RESA C/DEPOSITO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '240.00' , NOW() , NOW() ) 26/04/2023 11:09: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 = '82948' 26/04/2023 11:09:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82948' 26/04/2023 11:09: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 ( '82948' , '20910' , 'sud il capitale che serve - c. borgomeo' , '16' , '-16' , '4' , '15.00' , '15' , '0' , '0' , '240.00' ) 26/04/2023 11:09:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20910' AND id_supplier = '176' 26/04/2023 11:09:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20910' , '176' , '1' ) 26/04/2023 11:50:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 11:50:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1360' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 26/04/2023 11:50: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 = '82949' 26/04/2023 11:50:18 am >> DELETE FROM ps_document_detail WHERE id_document = '82949' 26/04/2023 11:50: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 ( '82949' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 26/04/2023 11:50: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 ( '82949' , '1041' , 'BENEDIZIONI' , '300' , '-300' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '45.00' ) 26/04/2023 11:59:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 11:59:20 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' , '1361' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 26/04/2023 11:59:20 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 = '82950' 26/04/2023 11:59:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82950' 26/04/2023 11:59:20 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 ( '82950' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 26/04/2023 12:09:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 12:09:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '18/E' , '2023-04-26' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '240.00' , '230.77' , NOW() , NOW() ) 26/04/2023 12:09:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82951' 26/04/2023 12:09:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82951' 26/04/2023 12:09:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82951' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '20' , '-20' , '3' , '20' , '19.230769230769' , '4' , '40' , '240.00' ) 26/04/2023 12:14:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 12:14:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1362' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 26/04/2023 12:14:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82952' 26/04/2023 12:14:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82952' 26/04/2023 12:14:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82952' , '19560' , 'PERGAMENA 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 26/04/2023 12:15:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1363' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 12:15:37 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' , '1363' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/04/2023 12:15:37 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 = '82953' 26/04/2023 12:15:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82953' 26/04/2023 12:15:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82953' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/04/2023 12:29:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 12:29:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1364' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '148.08' , NOW() , NOW() ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82954' 26/04/2023 12:29:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82954' 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '15' , '-15' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '18.00' ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '6962' , 'NELLA CASA DEL DEFUNTO' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '30.00' ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '15055' , 'CROCE PADRE NOSTRO' , '5' , '-5' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '14.00' ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '8655' , 'QUADRO CRISTALLO ARG. MOGANO ' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 26/04/2023 12:29:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82954' , '8656' , 'QUADRO CRISTALLO ARG. MOGANO - M' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 26/04/2023 12:31:31 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8655' 26/04/2023 12:31:31 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8655' 26/04/2023 12:47:21 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/04/2023 12:47:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20972' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:47:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20972' , '1' , '1' , '2' , NOW() , NOW() ) 26/04/2023 12:47:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20972' , '0' , '1' , '0' , '0' ) 26/04/2023 12:50:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254711620' AND id_product != '20972' AND ean13 != '' 26/04/2023 12:50:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9791254711620', date_upd = NOW() WHERE id_product = '20972' 26/04/2023 12:50:11 pm >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO - P. STEFANI', description = '' WHERE id_product = '20972' 26/04/2023 12:50:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20972' 26/04/2023 12:50:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20972' 26/04/2023 12:50:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20972' 26/04/2023 12:50: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 = '20972' 26/04/2023 12:50:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20973' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:50: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 '20973' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20972' 26/04/2023 12:50:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20973' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20972' 26/04/2023 12:52:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259622907' AND id_product != '20973' AND ean13 != '' 26/04/2023 12:52:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791259622907', date_upd = NOW() WHERE id_product = '20973' 26/04/2023 12:52:01 pm >> UPDATE ps_product_lang SET name = 'OGGETTO PREDICA - ANNO A', description = '' WHERE id_product = '20973' 26/04/2023 12:52:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20973' 26/04/2023 12:52:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20973' 26/04/2023 12:52:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20973' 26/04/2023 12:52:02 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 = '20973' 26/04/2023 12:52:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20974' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:52:02 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 '20974' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20973' 26/04/2023 12:52:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20974' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20973' 26/04/2023 12:53:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623515' AND id_product != '20974' AND ean13 != '' 26/04/2023 12:53:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9791259623515', date_upd = NOW() WHERE id_product = '20974' 26/04/2023 12:53:38 pm >> UPDATE ps_product_lang SET name = 'COSE E\' LA MESSA? R. CASTILLO', description = '' WHERE id_product = '20974' 26/04/2023 12:53:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20974' 26/04/2023 12:53:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20974' 26/04/2023 12:53:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '20974' 26/04/2023 12:53:41 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 = '20974' 26/04/2023 12:53:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20975' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:53:41 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 '20975' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20974' 26/04/2023 12:53:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20975' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20974' 26/04/2023 12:54:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623317' AND id_product != '20975' AND ean13 != '' 26/04/2023 12:54:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/1', ean13 = '9791259623317', date_upd = NOW() WHERE id_product = '20975' 26/04/2023 12:54:47 pm >> UPDATE ps_product_lang SET name = 'DOTTRINA SOCIALE DELLA CHIESA - G. COMOLLI', description = '' WHERE id_product = '20975' 26/04/2023 12:54:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '20975' 26/04/2023 12:54:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20975' 26/04/2023 12:54:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '20975' 26/04/2023 12:54:50 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 = '20975' 26/04/2023 12:54:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20976' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:54:50 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 '20976' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20975' 26/04/2023 12:54:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20976' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20975' 26/04/2023 12:56:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831113151' AND id_product != '20976' AND ean13 != '' 26/04/2023 12:56:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788831113151', date_upd = NOW() WHERE id_product = '20976' 26/04/2023 12:56:01 pm >> UPDATE ps_product_lang SET name = 'CHIESA SACRAMENTO DI UNITA\' ', description = '' WHERE id_product = '20976' 26/04/2023 12:56:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20976' 26/04/2023 12:56:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20976' 26/04/2023 12:56:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '20976' 26/04/2023 12:56:03 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 = '20976' 26/04/2023 12:56:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20977' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 12:56:03 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 '20977' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20976' 26/04/2023 12:56:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20977' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20976' 26/04/2023 12:57: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 ( '33' , '916562' , '2023-04-24' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '211.50' , '211.50' , NOW() , NOW() ) 26/04/2023 12:57: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 = '82955' 26/04/2023 12:57:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82955' 26/04/2023 12:57: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 ( '82955' , '20972' , 'PADRE NOSTRO - P. STEFANI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20972' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20972' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '20975' , 'DOTTRINA SOCIALE DELLA CHIESA - G. COMOLLI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20975' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20975' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '20973' , 'OGGETTO PREDICA - ANNO A' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20973' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20973' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16353' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16353' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '20976' , 'CHIESA SACRAMENTO DI UNITA ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20976' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20976' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '18509' , 'MANUALE DEL PARROCO - L. CHIAPPETTA' , '1' , '1' , '4' , '99.50' , '99.5' , '0' , '0' , '99.50' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18509' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18509' , '109' , '1' ) 26/04/2023 12:57: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 ( '82955' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 26/04/2023 12:57:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '109' 26/04/2023 12:57:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '109' , '1' ) 26/04/2023 12:58:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831113151' AND id_product != '20976' AND ean13 != '' 26/04/2023 12:58:15 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/6', ean13 = '9788831113151', date_upd = NOW() WHERE id_product = '20976' 26/04/2023 12:58:15 pm >> UPDATE ps_product_lang SET name = 'CHIESA SACRAMENTO DI UNITA\' ', description = '' WHERE id_product = '20976' 26/04/2023 12:58:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '20976' 26/04/2023 12:58:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20976' 26/04/2023 12:58:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20976' 26/04/2023 12:58:25 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '916562', document_date = '2023-04-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '213.50', price_tax_excluded = '213.50', date_upd = NOW() WHERE id_document = '82955' 26/04/2023 12:58: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 = '82955' 26/04/2023 12:58:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '82955' 26/04/2023 12:58: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 ( '82955' , '20972' , 'PADRE NOSTRO - P. STEFANI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 26/04/2023 12:58: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 ( '82955' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 26/04/2023 12:58: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 ( '82955' , '20975' , 'DOTTRINA SOCIALE DELLA CHIESA - G. COMOLLI' , '1' , '1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 26/04/2023 12:58: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 ( '82955' , '20973' , 'OGGETTO PREDICA - ANNO A' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 26/04/2023 12:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82955' , '16353' , 'QUALCUNO A CUI GUARDARE - L. EPICOCO' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/04/2023 12:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82955' , '20976' , 'CHIESA SACRAMENTO DI UNITA ' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 26/04/2023 12:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82955' , '18509' , 'MANUALE DEL PARROCO - L. CHIAPPETTA' , '1' , '1' , '4' , '99.5000' , '99.5' , '0' , '0' , '99.50' ) 26/04/2023 12:58:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82955' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 26/04/2023 02:25:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002134' AND id_product != '1617' AND ean13 != '' 26/04/2023 02:25:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '002134', date_upd = NOW() WHERE id_product = '1617' 26/04/2023 02:25:40 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 - CM 40 DM170R', description = '' WHERE id_product = '1617' 26/04/2023 02:25:40 pm >> UPDATE ps_product SET wholesale_price = '52.00', on_sale = '0', price = '106.5574' WHERE id_product = '1617' 26/04/2023 02:25:40 pm >> UPDATE ps_product_shop SET wholesale_price = '52.00', price = '106.5574', id_tax_rules_group = '1', id_category_default = '215', 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 = '1617' 26/04/2023 02:25:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '1617' 26/04/2023 02:27:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002135' AND id_product != '13886' AND ean13 != '' 26/04/2023 02:27:12 pm >> UPDATE ps_product SET id_supplier = '21', reference = '', ean13 = '002135', date_upd = NOW() WHERE id_product = '13886' 26/04/2023 02:27:12 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO ROCCOCO\' CM 30 OTTONE- DM185R', description = '' WHERE id_product = '13886' 26/04/2023 02:27:12 pm >> UPDATE ps_product SET wholesale_price = '40.00', on_sale = '0', price = '86.0656' WHERE id_product = '13886' 26/04/2023 02:27:12 pm >> UPDATE ps_product_shop SET wholesale_price = '40.00', price = '86.0656', id_tax_rules_group = '1', id_category_default = '215', 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 = '13886' 26/04/2023 02:27:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '13886' 26/04/2023 02:27:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002134' AND id_product != '1617' AND ean13 != '' 26/04/2023 02:27:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '002134', date_upd = NOW() WHERE id_product = '1617' 26/04/2023 02:27:54 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO- CM 40 DM170R', description = '' WHERE id_product = '1617' 26/04/2023 02:27:54 pm >> UPDATE ps_product SET wholesale_price = '52.00', on_sale = '0', price = '106.5574' WHERE id_product = '1617' 26/04/2023 02:27:54 pm >> UPDATE ps_product_shop SET wholesale_price = '52.00', price = '106.5574', id_tax_rules_group = '1', id_category_default = '215', 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 = '1617' 26/04/2023 02:27:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '1617' 26/04/2023 02:28:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002136' AND id_product != '1616' AND ean13 != '' 26/04/2023 02:28:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '002136', date_upd = NOW() WHERE id_product = '1616' 26/04/2023 02:28:49 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R', description = '' WHERE id_product = '1616' 26/04/2023 02:28:49 pm >> UPDATE ps_product SET wholesale_price = '33.00', on_sale = '0', price = '69.6721' WHERE id_product = '1616' 26/04/2023 02:28:49 pm >> UPDATE ps_product_shop SET wholesale_price = '33.00', price = '69.6721', id_tax_rules_group = '1', id_category_default = '215', 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 = '1616' 26/04/2023 02:28:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '1616' 26/04/2023 02:34:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002137' AND id_product != '20977' AND ean13 != '' 26/04/2023 02:34:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002137', date_upd = NOW() WHERE id_product = '20977' 26/04/2023 02:34:26 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO CM 60 OTTONE - DM183R', description = '' WHERE id_product = '20977' 26/04/2023 02:34:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20977' 26/04/2023 02:34:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '215', 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 = '20977' 26/04/2023 02:34:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '20977' 26/04/2023 02:34:41 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/04/2023 02:34:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20978' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 02:34:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20978' , '1' , '1' , '2' , NOW() , NOW() ) 26/04/2023 02:34:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20978' , '0' , '1' , '0' , '0' ) 26/04/2023 02:35:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002138' AND id_product != '20978' AND ean13 != '' 26/04/2023 02:35:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002138', date_upd = NOW() WHERE id_product = '20978' 26/04/2023 02:35:43 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO CM 60 - DM172R', description = '' WHERE id_product = '20978' 26/04/2023 02:35:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20978' 26/04/2023 02:35:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '215', 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 = '20978' 26/04/2023 02:35:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '20978' 26/04/2023 02:35:44 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 = '20978' 26/04/2023 02:35:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20979' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 02:35:44 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 '20979' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20978' 26/04/2023 02:35:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20979' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20978' 26/04/2023 03:38:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 03:38: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' , '1365' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '20.81' , NOW() , NOW() ) 26/04/2023 03:38: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 = '82956' 26/04/2023 03:38:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '82956' 26/04/2023 03:38: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 ( '82956' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 26/04/2023 03:38: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 ( '82956' , '12946' , 'CLASSICI MARIANI - SPARTITO' , '1' , '-1' , '3' , '18.00' , '17.307692307692' , '4' , '0' , '18.00' ) 26/04/2023 03:39:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806258023' AND id_product != '20979' AND ean13 != '' 26/04/2023 03:39:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806258023', date_upd = NOW() WHERE id_product = '20979' 26/04/2023 03:39:40 pm >> UPDATE ps_product_lang SET name = 'BIBBIA', description = '' WHERE id_product = '20979' 26/04/2023 03:39:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '20979' 26/04/2023 03:39:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '278', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20979' 26/04/2023 03:39:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20979' 26/04/2023 03:39:49 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 = '20979' 26/04/2023 03:39:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20980' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 03:39:49 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 '20980' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20979' 26/04/2023 03:39:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20980' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20979' 26/04/2023 03:40:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 26/04/2023 03:40:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '60.90', price_tax_excluded = '60.90', date_upd = NOW() WHERE id_document = '81317' 26/04/2023 03:40:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 26/04/2023 03:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 26/04/2023 03:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 26/04/2023 03:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 26/04/2023 03:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 26/04/2023 03:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 26/04/2023 03:41:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788858150979' AND id_product != '20980' AND ean13 != '' 26/04/2023 03:41:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788858150979', date_upd = NOW() WHERE id_product = '20980' 26/04/2023 03:41:32 pm >> UPDATE ps_product_lang SET name = 'SENZA CHIESA E SENZA DIO - B. SALVARANI', description = '' WHERE id_product = '20980' 26/04/2023 03:41:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20980' 26/04/2023 03:41:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '350', 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 = '20980' 26/04/2023 03:41:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20980' 26/04/2023 03:41:33 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 = '20980' 26/04/2023 03:41:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20981' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 03:41:33 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 '20981' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20980' 26/04/2023 03:41:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20981' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20980' 26/04/2023 03:42:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807924002' AND id_product != '20981' AND ean13 != '' 26/04/2023 03:42:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807924002', date_upd = NOW() WHERE id_product = '20981' 26/04/2023 03:42:50 pm >> UPDATE ps_product_lang SET name = 'PAROLE DI GESU\' - U. GALIMBERTI', description = '' WHERE id_product = '20981' 26/04/2023 03:42:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20981' 26/04/2023 03:42:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '359', 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 = '20981' 26/04/2023 03:42:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20981' 26/04/2023 03:43:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807924002' AND id_product != '20981' AND ean13 != '' 26/04/2023 03:43:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807924002', date_upd = NOW() WHERE id_product = '20981' 26/04/2023 03:43:12 pm >> UPDATE ps_product_lang SET name = 'PAROLE DI GESU\' - U. GALIMBERTI', description = '' WHERE id_product = '20981' 26/04/2023 03:43:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20981' 26/04/2023 03:43:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '359', 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 = '20981' 26/04/2023 03:43:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20981' 26/04/2023 03:43:16 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 = '20981' 26/04/2023 03:43:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20982' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 03:43:16 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 '20982' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20981' 26/04/2023 03:43:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20982' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20981' 26/04/2023 04:19:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002135' AND id_product != '13886' AND ean13 != '' 26/04/2023 04:19:35 pm >> UPDATE ps_product SET id_supplier = '21', reference = '', ean13 = '002135', date_upd = NOW() WHERE id_product = '13886' 26/04/2023 04:19:35 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO ROCCOCO\' CM 30 OTTONE- DM185R', description = '' WHERE id_product = '13886' 26/04/2023 04:19:35 pm >> UPDATE ps_product SET wholesale_price = '40.00', on_sale = '0', price = '127.04918032786885' WHERE id_product = '13886' 26/04/2023 04:19:35 pm >> UPDATE ps_product_shop SET wholesale_price = '40.00', price = '127.04918032786885', id_tax_rules_group = '1', id_category_default = '215', 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 = '13886' 26/04/2023 04:19:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '13886' 26/04/2023 04:20:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002137' AND id_product != '20977' AND ean13 != '' 26/04/2023 04:20:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002137', date_upd = NOW() WHERE id_product = '20977' 26/04/2023 04:20:49 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO CM 60 OTTONE - DM183R', description = '' WHERE id_product = '20977' 26/04/2023 04:20:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '173.5' WHERE id_product = '20977' 26/04/2023 04:20:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '173.5', id_tax_rules_group = '4', id_category_default = '215', 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 = '20977' 26/04/2023 04:20:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '20977' 26/04/2023 04:21:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002137' AND id_product != '20977' AND ean13 != '' 26/04/2023 04:21:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002137', date_upd = NOW() WHERE id_product = '20977' 26/04/2023 04:21:31 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO CM 60 OTTONE - DM183R', description = '' WHERE id_product = '20977' 26/04/2023 04:21:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '415' WHERE id_product = '20977' 26/04/2023 04:21:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '415', id_tax_rules_group = '4', id_category_default = '215', 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 = '20977' 26/04/2023 04:21:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '20977' 26/04/2023 04:23:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002136' AND id_product != '1616' AND ean13 != '' 26/04/2023 04:23:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '002136', date_upd = NOW() WHERE id_product = '1616' 26/04/2023 04:23:54 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R', description = '' WHERE id_product = '1616' 26/04/2023 04:23:54 pm >> UPDATE ps_product SET wholesale_price = '33.00', on_sale = '0', price = '143.44262295081967' WHERE id_product = '1616' 26/04/2023 04:23:54 pm >> UPDATE ps_product_shop SET wholesale_price = '33.00', price = '143.44262295081967', id_tax_rules_group = '1', id_category_default = '215', 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 = '1616' 26/04/2023 04:23:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '1616' 26/04/2023 04:24:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002134' AND id_product != '1617' AND ean13 != '' 26/04/2023 04:24:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '002134', date_upd = NOW() WHERE id_product = '1617' 26/04/2023 04:24:27 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO- CM 40 DM170R', description = '' WHERE id_product = '1617' 26/04/2023 04:24:28 pm >> UPDATE ps_product SET wholesale_price = '52.00', on_sale = '0', price = '178.68852459016395' WHERE id_product = '1617' 26/04/2023 04:24:28 pm >> UPDATE ps_product_shop SET wholesale_price = '52.00', price = '178.68852459016395', id_tax_rules_group = '1', id_category_default = '215', 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 = '1617' 26/04/2023 04:24:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '1617' 26/04/2023 04:24:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002138' AND id_product != '20978' AND ean13 != '' 26/04/2023 04:24:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002138', date_upd = NOW() WHERE id_product = '20978' 26/04/2023 04:24:55 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO CM 60 - DM172R', description = '' WHERE id_product = '20978' 26/04/2023 04:24:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '278.6885245901639' WHERE id_product = '20978' 26/04/2023 04:24:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '278.6885245901639', id_tax_rules_group = '1', id_category_default = '215', 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 = '20978' 26/04/2023 04:24:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '20978' 26/04/2023 04:27:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002137' AND id_product != '20977' AND ean13 != '' 26/04/2023 04:27:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002137', date_upd = NOW() WHERE id_product = '20977' 26/04/2023 04:27:15 pm >> UPDATE ps_product_lang SET name = 'CANDELABRO BAROCCO CM 60 OTTONE - DM183R', description = '' WHERE id_product = '20977' 26/04/2023 04:27:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '340.1639344262295' WHERE id_product = '20977' 26/04/2023 04:27:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '340.1639344262295', id_tax_rules_group = '1', id_category_default = '215', 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 = '20977' 26/04/2023 04:27:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20977' 26/04/2023 04:27:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '179/IVA' , '2023-04-20' , 'IVA' , '0' , '21' , '2616' , 'VIA LOMBARDIA, 7 25025 MANERBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1492.06' , '1223.00' , NOW() , NOW() ) 26/04/2023 04:27:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82957' 26/04/2023 04:27:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82957' 26/04/2023 04:27:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82957' , '13886' , 'CANDELABRO BAROCCO ROCCOCO CM 30 OTTONE- DM185R' , '4' , '4' , '1' , '65' , '53.27868852459' , '22' , '0' , '317.2000' ) 26/04/2023 04:27:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13886' AND id_supplier = '21' 26/04/2023 04:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13886' , '21' , '1' ) 26/04/2023 04:27: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 ( '82957' , '20977' , 'CANDELABRO BAROCCO CM 60 OTTONE - DM183R' , '2' , '2' , '1' , '173.5' , '142.2131147541' , '22' , '0' , '423.3400' ) 26/04/2023 04:27:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20977' AND id_supplier = '21' 26/04/2023 04:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20977' , '21' , '1' ) 26/04/2023 04:27: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 ( '82957' , '1616' , 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R' , '2' , '2' , '1' , '73' , '59.83606557377' , '22' , '0' , '178.1200' ) 26/04/2023 04:27:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1616' AND id_supplier = '21' 26/04/2023 04:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1616' , '21' , '1' ) 26/04/2023 04:27: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 ( '82957' , '1617' , 'CANDELABRO MOD. 700 FINITURA ORO- CM 40 DM170R' , '2' , '2' , '1' , '93' , '76.229508196721' , '22' , '0' , '226.9200' ) 26/04/2023 04:27:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1617' AND id_supplier = '21' 26/04/2023 04:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1617' , '21' , '1' ) 26/04/2023 04:27: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 ( '82957' , '20978' , 'CANDELABRO MOD. 700 FINITURA ORO CM 60 - DM172R' , '2' , '2' , '1' , '142' , '116.39344262295' , '22' , '0' , '346.4800' ) 26/04/2023 04:27:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20978' AND id_supplier = '21' 26/04/2023 04:27:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20978' , '21' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '4074' , '2023-04-26' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '6.74' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '112.23' , '112.23' , NOW() , NOW() ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82958' 26/04/2023 04:34:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82958' 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20979' , 'BIBBIA' , '1' , '1' , '4' , '38.00' , '38' , '0' , '30' , '26.6000' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20979' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20979' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20981' , 'PAROLE DI GESU - U. GALIMBERTI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20981' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20981' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20980' , 'SENZA CHIESA E SENZA DIO - B. SALVARANI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20980' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20980' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20642' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20642' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '2' , '2' , '4' , '10.90' , '10.9' , '0' , '30' , '15.2600' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20326' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20326' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '30' , '11.8300' ) 26/04/2023 04:34:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '105' 26/04/2023 04:34:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '105' , '1' ) 26/04/2023 04:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82958' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 26/04/2023 04:34:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20745' AND id_supplier = '105' 26/04/2023 04:34:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20745' , '105' , '1' ) 26/04/2023 05:03:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 05:03: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' , '1366' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 26/04/2023 05:03: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 = '82959' 26/04/2023 05:03:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82959' 26/04/2023 05:03: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 ( '82959' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 26/04/2023 05:04:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '82959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 05:04:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1366', document_date = '2023-04-26', 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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '82959' 26/04/2023 05:04: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 = '82959' 26/04/2023 05:04:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82959' 26/04/2023 05:04: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 ( '82959' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 26/04/2023 05:04: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 ( '82959' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 26/04/2023 05:08:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 05:08: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' , '1367' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 26/04/2023 05:08: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 = '82960' 26/04/2023 05:08:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82960' 26/04/2023 05:08: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 ( '82960' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 26/04/2023 05:12:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000347' AND id_product != '2177' AND ean13 != '' 26/04/2023 05:12:17 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000347', date_upd = NOW() WHERE id_product = '2177' 26/04/2023 05:12:17 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - MM - B&P', description = '' WHERE id_product = '2177' 26/04/2023 05:12:17 pm >> UPDATE ps_product SET wholesale_price = '13.15', on_sale = '0', price = '28.278688524590166' WHERE id_product = '2177' 26/04/2023 05:12:17 pm >> UPDATE ps_product_shop SET wholesale_price = '13.15', price = '28.278688524590166', id_tax_rules_group = '1', id_category_default = '253', 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 = '2177' 26/04/2023 05:12:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '2177' 26/04/2023 05:13:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000349' AND id_product != '2178' AND ean13 != '' 26/04/2023 05:13:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000349', date_upd = NOW() WHERE id_product = '2178' 26/04/2023 05:13:21 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC EXTRA - MM - B&P', description = '' WHERE id_product = '2178' 26/04/2023 05:13:21 pm >> UPDATE ps_product SET wholesale_price = '15.25', on_sale = '0', price = '32.37704918032787' WHERE id_product = '2178' 26/04/2023 05:13:21 pm >> UPDATE ps_product_shop SET wholesale_price = '15.25', price = '32.37704918032787', id_tax_rules_group = '1', id_category_default = '253', 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 = '2178' 26/04/2023 05:13:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '2178' 26/04/2023 05:14:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000380' AND id_product != '2168' AND ean13 != '' 26/04/2023 05:14:24 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000380', date_upd = NOW() WHERE id_product = '2168' 26/04/2023 05:14:25 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC - ML - B&P', description = '' WHERE id_product = '2168' 26/04/2023 05:14:25 pm >> UPDATE ps_product SET wholesale_price = '12.65', on_sale = '0', price = '29.098360655737707' WHERE id_product = '2168' 26/04/2023 05:14:25 pm >> UPDATE ps_product_shop SET wholesale_price = '12.65', price = '29.098360655737707', id_tax_rules_group = '1', id_category_default = '253', 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 = '2168' 26/04/2023 05:14:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '2168' 26/04/2023 05:15:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000386' AND id_product != '2164' AND ean13 != '' 26/04/2023 05:15:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000386', date_upd = NOW() WHERE id_product = '2164' 26/04/2023 05:15:17 pm >> UPDATE ps_product_lang SET name = 'CLERGY BASIC EXTRA - ML - B&P', description = '' WHERE id_product = '2164' 26/04/2023 05:15:17 pm >> UPDATE ps_product SET wholesale_price = '14.35', on_sale = '0', price = '32.78688524590164' WHERE id_product = '2164' 26/04/2023 05:15:17 pm >> UPDATE ps_product_shop SET wholesale_price = '14.35', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '253', 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 = '2164' 26/04/2023 05:15:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '2164' 26/04/2023 05:16:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001995' AND id_product != '19594' AND ean13 != '' 26/04/2023 05:16:41 pm >> UPDATE ps_product SET id_supplier = '77', reference = '', ean13 = '001995', date_upd = NOW() WHERE id_product = '19594' 26/04/2023 05:16:41 pm >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100%', description = '' WHERE id_product = '19594' 26/04/2023 05:16:41 pm >> UPDATE ps_product SET wholesale_price = '16.00', on_sale = '0', price = '35.24590163934426' WHERE id_product = '19594' 26/04/2023 05:16:41 pm >> UPDATE ps_product_shop SET wholesale_price = '16.00', price = '35.24590163934426', id_tax_rules_group = '1', id_category_default = '253', 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 = '19594' 26/04/2023 05:16:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19594' 26/04/2023 05:17:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001996' AND id_product != '19595' AND ean13 != '' 26/04/2023 05:17:32 pm >> UPDATE ps_product SET id_supplier = '77', reference = '', ean13 = '001996', date_upd = NOW() WHERE id_product = '19595' 26/04/2023 05:17:32 pm >> UPDATE ps_product_lang SET name = 'POLO JERSEY COTONE 100% - EXTRA', description = '' WHERE id_product = '19595' 26/04/2023 05:17:32 pm >> UPDATE ps_product SET wholesale_price = '18.50', on_sale = '0', price = '36.885245901639344' WHERE id_product = '19595' 26/04/2023 05:17:32 pm >> UPDATE ps_product_shop SET wholesale_price = '18.50', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '253', 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 = '19595' 26/04/2023 05:17:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '19595' 26/04/2023 05:19:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002139' AND id_product != '20982' AND ean13 != '' 26/04/2023 05:19:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002139', date_upd = NOW() WHERE id_product = '20982' 26/04/2023 05:19:10 pm >> UPDATE ps_product_lang SET name = 'POLO MM VISCOSA 100%', description = '' WHERE id_product = '20982' 26/04/2023 05:19:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35.24590163934426' WHERE id_product = '20982' 26/04/2023 05:19:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35.24590163934426', id_tax_rules_group = '1', id_category_default = '253', 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 = '20982' 26/04/2023 05:19:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '20982' 26/04/2023 05:19:11 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 = '20982' 26/04/2023 05:19:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20983' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 05:19:11 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 '20983' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20982' 26/04/2023 05:19:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20983' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20982' 26/04/2023 05:21:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002140' AND id_product != '20983' AND ean13 != '' 26/04/2023 05:21:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002140', date_upd = NOW() WHERE id_product = '20983' 26/04/2023 05:21:28 pm >> UPDATE ps_product_lang SET name = 'CLERGY MM LIMITED 80/20', description = '' WHERE id_product = '20983' 26/04/2023 05:21:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.78688524590164' WHERE id_product = '20983' 26/04/2023 05:21:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '253', 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 = '20983' 26/04/2023 05:21:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20983' 26/04/2023 05:21:29 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 = '20983' 26/04/2023 05:21:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20984' , '1' , '' , 'nuovo-prodotto' ) 26/04/2023 05:21:29 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 '20984' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20983' 26/04/2023 05:21:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20984' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20983' 26/04/2023 05:22:13 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' , '66/2023' , '2023-04-26' , '2023' , '0' , '77' , '2672' , 'UL. MALBORSKA, 8 42200 CZESTOCHOWA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1254.05' , '1254.05' , NOW() , NOW() ) 26/04/2023 05:22:13 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 = '82961' 26/04/2023 05:22:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82961' 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '2177' , 'CLERGY BASIC - MM - B&P' , '8' , '8' , '0' , '14.15' , '14.15' , '' , '0' , '113.2000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '2' , '2' , '0' , '16.25' , '16.25' , '' , '0' , '32.5000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2178' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2178' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '2168' , 'CLERGY BASIC - ML - B&P' , '17' , '17' , '0' , '14.65' , '14.65' , '' , '0' , '249.0500' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '2' , '2' , '0' , '16.85' , '16.85' , '' , '0' , '33.7000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2164' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2164' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '19594' , 'POLO JERSEY COTONE 100%' , '12' , '12' , '0' , '17.9' , '17.9' , '' , '0' , '214.8000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '20982' , 'POLO MM VISCOSA 100%' , '12' , '12' , '0' , '17.9' , '17.9' , '' , '0' , '214.8000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20982' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20982' , '77' , '1' ) 26/04/2023 05:22:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82961' , '20983' , 'CLERGY MM LIMITED 80/20' , '24' , '24' , '0' , '16.5' , '16.5' , '' , '0' , '396.0000' ) 26/04/2023 05:22:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20983' AND id_supplier = '77' 26/04/2023 05:22:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20983' , '77' , '1' ) 26/04/2023 06:00:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 06:00:20 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' , '1368' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.00' , '61.10' , NOW() , NOW() ) 26/04/2023 06:00:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82962' 26/04/2023 06:00:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82962' 26/04/2023 06:00:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82962' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '22' , '-22' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '66.00' ) 26/04/2023 06:00:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82962' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 26/04/2023 06:02:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 06:02: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' , '1369' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.52' , '44.52' , NOW() , NOW() ) 26/04/2023 06:02: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 = '82963' 26/04/2023 06:02:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '82963' 26/04/2023 06:02: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 ( '82963' , '20765' , 'AMEN - MAG 23' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 26/04/2023 06:02: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 ( '82963' , '20766' , 'AMEN - GIU 23' , '6' , '-6' , '4' , '3.90' , '3.9' , '0' , '5' , '22.26' ) 26/04/2023 06:44:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 06:44:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1370' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '80.84' , NOW() , NOW() ) 26/04/2023 06:44:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82964' 26/04/2023 06:44:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82964' 26/04/2023 06:44:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82964' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 26/04/2023 06:44:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82964' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 26/04/2023 06:55:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 06:55:26 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' , '1371' , '2023-04-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 26/04/2023 06:55:26 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 = '82965' 26/04/2023 06:55:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82965' 26/04/2023 06:55:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82965' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/04/2023 07:41:09 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'a8XLb62l9H97qKPC' , NOW() , NOW() ) 26/04/2023 07:41:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7040' , '1' ) 26/04/2023 07:41:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7040' , '2' ) 26/04/2023 07:41:09 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7040' , '3' ) 26/04/2023 07:43:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7040' 26/04/2023 07:43:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7040' , '10' , '180' , '' , 'ROSA ELEONORA' , 'DEGLI ESPOSTI' , 'VIA MARZABOTTO 89' , '' , '20099' , 'SESTO SAN GIOVANNI' , '' , '' , '3391676917' , '' , '' , NOW() , NOW() ) 26/04/2023 07:43:01 pm >> UPDATE ps_customer SET email = 'rosa.de@fastwebnet.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7040' 26/04/2023 07:47:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-26') 26/04/2023 07:47:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '14' , '2023-04-26' , '' , '7040' , '0' , '130686726' , 'VIA MARZABOTTO 89 20099 SESTO SAN GIOVANNI' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '77.06' , '77.06' , NOW() , NOW() ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11064' 26/04/2023 07:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '11064' 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '50' , 'PERDONAMI SIGNORE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 26/04/2023 07:47:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11064' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' )