12/04/2023 08:07:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400001860' AND id_product != '16986' AND ean13 != '' 12/04/2023 08:07:43 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400001860', date_upd = NOW() WHERE id_product = '16986' 12/04/2023 08:07:43 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 SACRO CUORE', description = '' WHERE id_product = '16986' 12/04/2023 08:07:43 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '16986' 12/04/2023 08:07:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '16986' 12/04/2023 08:07:43 am >> DELETE FROM ps_specific_price WHERE id_product = '16986' 12/04/2023 08:07:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012439' AND id_product != '16989' AND ean13 != '' 12/04/2023 08:07:58 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400012439', date_upd = NOW() WHERE id_product = '16989' 12/04/2023 08:07:58 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA', description = '' WHERE id_product = '16989' 12/04/2023 08:07:59 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '16989' 12/04/2023 08:07:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '16989' 12/04/2023 08:07:59 am >> DELETE FROM ps_specific_price WHERE id_product = '16989' 12/04/2023 08:08:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400001785' AND id_product != '14686' AND ean13 != '' 12/04/2023 08:08:18 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400001785', date_upd = NOW() WHERE id_product = '14686' 12/04/2023 08:08:18 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 MISERICORDIOSO', description = '' WHERE id_product = '14686' 12/04/2023 08:08:18 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '14686' 12/04/2023 08:08:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '14686' 12/04/2023 08:08:18 am >> DELETE FROM ps_specific_price WHERE id_product = '14686' 12/04/2023 08:08:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400002164' AND id_product != '16988' AND ean13 != '' 12/04/2023 08:08:33 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400002164', date_upd = NOW() WHERE id_product = '16988' 12/04/2023 08:08:33 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 IMMACOLATA', description = '' WHERE id_product = '16988' 12/04/2023 08:08:33 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '16988' 12/04/2023 08:08:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '16988' 12/04/2023 08:08:33 am >> DELETE FROM ps_specific_price WHERE id_product = '16988' 12/04/2023 08:08:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400011333' AND id_product != '16987' AND ean13 != '' 12/04/2023 08:08:46 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400011333', date_upd = NOW() WHERE id_product = '16987' 12/04/2023 08:08:46 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 MADONNA DEL CARMINE - 1269/M250', description = '' WHERE id_product = '16987' 12/04/2023 08:08:46 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '16987' 12/04/2023 08:08:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '16987' 12/04/2023 08:08:46 am >> DELETE FROM ps_specific_price WHERE id_product = '16987' 12/04/2023 08:09:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012941' AND id_product != '8645' AND ean13 != '' 12/04/2023 08:09:13 am >> UPDATE ps_product SET id_supplier = '28', reference = '2016', ean13 = '8058400012941', date_upd = NOW() WHERE id_product = '8645' 12/04/2023 08:09:13 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SANTA RITA - 1269/s59', description = '' WHERE id_product = '8645' 12/04/2023 08:09:13 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '8645' 12/04/2023 08:09:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '8645' 12/04/2023 08:09:13 am >> DELETE FROM ps_specific_price WHERE id_product = '8645' 12/04/2023 09:18:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 09:18:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1209' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/04/2023 09:18: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 = '82753' 12/04/2023 09:18:09 am >> DELETE FROM ps_document_detail WHERE id_document = '82753' 12/04/2023 09:18: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 ( '82753' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/04/2023 09:40:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 09:40:37 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' , '1210' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.21' , '31.17' , NOW() , NOW() ) 12/04/2023 09:40:37 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 = '82754' 12/04/2023 09:40:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82754' 12/04/2023 09:40: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 ( '82754' , '4404' , 'GESÙ CONFIDO IN TE - 296' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 12/04/2023 09:40: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 ( '82754' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 12/04/2023 09:40: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 ( '82754' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 12/04/2023 10:00:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 10:00: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' , '1211' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '124.84' , NOW() , NOW() ) 12/04/2023 10:00: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 = '82755' 12/04/2023 10:00:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82755' 12/04/2023 10:00:36 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 ( '82755' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 12/04/2023 10:00:36 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 ( '82755' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 12/04/2023 10:00:36 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 ( '82755' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '77.55' , '63.565573770492' , '22' , '0' , '77.55' ) 12/04/2023 10:00:36 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 ( '82755' , '19477' , 'ROSARIO CON DON ORESTE BENZI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/04/2023 10:00:36 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 ( '82755' , '15522' , 'ROSARIO MEDITATO - G. MARINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/04/2023 10:00:36 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 ( '82755' , '9165' , 'ROSARIO PER SCOPRIRE IL VOLTO...' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/04/2023 10:00:36 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 ( '82755' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '10' , '-10' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.00' ) 12/04/2023 10:04:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 10:04: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' , '1212' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '43.74' , NOW() , NOW() ) 12/04/2023 10:04: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 = '82756' 12/04/2023 10:04:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82756' 12/04/2023 10:04: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 ( '82756' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 12/04/2023 10:04: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 ( '82756' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 12/04/2023 10:04: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 ( '82756' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 12/04/2023 10:40:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 10:40:47 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' , '1213' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 12/04/2023 10:40:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82757' 12/04/2023 10:40:47 am >> DELETE FROM ps_document_detail WHERE id_document = '82757' 12/04/2023 10:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82757' , '20167' , 'CROCE CORPO RESINA 17X12' , '1' , '-1' , '1' , '9.85' , '8.0737704918033' , '22' , '0' , '9.85' ) 12/04/2023 10:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82757' , '13319' , 'VIVI LA VITA - 30' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 12/04/2023 10:49:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 10:49:33 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' , '1214' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 12/04/2023 10:49: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 = '82758' 12/04/2023 10:49:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82758' 12/04/2023 10:49: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 ( '82758' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '3' , '-3' , '1' , '13' , '10.655737704918' , '22' , '0' , '39.00' ) 12/04/2023 10:49: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 ( '82758' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '3' , '-3' , '1' , '11' , '9.016393442623' , '22' , '0' , '33.00' ) 12/04/2023 10:49: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 ( '82758' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 12/04/2023 10:49: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 ( '82758' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 12/04/2023 11:04:53 am >> SELECT document_num FROM ps_document WHERE document_num = '936' AND id_document != '82422' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23') 12/04/2023 11:04:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '936', document_date = '2023-03-23', 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 = '29.49', price_tax_excluded = '27.69', date_upd = NOW() WHERE id_document = '82422' 12/04/2023 11:04: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 = '82422' 12/04/2023 11:04:53 am >> DELETE FROM ps_document_detail WHERE id_document = '82422' 12/04/2023 11:04:53 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 ( '82422' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 12/04/2023 11:04:53 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 ( '82422' , '11192' , 'VENITE CON ME 2 PARTE' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.76' ) 12/04/2023 11:04:53 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 ( '82422' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 12/04/2023 11:04:53 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 ( '82422' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/04/2023 11:16:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 11:16:26 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' , '1215' , '2023-04-12' , '' , '0' , '0' , '0' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '360.40' , '311.43' , NOW() , NOW() ) 12/04/2023 11:16: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 = '82759' 12/04/2023 11:16:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82759' 12/04/2023 11:16: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 ( '82759' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.8197' , '22' , '0' , '10.00' ) 12/04/2023 11:16: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 ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.9836' , '22' , '0' , '14.40' ) 12/04/2023 11:16: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 ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.8197' , '22' , '0' , '6.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8689' , '22' , '0' , '7.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.459' , '22' , '0' , '3.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377' , '22' , '0' , '7.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.9836' , '22' , '0' , '14.40' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.0000' , '69.6721' , '22' , '0' , '85.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.9836' , '22' , '0' , '14.40' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '19.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17884' , 'CROCE MOGANO CORPO MET CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '17' , '-17' , '1' , '1.2000' , '0.9836' , '22' , '0' , '20.40' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9231' , '4' , '0' , '14.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '1' , '-1' , '1' , '9.0000' , '7.377' , '22' , '0' , '9.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '9095' , 'ROSARIO DEI SETTE DOLORI DELLA VERGINE - 8140' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17884' , 'CROCE MOGANO CORPO MET. CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 12/04/2023 11:16:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.5000' , '0.4098' , '22' , '0' , '1.00' ) 12/04/2023 11:22:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 11:22:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1216' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 12/04/2023 11:22:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82760' 12/04/2023 11:22:23 am >> DELETE FROM ps_document_detail WHERE id_document = '82760' 12/04/2023 11:22:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82760' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 12/04/2023 11:27:15 am >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '82656' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 12/04/2023 11:27:15 am >> UPDATE ps_document SET id_document_type = '22', document_num = '14/E', document_date = '2023-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MARZO 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '5705.20', price_tax_excluded = '5696.18', date_upd = NOW() WHERE id_document = '82656' 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82656' 12/04/2023 11:27:15 am >> DELETE FROM ps_document_detail WHERE id_document = '82656' 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '193' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '231.60' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '9675' , 'SARETE MIEI TESTIMONI' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.65' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '5457' , 'IO SONO CON VOI 1 PARTE' , '59' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '73.75' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '36.25' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11191' , 'VENITE CON ME 1 PARTE' , '91' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '113.75' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11192' , 'VENITE CON ME 2 PARTE' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '52' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '22.10' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '6' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '2.55' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '21.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '9996' , 'SIGNORE, TI PREGO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '48.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '6629' , 'MIA PREGHIERA' , '432' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '194.40' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8408' , 'PRENDETE E MANGIATE' , '83' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '124.50' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '4154' , 'FESTA DEL PERDONO' , '114' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '171.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '25' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '11.25' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '2679' , 'CONOSCERE GESU\'' , '32' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '56.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '100.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '8.50' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '547' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '437.60' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '3.20' ) 12/04/2023 11:27:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '7' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '5.60' ) 12/04/2023 11:27: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 ( '82656' , '12819' , 'REGISTRO DEL CATECHISTA ' , '100' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '50.00' ) 12/04/2023 11:27: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 ( '82656' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '28.00' ) 12/04/2023 11:27: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 ( '82656' , '12813' , 'MARIA MADRE NOSTRA' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 12/04/2023 11:27: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 ( '82656' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '32' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '96.00' ) 12/04/2023 11:27: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 ( '82656' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 12/04/2023 11:27: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 ( '82656' , '13397' , 'MIO GESU' , '8' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 12/04/2023 11:27: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 ( '82656' , '14032' , 'AVE MARIA' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 12/04/2023 11:27: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 ( '82656' , '14029' , 'ANGELO DI DIO' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 12/04/2023 11:27: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 ( '82656' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '7' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '3.50' ) 12/04/2023 11:27: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 ( '82656' , '15019' , 'PREGHIAMO CON MARIA' , '65' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '26.00' ) 12/04/2023 11:27: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 ( '82656' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '7.00' ) 12/04/2023 11:27: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 ( '82656' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '981' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '490.50' ) 12/04/2023 11:27: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 ( '82656' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 12/04/2023 11:27: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 ( '82656' , '16667' , 'VIA CRUCIS' , '10' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '15.00' ) 12/04/2023 11:27: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 ( '82656' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '22.50' ) 12/04/2023 11:27: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 ( '82656' , '17257' , 'IO TI BATTEZZO ' , '8' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '7.20' ) 12/04/2023 11:27: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 ( '82656' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '7.60' ) 12/04/2023 11:27: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 ( '82656' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 12/04/2023 11:27: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 ( '82656' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 12/04/2023 11:27: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 ( '82656' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '28' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '26.60' ) 12/04/2023 11:27: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 ( '82656' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '33' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '41.25' ) 12/04/2023 11:27: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 ( '82656' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '93' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '69.75' ) 12/04/2023 11:27: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 ( '82656' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '26' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '91.00' ) 12/04/2023 11:27: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 ( '82656' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.8000' , '4.8' , '0' , '50' , '2.40' ) 12/04/2023 11:27: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 ( '82656' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 12/04/2023 11:27: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 ( '82656' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 12/04/2023 11:27: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 ( '82656' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 12/04/2023 11:27: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 ( '82656' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 12/04/2023 11:27: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 ( '82656' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '9' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '45.00' ) 12/04/2023 11:27: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 ( '82656' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 12/04/2023 11:27: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 ( '82656' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '10' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '60.00' ) 12/04/2023 11:27: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 ( '82656' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '30.00' ) 12/04/2023 11:27: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 ( '82656' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '14' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '17.50' ) 12/04/2023 11:27: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 ( '82656' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '44' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '99.00' ) 12/04/2023 11:27: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 ( '82656' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '16' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '280.00' ) 12/04/2023 11:27: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 ( '82656' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 12/04/2023 11:27: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 ( '82656' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '5' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '25.00' ) 12/04/2023 11:27: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 ( '82656' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 12/04/2023 11:27: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 ( '82656' , '20719' , 'CORONA DELL’ADDOLORATA' , '158' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '142.20' ) 12/04/2023 11:27: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 ( '82656' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '288' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '288.00' ) 12/04/2023 11:27: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 ( '82656' , '20721' , 'AVE MARIA - L. CALABRETTA' , '137' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '308.25' ) 12/04/2023 11:27: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 ( '82656' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '149' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '335.25' ) 12/04/2023 11:27: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 ( '82656' , '20722' , 'SEMINATORI DI GIOIA' , '336' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '420.00' ) 12/04/2023 11:27: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 ( '82656' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '207' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '258.75' ) 12/04/2023 11:27: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 ( '82656' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '80' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '400.00' ) 12/04/2023 11:27: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 ( '82656' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 12/04/2023 11:49:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 11:49:26 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' , '1217' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '88.81' , NOW() , NOW() ) 12/04/2023 11:49: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 = '82761' 12/04/2023 11:49:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82761' 12/04/2023 11:49: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 ( '82761' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/04/2023 11:49: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 ( '82761' , '20900' , 'BACILE DORATO - 689' , '1' , '-1' , '1' , '89.8' , '73.606557377049' , '22' , '0' , '89.80' ) 12/04/2023 11:52:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 11:52:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1218' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 12/04/2023 11:52:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82762' 12/04/2023 11:52:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82762' 12/04/2023 11:52:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82762' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 12/04/2023 12:09:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:09: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 ( '24' , '53/A' , '2023-04-12' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.40' , '85.32' , NOW() , NOW() ) 12/04/2023 12:09: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 = '82763' 12/04/2023 12:09:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82763' 12/04/2023 12:09: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 ( '82763' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/04/2023 12:09: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 ( '82763' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.00' , '49' , '0' , '5' , '46.55' ) 12/04/2023 12:09: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 ( '82763' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 12/04/2023 12:09: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 ( '82763' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 12/04/2023 12:09: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 ( '82763' , '11151' , 'LIBRI immagini misericordioso' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 12/04/2023 12:11:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:11:30 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' , '1219' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '39.75' , NOW() , NOW() ) 12/04/2023 12:11:30 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 = '82764' 12/04/2023 12:11:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82764' 12/04/2023 12:11:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82764' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 12/04/2023 12:11:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82764' , '20515' , 'DECINA ULIVO - 04/7-D' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 12/04/2023 12:36:29 pm >> DELETE FROM ps_document WHERE id_document = '82289' 12/04/2023 12:36:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82289' 12/04/2023 12:36:37 pm >> DELETE FROM ps_document WHERE id_document = '81297' 12/04/2023 12:36:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '81297' 12/04/2023 12:48:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:48:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '62' , '2023-04-12' , '' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 12/04/2023 12:48:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82765' 12/04/2023 12:48:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82765' 12/04/2023 12:48:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82765' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '28' , '-28' , '4' , '3' , '3' , '0' , '' , '84.00' ) 12/04/2023 12:48:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '82765' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:48:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '62', document_date = '2023-04-12', document_letter = '', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '84.00', price_tax_excluded = '84.00', date_upd = NOW() WHERE id_document = '82765' 12/04/2023 12:48:48 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 = '82765' 12/04/2023 12:48:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '82765' 12/04/2023 12:48:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82765' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '28' , '-28' , '4' , '3.0000' , '3' , '0' , '' , '84.00' ) 12/04/2023 12:49:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:49:18 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' , '1220' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.40' , '127.38' , NOW() , NOW() ) 12/04/2023 12:49:18 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 = '82766' 12/04/2023 12:49:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '82766' 12/04/2023 12:54:22 pm >> DELETE FROM ps_document WHERE id_document = '82766' 12/04/2023 12:54:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82766' 12/04/2023 12:56:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 12:56:48 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' , '1220' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.40' , '127.38' , NOW() , NOW() ) 12/04/2023 12:56:48 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 = '82767' 12/04/2023 12:56:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '82767' 12/04/2023 12:56:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82767' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 12/04/2023 12:56:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82767' , '15055' , 'CROCE PADRE NOSTRO' , '30' , '-30' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '84.00' ) 12/04/2023 12:56:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82767' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/04/2023 03:35:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 03:35:05 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' , '1221' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.03' , '15.03' , NOW() , NOW() ) 12/04/2023 03:35:05 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 = '82768' 12/04/2023 03:35:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82768' 12/04/2023 03:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82768' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 12/04/2023 03:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82768' , '17767' , 'SCOPRIAMO INSIEME LA QUARESIMA E PASQUA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 12/04/2023 03:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82768' , '7682' , 'PASQUA SPIEGATA AI BAMBINI ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 12/04/2023 03:35:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82768' , '4158' , 'FESTE CRISTIANE SPIEGATE AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 12/04/2023 04:48:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 04:48:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1222' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 12/04/2023 04:48:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82769' 12/04/2023 04:48:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82769' 12/04/2023 04:48:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82769' , '20869' , 'CARA MAMMA - TONINO BELLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 12/04/2023 04:48:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82769' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/04/2023 04:51:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '63' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 04:51: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 ( '21' , '63' , '2023-04-12' , '' , '939' , '0' , '4670801' , 'VIA MAZZARINO,12 90018 TERMINI IMERESE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '44.23' , '44.23' , NOW() , NOW() ) 12/04/2023 04:51: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 = '82770' 12/04/2023 04:51:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82770' 12/04/2023 04:51: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 ( '82770' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/04/2023 04:51: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 ( '82770' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 12/04/2023 04:51: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 ( '82770' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/04/2023 04:51: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 ( '82770' , '13956' , 'MIRACOLI DI GESU\'' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/04/2023 04:51: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 ( '82770' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 12/04/2023 04:51: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 ( '82770' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 12/04/2023 04:51: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 ( '82770' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 12/04/2023 04:51: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 ( '82770' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/04/2023 04:51: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 ( '82770' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/04/2023 04:51: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 ( '82770' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 12/04/2023 05:33:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 05:33: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' , '1223' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '77.79' , NOW() , NOW() ) 12/04/2023 05:33: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 = '82771' 12/04/2023 05:33:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82771' 12/04/2023 05:33: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 ( '82771' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 12/04/2023 05:33: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 ( '82771' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 12/04/2023 05:33: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 ( '82771' , '15104' , 'ROSARIO BOTTIGLIA ' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/04/2023 05:42:32 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/04/2023 05:42:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20905' , '1' , '' , 'nuovo-prodotto' ) 12/04/2023 05:42:32 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20905' , '1' , '1' , '2' , NOW() , NOW() ) 12/04/2023 05:42:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20905' , '0' , '1' , '0' , '0' ) 12/04/2023 05:43:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817180931' AND id_product != '20905' AND ean13 != '' 12/04/2023 05:43:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788817180931', date_upd = NOW() WHERE id_product = '20905' 12/04/2023 05:43:36 pm >> UPDATE ps_product_lang SET name = 'PADRE PIO STORIA DEL SANTO - A. TORNIELLI', description = '' WHERE id_product = '20905' 12/04/2023 05:43:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20905' 12/04/2023 05:43:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '239', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20905' 12/04/2023 05:43:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20905' 12/04/2023 05:43:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20905' 12/04/2023 05:43:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20906' , '1' , '' , 'nuovo-prodotto' ) 12/04/2023 05:43:38 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 '20906' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20905' 12/04/2023 05:43:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20906' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20905' 12/04/2023 05:44:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856690613' AND id_product != '20906' AND ean13 != '' 12/04/2023 05:44:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788856690613', date_upd = NOW() WHERE id_product = '20906' 12/04/2023 05:44:56 pm >> UPDATE ps_product_lang SET name = 'ESORCISTI CONTRO SATANA - F. MARCHESE RAGONA', description = '' WHERE id_product = '20906' 12/04/2023 05:44:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '20906' 12/04/2023 05:44:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '70', 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 = '20906' 12/04/2023 05:44:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20906' 12/04/2023 05:44:57 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 = '20906' 12/04/2023 05:44:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20907' , '1' , '' , 'nuovo-prodotto' ) 12/04/2023 05:44:57 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 '20907' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20906' 12/04/2023 05:44:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20907' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20906' 12/04/2023 05:47:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788845279935' AND id_product != '13580' AND ean13 != '' 12/04/2023 05:47:27 pm >> UPDATE ps_product SET id_supplier = '47', reference = '', ean13 = '9788845279935', date_upd = NOW() WHERE id_product = '13580' 12/04/2023 05:47:27 pm >> UPDATE ps_product_lang SET name = 'CATTEDRE DEI NON CREDENTI - C.M. MARTINI', description = '' WHERE id_product = '13580' 12/04/2023 05:47:27 pm >> UPDATE ps_product SET wholesale_price = '17.50', on_sale = '0', price = '35' WHERE id_product = '13580' 12/04/2023 05:47:27 pm >> UPDATE ps_product_shop SET wholesale_price = '17.50', price = '35', id_tax_rules_group = '4', id_category_default = '330', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13580' 12/04/2023 05:47:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '13580' 12/04/2023 05:54:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 05:54:05 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' , '1224' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/04/2023 05:54:05 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 = '82772' 12/04/2023 05:54:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82772' 12/04/2023 05:54:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82772' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/04/2023 06:04:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '64' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 06:04:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '64' , '2023-04-12' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '26.52' , '26.52' , NOW() , NOW() ) 12/04/2023 06:04:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82773' 12/04/2023 06:04:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82773' 12/04/2023 06:04:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82773' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.40' , '2.4' , '0' , '15' , '26.52' ) 12/04/2023 06:14:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 06:14: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 ( '11' , '1225' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '40.25' , NOW() , NOW() ) 12/04/2023 06:14: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 = '82774' 12/04/2023 06:14:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82774' 12/04/2023 06:14: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 ( '82774' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 12/04/2023 06:14: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 ( '82774' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/04/2023 06:17:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '64' AND id_document != '82773' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 06:17:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '64', document_date = '2023-04-12', document_letter = '', id_customer = '1138', id_supplier = '', id_address = '4672220', address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '63.24', price_tax_excluded = '63.24', date_upd = NOW() WHERE id_document = '82773' 12/04/2023 06:17: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 = '82773' 12/04/2023 06:17:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82773' 12/04/2023 06:17: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 ( '82773' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.4' , '2.4' , '0' , '15' , '26.52' ) 12/04/2023 06:17: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 ( '82773' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '18' , '-18' , '4' , '2.40' , '2.4' , '0' , '15' , '36.72' ) 12/04/2023 06:36: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' , '3721' , '2023-04-12' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '6.64' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '105.83' , '105.83' , NOW() , NOW() ) 12/04/2023 06:36: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 = '82775' 12/04/2023 06:36:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82775' 12/04/2023 06:36: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 ( '82775' , '13580' , 'CATTEDRE DEI NON CREDENTI - C.M. MARTINI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 12/04/2023 06:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13580' AND id_supplier = '105' 12/04/2023 06:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13580' , '105' , '1' ) 12/04/2023 06:36: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 ( '82775' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '30' , '11.8300' ) 12/04/2023 06:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20794' AND id_supplier = '105' 12/04/2023 06:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20794' , '105' , '1' ) 12/04/2023 06:36: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 ( '82775' , '20906' , 'ESORCISTI CONTRO SATANA - F. MARCHESE RAGONA' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '30' , '13.2300' ) 12/04/2023 06:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20906' AND id_supplier = '105' 12/04/2023 06:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20906' , '105' , '1' ) 12/04/2023 06:36: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 ( '82775' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '30' , '11.8300' ) 12/04/2023 06:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '105' 12/04/2023 06:36:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '105' , '1' ) 12/04/2023 06:36: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 ( '82775' , '20905' , 'PADRE PIO STORIA DEL SANTO - A. TORNIELLI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 12/04/2023 06:36:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20905' AND id_supplier = '105' 12/04/2023 06:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20905' , '105' , '1' ) 12/04/2023 06:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82775' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 12/04/2023 06:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '105' 12/04/2023 06:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '105' , '1' ) 12/04/2023 06:36:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82775' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 12/04/2023 06:36:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20745' AND id_supplier = '105' 12/04/2023 06:36:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20745' , '105' , '1' ) 12/04/2023 07:23:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1226' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 07:23:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1226' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 12/04/2023 07:23:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82776' 12/04/2023 07:23:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '82776' 12/04/2023 07:23:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82776' , '19750' , 'INCENSO LUCAS' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 12/04/2023 07:39:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 12/04/2023 07:39:36 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' , '1227' , '2023-04-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.00' , '105.20' , NOW() , NOW() ) 12/04/2023 07:39:36 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 = '82777' 12/04/2023 07:39:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82777' 12/04/2023 07:39:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82777' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/04/2023 07:39:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82777' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/04/2023 07:39:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82777' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '116' , '95.081967213115' , '22' , '0' , '116.00' ) 12/04/2023 07:53:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-LOU' AND id_product != '6314' AND ean13 != '' 12/04/2023 07:53:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = 'G022-LOU', date_upd = NOW() WHERE id_product = '6314' 12/04/2023 07:53:06 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA LOURDES MM 22', description = '' WHERE id_product = '6314' 12/04/2023 07:53:06 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6314' 12/04/2023 07:53:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6314' 12/04/2023 07:53:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '6314' 12/04/2023 07:53:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-GIU' AND id_product != '17783' AND ean13 != '' 12/04/2023 07:53:14 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-GIU', date_upd = NOW() WHERE id_product = '17783' 12/04/2023 07:53:14 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA OVALE S. GIUSEPPE CM 2,2 ', description = '' WHERE id_product = '17783' 12/04/2023 07:53:14 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '17783' 12/04/2023 07:53:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '17783' 12/04/2023 07:53:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '17783' 12/04/2023 07:53:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-FAT' AND id_product != '6316' AND ean13 != '' 12/04/2023 07:53:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = 'G022-FAT', date_upd = NOW() WHERE id_product = '6316' 12/04/2023 07:53:24 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MAD. FATIMA - OGGETTI', description = '' WHERE id_product = '6316' 12/04/2023 07:53:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6316' 12/04/2023 07:53:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6316' 12/04/2023 07:53:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '6316' 12/04/2023 07:53:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-MIR' AND id_product != '6325' AND ean13 != '' 12/04/2023 07:53:35 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2014', ean13 = 'G022-MIR', date_upd = NOW() WHERE id_product = '6325' 12/04/2023 07:53:35 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX', description = '' WHERE id_product = '6325' 12/04/2023 07:53:35 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6325' 12/04/2023 07:53:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6325' 12/04/2023 07:53:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '6325' 12/04/2023 07:53:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-MIS' AND id_product != '6328' AND ean13 != '' 12/04/2023 07:53:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = 'G022-MIS', date_upd = NOW() WHERE id_product = '6328' 12/04/2023 07:53:46 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MISERICORDIOSO MM 22 - METALLO OX', description = '' WHERE id_product = '6328' 12/04/2023 07:53:46 pm >> UPDATE ps_product SET wholesale_price = '0.22', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6328' 12/04/2023 07:53:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.22', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6328' 12/04/2023 07:53:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '6328' 12/04/2023 07:54:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-S.CU' AND id_product != '6356' AND ean13 != '' 12/04/2023 07:54:08 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2014', ean13 = 'G022-S.CU', date_upd = NOW() WHERE id_product = '6356' 12/04/2023 07:54:08 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S.CUORE- MAD. CARMINE', description = '' WHERE id_product = '6356' 12/04/2023 07:54:08 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6356' 12/04/2023 07:54:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6356' 12/04/2023 07:54:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '6356' 12/04/2023 07:54:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-PIO' AND id_product != '6355' AND ean13 != '' 12/04/2023 07:54:16 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = 'G022-PIO', date_upd = NOW() WHERE id_product = '6355' 12/04/2023 07:54:16 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. PIO MM 22 - METALLO OX ', description = '' WHERE id_product = '6355' 12/04/2023 07:54:16 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '6355' 12/04/2023 07:54:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '6355' 12/04/2023 07:54:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '6355' 12/04/2023 07:54:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-BOS' AND id_product != '16064' AND ean13 != '' 12/04/2023 07:54:27 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-BOS', date_upd = NOW() WHERE id_product = '16064' 12/04/2023 07:54:27 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. GIOVANNI BOSCO/AUX', description = '' WHERE id_product = '16064' 12/04/2023 07:54:27 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '16064' 12/04/2023 07:54:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '16064' 12/04/2023 07:54:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '16064' 12/04/2023 07:54:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-FRA' AND id_product != '16063' AND ean13 != '' 12/04/2023 07:54:35 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-FRA', date_upd = NOW() WHERE id_product = '16063' 12/04/2023 07:54:35 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. FRANCESCO-G022', description = '' WHERE id_product = '16063' 12/04/2023 07:54:35 pm >> UPDATE ps_product SET wholesale_price = '0.83', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '16063' 12/04/2023 07:54:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.83', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '16063' 12/04/2023 07:54:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '16063' 12/04/2023 07:54:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-CRI' AND id_product != '16062' AND ean13 != '' 12/04/2023 07:54:43 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-CRI', date_upd = NOW() WHERE id_product = '16062' 12/04/2023 07:54:43 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. CRISTOFORO - G022', description = '' WHERE id_product = '16062' 12/04/2023 07:54:43 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '16062' 12/04/2023 07:54:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '16062' 12/04/2023 07:54:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '16062' 12/04/2023 07:54:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-VOLTO' AND id_product != '16832' AND ean13 != '' 12/04/2023 07:55:00 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'G022-VOLTO', date_upd = NOW() WHERE id_product = '16832' 12/04/2023 07:55:00 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA VOLTO SANTO', description = '' WHERE id_product = '16832' 12/04/2023 07:55:00 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '16832' 12/04/2023 07:55:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '16832' 12/04/2023 07:55:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '16832' 12/04/2023 07:55:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002102' AND id_product != '20547' AND ean13 != '' 12/04/2023 07:55:21 pm >> UPDATE ps_product SET id_supplier = '154', reference = '', ean13 = '002102', date_upd = NOW() WHERE id_product = '20547' 12/04/2023 07:55:21 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA LOURDES - OV22/L', description = '' WHERE id_product = '20547' 12/04/2023 07:55:21 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '20547' 12/04/2023 07:55:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '485', 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 = '20547' 12/04/2023 07:55:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '20547' 12/04/2023 07:55:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001785' AND id_product != '18617' AND ean13 != '' 12/04/2023 07:55:28 pm >> UPDATE ps_product SET id_supplier = '154', reference = '', ean13 = '001785', date_upd = NOW() WHERE id_product = '18617' 12/04/2023 07:55:28 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA MIRACOLOSA - OV22/M', description = '' WHERE id_product = '18617' 12/04/2023 07:55:28 pm >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '18617' 12/04/2023 07:55:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '485', 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 = '18617' 12/04/2023 07:55:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '18617' 12/04/2023 07:55:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001786' AND id_product != '18618' AND ean13 != '' 12/04/2023 07:55:38 pm >> UPDATE ps_product SET id_supplier = '154', reference = '', ean13 = '001786', date_upd = NOW() WHERE id_product = '18618' 12/04/2023 07:55:38 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN MICHELE - OV22/MC', description = '' WHERE id_product = '18618' 12/04/2023 07:55:38 pm >> UPDATE ps_product SET wholesale_price = '0.07', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '18618' 12/04/2023 07:55:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.07', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '485', 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 = '18618' 12/04/2023 07:55:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '18618'