10/05/2023 08:59:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1590' AND id_document != '84248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-09') 10/05/2023 08:59:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1590', document_date = '2023-05-09', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '84248' 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84248' 10/05/2023 08:59:34 am >> DELETE FROM ps_document_detail WHERE id_document = '84248' 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84248' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19' , '15.573770491803' , '22' , '0' , '19.00' ) 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84248' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84248' , '19590' , 'CUSTODIA BIBBIA DI GERUSALEMME ECO PELLE' , '1' , '-1' , '1' , '18.5000' , '15.16393442623' , '22' , '0' , '18.50' ) 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84248' , '2424' , 'COLLETTO DOPPIO - CM 3,5 ' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 10/05/2023 08:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84248' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 10/05/2023 09:00:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1588' AND id_document != '84246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-09') 10/05/2023 09:00:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1588', document_date = '2023-05-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.20', price_tax_excluded = '23.77', date_upd = NOW() WHERE id_document = '84246' 10/05/2023 09:00:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84246' 10/05/2023 09:00:13 am >> DELETE FROM ps_document_detail WHERE id_document = '84246' 10/05/2023 09:00:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84246' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 10/05/2023 09:00:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84246' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 10/05/2023 09:00:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84246' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 10/05/2023 09:00:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1528' AND id_document != '84172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 10/05/2023 09:00:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1528', document_date = '2023-05-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '119.00', date_upd = NOW() WHERE id_document = '84172' 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84172' 10/05/2023 09:00:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84172' 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '15334' , 'CANDELA VOTIVA 20X40' , '30' , '-30' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '21.00' ) 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '0' , '30.00' ) 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '0' , '20.00' ) 10/05/2023 09:00:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 10/05/2023 09:19:32 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/05/2023 09:19:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21054' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 09:19:32 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21054' , '1' , '1' , '2' , NOW() , NOW() ) 10/05/2023 09:19:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21054' , '0' , '1' , '0' , '0' ) 10/05/2023 09:22:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072544' AND id_product != '21054' AND ean13 != '' 10/05/2023 09:22:01 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072544', date_upd = NOW() WHERE id_product = '21054' 10/05/2023 09:22:01 am >> UPDATE ps_product_lang SET name = 'CANTICO DEI CANTICI - S. LONGOBARDI', description = '' WHERE id_product = '21054' 10/05/2023 09:22:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21054' 10/05/2023 09:22:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '141', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21054' 10/05/2023 09:22:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21054' 10/05/2023 09:22:02 am >> 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 = '21054' 10/05/2023 09:22:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21055' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 09:22:02 am >> 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 '21055' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21054' 10/05/2023 09:22:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21055' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21054' 10/05/2023 09:24:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072810' AND id_product != '21055' AND ean13 != '' 10/05/2023 09:24:05 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072810', date_upd = NOW() WHERE id_product = '21055' 10/05/2023 09:24:05 am >> UPDATE ps_product_lang SET name = 'MIA PRIMA EUCARISTIA ', description = '' WHERE id_product = '21055' 10/05/2023 09:24:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21055' 10/05/2023 09:24:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '242', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21055' 10/05/2023 09:24:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21055' 10/05/2023 09:24:06 am >> 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 = '21055' 10/05/2023 09:24:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21056' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 09:24:06 am >> 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 '21056' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21055' 10/05/2023 09:24:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21056' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21055' 10/05/2023 09:24:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072384' AND id_product != '21056' AND ean13 != '' 10/05/2023 09:24:47 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072384', date_upd = NOW() WHERE id_product = '21056' 10/05/2023 09:24:47 am >> UPDATE ps_product_lang SET name = 'MIA CRESIMA', description = '' WHERE id_product = '21056' 10/05/2023 09:24:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '21056' 10/05/2023 09:24:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '242', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21056' 10/05/2023 09:24:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21056' 10/05/2023 09:24:49 am >> 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 = '21056' 10/05/2023 09:24:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21057' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 09:24:49 am >> 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 '21057' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21056' 10/05/2023 09:24:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21057' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21056' 10/05/2023 09:25:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072643' AND id_product != '21057' AND ean13 != '' 10/05/2023 09:25:39 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072643', date_upd = NOW() WHERE id_product = '21057' 10/05/2023 09:25:39 am >> UPDATE ps_product_lang SET name = 'MIA CONFESSIONE', description = '' WHERE id_product = '21057' 10/05/2023 09:25:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '21057' 10/05/2023 09:25:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '242', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21057' 10/05/2023 09:25:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21057' 10/05/2023 09:26:04 am >> 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 = '21057' 10/05/2023 09:26:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21058' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 09:26:04 am >> 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 '21058' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21057' 10/05/2023 09:26:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21058' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21057' 10/05/2023 09:27:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072711' AND id_product != '21058' AND ean13 != '' 10/05/2023 09:27:37 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072711', date_upd = NOW() WHERE id_product = '21058' 10/05/2023 09:27:37 am >> UPDATE ps_product_lang SET name = 'ALLA SCOPERTA DEI SETTE DONI DELLO SPIRITO SANTO', description = '' WHERE id_product = '21058' 10/05/2023 09:27:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '21058' 10/05/2023 09:27:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21058' 10/05/2023 09:27:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21058' 10/05/2023 09:30:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FPR 26/23' , '2023-05-05' , '23' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '48.38' , '48.38' , NOW() , NOW() ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84253' 10/05/2023 09:30:09 am >> DELETE FROM ps_document_detail WHERE id_document = '84253' 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '21054' , 'CANTICO DEI CANTICI - S. LONGOBARDI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21054' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21054' , '174' , '1' ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '20689' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20689' , '174' , '1' ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '20690' , 'CARLO ACUTIS APOSTOLO DEI MILLENNIALS - V. RIZZO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '20690' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20690' , '174' , '1' ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '21058' , 'ALLA SCOPERTA DEI SETTE DONI DELLO SPIRITO SANTO' , '5' , '5' , '4' , '1.5' , '1.5' , '0' , '0' , '7.5000' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21058' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21058' , '174' , '1' ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '21057' , 'MIA CONFESSIONE' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '30' , '5.4600' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21057' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21057' , '174' , '1' ) 10/05/2023 09:30:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84253' , '21056' , 'MIA CRESIMA' , '2' , '2' , '4' , '2.90' , '2.9' , '0' , '30' , '4.0600' ) 10/05/2023 09:30:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '21056' AND id_supplier = '174' 10/05/2023 09:30:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21056' , '174' , '1' ) 10/05/2023 09:30: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 ( '84253' , '21055' , 'MIA PRIMA EUCARISTIA ' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '30' , '5.4600' ) 10/05/2023 09:30:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21055' AND id_supplier = '174' 10/05/2023 09:30:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21055' , '174' , '1' ) 10/05/2023 10:06:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 10:06: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' , '1595' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.46' , '52.46' , NOW() , NOW() ) 10/05/2023 10:06: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 = '84254' 10/05/2023 10:06:00 am >> DELETE FROM ps_document_detail WHERE id_document = '84254' 10/05/2023 10:06: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 ( '84254' , '6629' , 'MIA PREGHIERA' , '61' , '-61' , '4' , '0.90' , '0.9' , '0' , '5' , '52.46' ) 10/05/2023 10:16:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280562357' AND id_product != '20754' AND ean13 != '' 10/05/2023 10:16:40 am >> UPDATE ps_product SET id_supplier = '107', reference = '7/6', ean13 = '9791280562357', date_upd = NOW() WHERE id_product = '20754' 10/05/2023 10:16:40 am >> UPDATE ps_product_lang SET name = 'QUARESIMA - PASQUA - G. SACINO', description = '' WHERE id_product = '20754' 10/05/2023 10:16:40 am >> UPDATE ps_product SET wholesale_price = '10.40', on_sale = '0', price = '16.0000' WHERE id_product = '20754' 10/05/2023 10:16:40 am >> UPDATE ps_product_shop SET wholesale_price = '10.40', price = '16.0000', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20754' 10/05/2023 10:16:40 am >> DELETE FROM ps_specific_price WHERE id_product = '20754' 10/05/2023 10:17:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546517' AND id_product != '20772' AND ean13 != '' 10/05/2023 10:17:03 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9791280546517', date_upd = NOW() WHERE id_product = '20772' 10/05/2023 10:17:03 am >> UPDATE ps_product_lang SET name = 'VADO E TORNERO\' DA VOI - L. VOZZA', description = '' WHERE id_product = '20772' 10/05/2023 10:17:03 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '20772' 10/05/2023 10:17:03 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '483', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20772' 10/05/2023 10:17:03 am >> DELETE FROM ps_specific_price WHERE id_product = '20772' 10/05/2023 10:17:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801029888' AND id_product != '2699' AND ean13 != '' 10/05/2023 10:17:33 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788801029888', date_upd = NOW() WHERE id_product = '2699' 10/05/2023 10:17:33 am >> UPDATE ps_product_lang SET name = 'CONTEMPLIAMO GESÙ RISORTO - VIA LUCIS', description = '' WHERE id_product = '2699' 10/05/2023 10:17:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2000' WHERE id_product = '2699' 10/05/2023 10:17:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2000', id_tax_rules_group = '4', id_category_default = '19', 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 = '2699' 10/05/2023 10:17:33 am >> DELETE FROM ps_specific_price WHERE id_product = '2699' 10/05/2023 10:34:38 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' , '212/23' , '2023-05-09' , '23' , '0' , '0' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '361.92' , '348.00' , NOW() , NOW() ) 10/05/2023 10:34:38 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 = '84255' 10/05/2023 10:34:38 am >> DELETE FROM ps_document_detail WHERE id_document = '84255' 10/05/2023 10:34:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84255' , '20954' , 'TEMPO DELL’APOCALISSE ' , '200' , '0' , '3' , '1.74' , '1.6730769230769' , '4' , '0' , '361.9200' ) 10/05/2023 10:35:17 am >> SELECT document_num FROM ps_document WHERE document_num = '85' AND id_document != '84224' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-08') 10/05/2023 10:35:17 am >> UPDATE ps_document SET id_document_type = '21', document_num = '85', document_date = '2023-05-08', document_letter = '', id_customer = '3716', id_supplier = '', id_address = '4671455', address1 = 'CORSO ANDREA PODESTA\\\' 10 - INT. 9 16128 GENOVA', address2 = '', note = 'COPIE OMAGGIO AUTORE', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '84224' 10/05/2023 10:35:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84224' 10/05/2023 10:35:17 am >> DELETE FROM ps_document_detail WHERE id_document = '84224' 10/05/2023 10:35: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 ( '84224' , '20954' , 'TEMPO DELL’APOCALISSE ' , '30' , '-30' , '4' , '15.0000' , '15' , '0' , '100' , '0.00' ) 10/05/2023 10:44:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 10:44:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1596' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 10/05/2023 10:44:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84256' 10/05/2023 10:44:54 am >> DELETE FROM ps_document_detail WHERE id_document = '84256' 10/05/2023 10:44: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 ( '84256' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 10/05/2023 11:25:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 11:25:42 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' , '1597' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 10/05/2023 11:25:42 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 = '84257' 10/05/2023 11:25:42 am >> DELETE FROM ps_document_detail WHERE id_document = '84257' 10/05/2023 11:25:42 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 ( '84257' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 10/05/2023 11:30:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 11:30:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1598' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '62.44' , NOW() , NOW() ) 10/05/2023 11:30: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 = '84258' 10/05/2023 11:30:31 am >> DELETE FROM ps_document_detail WHERE id_document = '84258' 10/05/2023 11:30: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 ( '84258' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 10/05/2023 11:30: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 ( '84258' , '20233' , 'STATUA BEATO CARLO ACUTIS CM 28 - 425' , '1' , '-1' , '1' , '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 10/05/2023 11:36:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 11:36:32 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' , '1599' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 10/05/2023 11:36:32 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 = '84259' 10/05/2023 11:36:32 am >> DELETE FROM ps_document_detail WHERE id_document = '84259' 10/05/2023 11:36:32 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 ( '84259' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 10/05/2023 11:41:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 11:41:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1600' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 10/05/2023 11:41:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84260' 10/05/2023 11:41:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84260' 10/05/2023 11:41:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84260' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 10/05/2023 12:11:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1600' AND id_document != '84260' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 12:11:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1600', document_date = '2023-05-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '84260' 10/05/2023 12:11:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84260' 10/05/2023 12:11:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '84260' 10/05/2023 12:11:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84260' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '100' , '-100' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '20.00' ) 10/05/2023 12:11:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/05/2023 12:11:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21059' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 12:11:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21059' , '1' , '1' , '2' , NOW() , NOW() ) 10/05/2023 12:11:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21059' , '0' , '1' , '0' , '0' ) 10/05/2023 12:12:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864099156' AND id_product != '21059' AND ean13 != '' 10/05/2023 12:12:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788864099156', date_upd = NOW() WHERE id_product = '21059' 10/05/2023 12:12:37 pm >> UPDATE ps_product_lang SET name = 'PADRONE DEL MONDO - R. H. BENSON', description = '' WHERE id_product = '21059' 10/05/2023 12:12:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.5' WHERE id_product = '21059' 10/05/2023 12:12:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.5', id_tax_rules_group = '4', id_category_default = '100', 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 = '21059' 10/05/2023 12:12:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '21059' 10/05/2023 12:12:39 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 = '21059' 10/05/2023 12:12:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21060' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 12:12:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21060' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21059' 10/05/2023 12:12:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21060' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21059' 10/05/2023 12:13:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780657' AND id_product != '21060' AND ean13 != '' 10/05/2023 12:13:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9791254780657', date_upd = NOW() WHERE id_product = '21060' 10/05/2023 12:13:34 pm >> UPDATE ps_product_lang SET name = 'PREPARARSI ALL\'AMORE - L. DUMOULIN', description = '' WHERE id_product = '21060' 10/05/2023 12:13:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '21060' 10/05/2023 12:13:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21060' 10/05/2023 12:13:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '21060' 10/05/2023 12:13:40 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 = '21060' 10/05/2023 12:13:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21061' , '1' , '' , 'nuovo-prodotto' ) 10/05/2023 12:13:40 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 '21061' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21060' 10/05/2023 12:13:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21061' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21060' 10/05/2023 12:14:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259622259' AND id_product != '21061' AND ean13 != '' 10/05/2023 12:14:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259622259', date_upd = NOW() WHERE id_product = '21061' 10/05/2023 12:14:25 pm >> UPDATE ps_product_lang SET name = 'ALLE SORGENTI DELLA FEDE IN TERRA SANTA - F. VOLTAGGIO', description = '' WHERE id_product = '21061' 10/05/2023 12:14:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21061' 10/05/2023 12:14:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21061' 10/05/2023 12:14:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '21061' 10/05/2023 12:15:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '940578' , '2023-05-09' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '200.00' , NOW() , NOW() ) 10/05/2023 12:15:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84261' 10/05/2023 12:15:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '84261' 10/05/2023 12:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84261' , '21061' , 'ALLE SORGENTI DELLA FEDE IN TERRA SANTA - F. VOLTAGGIO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 10/05/2023 12:15:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21061' AND id_supplier = '109' 10/05/2023 12:15:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21061' , '109' , '1' ) 10/05/2023 12:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84261' , '21060' , 'PREPARARSI ALLAMORE - L. DUMOULIN' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 10/05/2023 12:15:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21060' AND id_supplier = '109' 10/05/2023 12:15:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21060' , '109' , '1' ) 10/05/2023 12:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84261' , '21059' , 'PADRONE DEL MONDO - R. H. BENSON' , '10' , '10' , '4' , '14.50' , '14.5' , '0' , '0' , '145.0000' ) 10/05/2023 12:15:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21059' AND id_supplier = '109' 10/05/2023 12:15:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21059' , '109' , '1' ) 10/05/2023 12:15:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84261' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 10/05/2023 12:15:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20941' AND id_supplier = '109' 10/05/2023 12:15:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20941' , '109' , '1' ) 10/05/2023 12:21:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 12:21:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1601' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 10/05/2023 12:21:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84262' 10/05/2023 12:21:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '84262' 10/05/2023 12:21:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84262' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 10/05/2023 12:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 12:26:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1602' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '137.80' , '137.80' , NOW() , NOW() ) 10/05/2023 12:26:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84263' 10/05/2023 12:26:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '84263' 10/05/2023 12:26:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84263' , '21059' , 'PADRONE DEL MONDO - R. H. BENSON' , '10' , '-10' , '4' , '14.50' , '14.5' , '0' , '5' , '137.80' ) 10/05/2023 12:33:25 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') 10/05/2023 12:33:25 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 = '136.90', price_tax_excluded = '136.90', date_upd = NOW() WHERE id_document = '81317' 10/05/2023 12:33: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 = '81317' 10/05/2023 12:33:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 10/05/2023 12:33: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 ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 10/05/2023 12:33: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 ( '81317' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 10/05/2023 12:33: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 ( '81317' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 10/05/2023 12:33: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 ( '81317' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 10/05/2023 12:33: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 ( '81317' , '19650' , 'UNBOUND' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 10/05/2023 12:33: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 ( '81317' , '20988' , 'SIGNORE NON NE POSSO PIU - P. DESCOUVEMONT' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 10/05/2023 12:33: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 ( '81317' , '20810' , 'SAPIENZA DEL VANGELO - F. BERSINI' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '0' , '23.00' ) 10/05/2023 12:33: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 ( '81317' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 10/05/2023 12:34: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') 10/05/2023 12:34: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 = '11.80', price_tax_excluded = '11.80', date_upd = NOW() WHERE id_document = '81317' 10/05/2023 12:34: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' 10/05/2023 12:34:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 10/05/2023 12:34: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' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 10/05/2023 12:34: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' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 10/05/2023 12:34: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' , '20998' , 'PAROLA E PREGHIERA - LUG. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 10/05/2023 12:35:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1339' AND id_document != '82923' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-21') 10/05/2023 12:35:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1339', document_date = '2023-04-21', 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 = '35.00', price_tax_excluded = '34.28', date_upd = NOW() WHERE id_document = '82923' 10/05/2023 12:35:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82923' 10/05/2023 12:35:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82923' 10/05/2023 12:35:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82923' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '9.15' , '9.15' , '0' , '0' , '9.15' ) 10/05/2023 12:35:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82923' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 10/05/2023 12:35:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82923' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/05/2023 12:35:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82923' , '20810' , 'SAPIENZA DEL VANGELO - F. BERSINI' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 10/05/2023 12:37:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1359' AND id_document != '82947' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 10/05/2023 12:37:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1359', 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 = '70.50', price_tax_excluded = '64.30', date_upd = NOW() WHERE id_document = '82947' 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82947' 10/05/2023 12:37:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82947' 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '13' , '-13' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '18.20' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 10/05/2023 12:37:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82947' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.52' , '0.52' , '0' , '0' , '1.04' ) 10/05/2023 12:38:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1397' AND id_document != '82993' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 10/05/2023 12:38:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1397', document_date = '2023-04-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '82993' 10/05/2023 12:38: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 = '82993' 10/05/2023 12:38:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82993' 10/05/2023 12:38: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 ( '82993' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8.9' , '8.9' , '0' , '0' , '8.90' ) 10/05/2023 12:38: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 ( '82993' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 10/05/2023 12:39:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1411' AND id_document != '83010' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 10/05/2023 12:39:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1411', document_date = '2023-04-28', 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 = '27.75', price_tax_excluded = '27.03', date_upd = NOW() WHERE id_document = '83010' 10/05/2023 12:39:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83010' 10/05/2023 12:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '83010' 10/05/2023 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83010' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '0.95' , '0.95' , '0' , '0' , '4.75' ) 10/05/2023 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83010' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 10/05/2023 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83010' , '19650' , 'UNBOUND' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 10/05/2023 12:41:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1445' AND id_document != '83050' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 10/05/2023 12:41:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1445', document_date = '2023-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '453.00', price_tax_excluded = '392.50', date_upd = NOW() WHERE id_document = '83050' 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '83050' 10/05/2023 12:41:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '83050' 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '17034' , 'SACRAMENTO DEL PERDONO' , '6' , '-6' , '4' , '2.0000' , '2' , '0' , '5' , '11.40' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '16882' , 'S. RITA DA CASCIA VITA BREVIS' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '8398' , 'PREGHIERE PRIMA E DOPO LA COMUNIONE - 8276' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '7436' , 'PANE DI SANTANTONIO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '10726' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '19155' , 'TREDICINA A SANTANTONIO - 8042' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.6500' , '0.65' , '0' , '0' , '1.30' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '8365' , 'PREGHIERE DI BENEDIZIONE E DI LIBERAZIONE...' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '20932' , 'SOSTARE CON DIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '13886' , 'CANDELABRO BAROCCO ROCCOCO CM 30 OTTONE- DM185R' , '2' , '-2' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '290.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '1937' , 'CERETTI DIAM. 40X400 - ART.500 - 4040' , '2' , '-2' , '1' , '4.4000' , '3.6065573770492' , '22' , '100' , '0.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.4000' , '6.0655737704918' , '22' , '0' , '14.80' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '11.8000' , '9.672131147541' , '22' , '0' , '11.80' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.9000' , '4.8360655737705' , '22' , '0' , '5.90' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '20988' , 'SIGNORE NON NE POSSO PIU - P. DESCOUVEMONT' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 10/05/2023 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83050' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 10/05/2023 12:59:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 12:59: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' , '1603' , '2023-05-10' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '75.32' , NOW() , NOW() ) 10/05/2023 12:59: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 = '84264' 10/05/2023 12:59:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '84264' 10/05/2023 12:59: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 ( '84264' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 10/05/2023 12:59: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 ( '84264' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 10/05/2023 12:59: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 ( '84264' , '7907' , 'PERGAMENE' , '40' , '-40' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '20.00' ) 10/05/2023 12:59: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 ( '84264' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/05/2023 06:40:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 06:40: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' , '1604' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 10/05/2023 06:40: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 = '84265' 10/05/2023 06:40:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '84265' 10/05/2023 06:40: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 ( '84265' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 10/05/2023 06:43:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 06:43:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1605' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.52' , '24.52' , NOW() , NOW() ) 10/05/2023 06:43:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84266' 10/05/2023 06:43:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '84266' 10/05/2023 06:43:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84266' , '1116' , 'BIBBIA DEI BAMBINI' , '2' , '-2' , '4' , '12.90' , '12.9' , '0' , '5' , '24.52' ) 10/05/2023 06:45:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 06:45:09 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' , '1606' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 10/05/2023 06:45: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 = '84267' 10/05/2023 06:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '84267' 10/05/2023 06:45:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84267' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 10/05/2023 06:58:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-10') 10/05/2023 06:58:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1607' , '2023-05-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '48.00' , NOW() , NOW() ) 10/05/2023 06:58:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84268' 10/05/2023 06:58:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '84268' 10/05/2023 06:58: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 ( '84268' , '19744' , 'ASCOLTAMI GESU' , '24' , '-24' , '4' , '2.00' , '2' , '0' , '0' , '48.00' )