16/05/2024 08:44:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , ' FPR 27/24' , '2024-05-14' , '24' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '-.60' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '54.00' , '54.00' , NOW() , NOW() ) 16/05/2024 08:44:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91821' 16/05/2024 08:44:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91821' 16/05/2024 08:44:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91821' , '21055' , 'MIA PRIMA EUCARISTIA ' , '20' , '20' , '4' , '3.90' , '3.9' , '0' , '30' , '54.6000' ) 16/05/2024 08:44:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '21055' AND id_supplier = '174' 16/05/2024 08:44:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21055' , '174' , '1' ) 16/05/2024 08:47:44 am >> SELECT document_num FROM ps_document WHERE document_num = '88' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 08:47:44 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 ( '21' , '88' , '2024-05-16' , '' , '3455' , '0' , '4672079' , 'C. DA SANTA DOMENICA, SNC 84031 AULETTA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '53.16' , '53.16' , NOW() , NOW() ) 16/05/2024 08:47:44 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 = '91822' 16/05/2024 08:47:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91822' 16/05/2024 08:47:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91822' , '21055' , 'MIA PRIMA EUCARISTIA ' , '13' , '-13' , '4' , '3.90' , '3.9' , '0' , '5' , '48.16' ) 16/05/2024 09:03:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1372/24' , '2024-05-14' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '395.15' , '379.95' , NOW() , NOW() ) 16/05/2024 09:03:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91823' 16/05/2024 09:03:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91823' 16/05/2024 09:03: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 ( '91823' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '5' , '5' , '3' , '4' , '3.8461538461538' , '4' , '3' , '20.1760' ) 16/05/2024 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '18749' AND id_supplier = '22' 16/05/2024 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18749' , '22' , '1' ) 16/05/2024 09:03: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 ( '91823' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '5' , '5' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '10.5924' ) 16/05/2024 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '22' 16/05/2024 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '22' , '1' ) 16/05/2024 09:03: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 ( '91823' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '2' , '2' , '3' , '2.5' , '2.4038461538462' , '4' , '3' , '5.0440' ) 16/05/2024 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '22' 16/05/2024 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '22' , '1' ) 16/05/2024 09:03: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 ( '91823' , '7311' , 'OSTIA SOTTILE 74MM' , '100' , '100' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '111.9768' ) 16/05/2024 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 16/05/2024 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 16/05/2024 09:03: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 ( '91823' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '100' , '100' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '111.9768' ) 16/05/2024 09:03:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '20429' AND id_supplier = '22' 16/05/2024 09:03:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20429' , '22' , '1' ) 16/05/2024 09:03: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 ( '91823' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '61' , '61' , '3' , '2.2' , '2.1153846153846' , '4' , '3' , '135.3810' ) 16/05/2024 09:03:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '20433' AND id_supplier = '22' 16/05/2024 09:03:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20433' , '22' , '1' ) 16/05/2024 09:06:26 am >> DELETE FROM ps_document WHERE id_document = '91822' 16/05/2024 09:06:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91822' 16/05/2024 09:49:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 09:49:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1600' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.01' , '39.60' , NOW() , NOW() ) 16/05/2024 09:49:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91824' 16/05/2024 09:49:03 am >> DELETE FROM ps_document_detail WHERE id_document = '91824' 16/05/2024 09:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91824' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 16/05/2024 09:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91824' , '22428' , 'PRETE SI CONFESSA - A. PRONZATO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 16/05/2024 09:49:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91824' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 16/05/2024 09:50:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 09:50:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1601' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 16/05/2024 09:50:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91825' 16/05/2024 09:50:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91825' 16/05/2024 09:50:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91825' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 16/05/2024 10:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 10:20:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1602' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 16/05/2024 10:20:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91826' 16/05/2024 10:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91826' 16/05/2024 10:20:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91826' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '0.5' , '0.5' , '0' , '0' , '3.00' ) 16/05/2024 10:21:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 10:21:45 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' , '1603' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.00' , '80.08' , NOW() , NOW() ) 16/05/2024 10:21:45 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 = '91827' 16/05/2024 10:21:45 am >> DELETE FROM ps_document_detail WHERE id_document = '91827' 16/05/2024 10:21:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91827' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 16/05/2024 10:21:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91827' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 16/05/2024 10:21:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91827' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '28.00' ) 16/05/2024 10:21:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91827' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 16/05/2024 10:21:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91827' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 16/05/2024 10:39:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 10:39:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1604' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 16/05/2024 10:39:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91828' 16/05/2024 10:39:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91828' 16/05/2024 10:39:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91828' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2024 10:39:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91828' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2024 11:47:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 11:47:03 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' , '1605' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '565.00' , '467.40' , NOW() , NOW() ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91829' 16/05/2024 11:47:03 am >> DELETE FROM ps_document_detail WHERE id_document = '91829' 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '4.85' , '3.9754098360656' , '22' , '0' , '4.85' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '2' , '-2' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '130.00' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '14919' , 'CASULA - POLIESTERE - PCA022' , '2' , '-2' , '1' , '75' , '61.475409836066' , '22' , '0' , '150.00' ) 16/05/2024 11:47:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/05/2024 11:54:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 11:54: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' , '1606' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.00' , '135.25' , NOW() , NOW() ) 16/05/2024 11:54: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 = '91830' 16/05/2024 11:54:47 am >> DELETE FROM ps_document_detail WHERE id_document = '91830' 16/05/2024 11:54: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 ( '91830' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '165.00' , '135.24590163934' , '22' , '0' , '165.00' ) 16/05/2024 11:55:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 11:55:13 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' , '1607' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.40' , '68.40' , NOW() , NOW() ) 16/05/2024 11:55:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91831' 16/05/2024 11:55:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91831' 16/05/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91831' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 16/05/2024 11:55:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91831' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 16/05/2024 11:57:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 11:57: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' , '1608' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.23' , NOW() , NOW() ) 16/05/2024 11:57: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 = '91832' 16/05/2024 11:57:37 am >> DELETE FROM ps_document_detail WHERE id_document = '91832' 16/05/2024 11:57: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 ( '91832' , '17628' , 'PREGHIERE A SAN CHARBEL - 8946' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/05/2024 11:57: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 ( '91832' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/05/2024 11:59:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 11:59:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1609' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 16/05/2024 11:59:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91833' 16/05/2024 11:59:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91833' 16/05/2024 11:59:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91833' , '22081' , 'NE LUPI NE AGNELLI - A. CARRIERO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 16/05/2024 12:02:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 12:02: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' , '1610' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 16/05/2024 12:02: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 = '91834' 16/05/2024 12:02:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91834' 16/05/2024 12:02: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 ( '91834' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 16/05/2024 12:09:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 12:09:53 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' , '1611' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.80' , NOW() , NOW() ) 16/05/2024 12:09:53 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 = '91835' 16/05/2024 12:09:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '91835' 16/05/2024 12:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91835' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 16/05/2024 12:14:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 12:14:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1612' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.20' , '19.02' , NOW() , NOW() ) 16/05/2024 12:14:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91836' 16/05/2024 12:14:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '91836' 16/05/2024 12:14:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91836' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 16/05/2024 12:14:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91836' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 16/05/2024 12:24:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 12:24:08 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' , '1613' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '48.49' , NOW() , NOW() ) 16/05/2024 12:24:08 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 = '91837' 16/05/2024 12:24:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '91837' 16/05/2024 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91837' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 16/05/2024 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91837' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/05/2024 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91837' , '21598' , 'SEGNALIBRO PICCOLO SAN PAOLO - PZ 50' , '2' , '-2' , '1' , '9' , '7.3770491803279' , '22' , '0' , '18.00' ) 16/05/2024 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91837' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '13' , '-13' , '1' , '1' , '0.81967213114754' , '22' , '0' , '13.00' ) 16/05/2024 12:32:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 12:32:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1614' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '274.90' , '225.33' , NOW() , NOW() ) 16/05/2024 12:32: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 = '91838' 16/05/2024 12:32:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91838' 16/05/2024 12:32: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 ( '91838' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 16/05/2024 12:32: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 ( '91838' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '15' , '-15' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '7.50' ) 16/05/2024 12:32: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 ( '91838' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 16/05/2024 12:32: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 ( '91838' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/05/2024 12:32: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 ( '91838' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 16/05/2024 12:32: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 ( '91838' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/05/2024 12:36:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1155' AND id_document != '91276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-15') 16/05/2024 12:36:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1155', document_date = '2024-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91276' 16/05/2024 12:36:08 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 = '91276' 16/05/2024 12:36:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '91276' 16/05/2024 12:36:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91276' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 16/05/2024 12:36:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1152' AND id_document != '91269' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-15') 16/05/2024 12:36:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1152', document_date = '2024-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '231.20', price_tax_excluded = '196.46', date_upd = NOW() WHERE id_document = '91269' 16/05/2024 12:36: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 = '91269' 16/05/2024 12:36:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91269' 16/05/2024 12:36: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 ( '91269' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '21' , '-21' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '25.20' ) 16/05/2024 12:36: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 ( '91269' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 16/05/2024 12:36: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 ( '91269' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 16/05/2024 12:36: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 ( '91269' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 16/05/2024 12:36: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 ( '91269' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '15' , '-15' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '112.50' ) 16/05/2024 12:36: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 ( '91269' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 16/05/2024 12:36: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 ( '91269' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '1' , '-1' , '1' , '52.5' , '43.032786885246' , '22' , '0' , '52.50' ) 16/05/2024 03:10:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 03:10:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1615' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '162.02' , '142.59' , NOW() , NOW() ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91839' 16/05/2024 03:10:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91839' 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '5' , '5.32' ) 16/05/2024 03:10:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91839' , '22507' , 'SPES NON CONFUNDIT' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 16/05/2024 03:17:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 03:17:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1616' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 16/05/2024 03:17: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 = '91840' 16/05/2024 03:17:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91840' 16/05/2024 03:17: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 ( '91840' , '20072' , 'BRACCIALE - BC1759N' , '8' , '-8' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '16.00' ) 16/05/2024 03:17: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 ( '91840' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/05/2024 03:33:26 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7910' 16/05/2024 03:33:26 pm >> UPDATE ps_stock_available SET quantity = quantity + '-3531' WHERE id_product = '7910' 16/05/2024 03:42:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000144' AND id_product != '13078' AND ean13 != '' 16/05/2024 03:42:04 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '000144', date_upd = NOW() WHERE id_product = '13078' 16/05/2024 03:42:04 pm >> UPDATE ps_product_lang SET name = 'LEGGIO IN LEGNO - 043', description = '' WHERE id_product = '13078' 16/05/2024 03:42:04 pm >> UPDATE ps_product SET wholesale_price = '45.59', on_sale = '0', price = '102.45901639344262' WHERE id_product = '13078' 16/05/2024 03:42:04 pm >> UPDATE ps_product_shop SET wholesale_price = '45.59', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '194', 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 = '13078' 16/05/2024 03:42:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '13078' 16/05/2024 04:00:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/05/2024 04:00:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22533' , '1' , '' , 'nuovo-prodotto' ) 16/05/2024 04:00:15 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22533' , '1' , '1' , '2' , NOW() , NOW() ) 16/05/2024 04:00:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22533' , '0' , '1' , '0' , '0' ) 16/05/2024 04:00:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:00:57 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:00:57 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:00:57 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '270.4918032786885' WHERE id_product = '15047' 16/05/2024 04:00:57 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:00:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:02:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:02:18 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:02:18 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:02:18 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '270.4918032786885' WHERE id_product = '15047' 16/05/2024 04:02:18 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:02:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:05:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:05:54 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:05:54 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:05:54 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '270.4918032786885' WHERE id_product = '15047' 16/05/2024 04:05:54 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:05:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:07:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000193' AND id_product != '13071' AND ean13 != '' 16/05/2024 04:07:58 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '000193', date_upd = NOW() WHERE id_product = '13071' 16/05/2024 04:07:58 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 22X32', description = '' WHERE id_product = '13071' 16/05/2024 04:07:58 pm >> UPDATE ps_product SET wholesale_price = '68.41', on_sale = '0', price = '171.31147540983608' WHERE id_product = '13071' 16/05/2024 04:07:58 pm >> UPDATE ps_product_shop SET wholesale_price = '68.41', price = '171.31147540983608', id_tax_rules_group = '1', id_category_default = '194', 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 = '13071' 16/05/2024 04:07:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '13071' 16/05/2024 04:09:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000193' AND id_product != '13071' AND ean13 != '' 16/05/2024 04:09:48 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '000193', date_upd = NOW() WHERE id_product = '13071' 16/05/2024 04:09:48 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 22X32', description = '' WHERE id_product = '13071' 16/05/2024 04:09:48 pm >> UPDATE ps_product SET wholesale_price = '68.41', on_sale = '0', price = '171.31147540983608' WHERE id_product = '13071' 16/05/2024 04:09:48 pm >> UPDATE ps_product_shop SET wholesale_price = '68.41', price = '171.31147540983608', id_tax_rules_group = '1', id_category_default = '194', 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 = '13071' 16/05/2024 04:09:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '13071' 16/05/2024 04:13:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:13:32 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:13:32 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:13:32 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '258.1967213114754' WHERE id_product = '15047' 16/05/2024 04:13:32 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '258.1967213114754', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:13:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:14:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:14:00 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:14:00 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:14:00 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '261.4754098360656' WHERE id_product = '15047' 16/05/2024 04:14:00 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '261.4754098360656', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:14:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:14:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002274' AND id_product != '15047' AND ean13 != '' 16/05/2024 04:14:50 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002274', date_upd = NOW() WHERE id_product = '15047' 16/05/2024 04:14:50 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 32X44', description = '' WHERE id_product = '15047' 16/05/2024 04:14:50 pm >> UPDATE ps_product SET wholesale_price = '62.08', on_sale = '0', price = '261.4754' WHERE id_product = '15047' 16/05/2024 04:14:50 pm >> UPDATE ps_product_shop SET wholesale_price = '62.08', price = '261.4754', id_tax_rules_group = '1', id_category_default = '194', 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 = '15047' 16/05/2024 04:14:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '15047' 16/05/2024 04:19:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000411' AND id_product != '4911' AND ean13 != '' 16/05/2024 04:19:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000411', date_upd = NOW() WHERE id_product = '4911' 16/05/2024 04:19:27 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 18X22 - 2043', description = '' WHERE id_product = '4911' 16/05/2024 04:19:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '98.36065573770492' WHERE id_product = '4911' 16/05/2024 04:19:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '98.36065573770492', id_tax_rules_group = '1', id_category_default = '194', 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 = '4911' 16/05/2024 04:19:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '4911' 16/05/2024 04:31:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000409' AND id_product != '4909' AND ean13 != '' 16/05/2024 04:31:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000409', date_upd = NOW() WHERE id_product = '4909' 16/05/2024 04:31:12 pm >> UPDATE ps_product_lang SET name = 'DIPINTA A MANO 18X22', description = '' WHERE id_product = '4909' 16/05/2024 04:31:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '116.39344262295083' WHERE id_product = '4909' 16/05/2024 04:31:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '116.39344262295083', id_tax_rules_group = '1', id_category_default = '194', 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 = '4909' 16/05/2024 04:31:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '4909' 16/05/2024 04:32:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000409' AND id_product != '4909' AND ean13 != '' 16/05/2024 04:32:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000409', date_upd = NOW() WHERE id_product = '4909' 16/05/2024 04:32:05 pm >> UPDATE ps_product_lang SET name = 'DIPINTA A MANO 18X22', description = '' WHERE id_product = '4909' 16/05/2024 04:32:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '116.39344262295083' WHERE id_product = '4909' 16/05/2024 04:32:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '116.39344262295083', id_tax_rules_group = '1', id_category_default = '194', 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 = '4909' 16/05/2024 04:32:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '4909' 16/05/2024 04:33:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000410' AND id_product != '4910' AND ean13 != '' 16/05/2024 04:33:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000410', date_upd = NOW() WHERE id_product = '4910' 16/05/2024 04:33:12 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 18X22', description = '' WHERE id_product = '4910' 16/05/2024 04:33:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '90.16393442622952' WHERE id_product = '4910' 16/05/2024 04:33:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '90.16393442622952', id_tax_rules_group = '1', id_category_default = '194', 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 = '4910' 16/05/2024 04:33:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '4910' 16/05/2024 04:34:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000410' AND id_product != '4910' AND ean13 != '' 16/05/2024 04:34:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000410', date_upd = NOW() WHERE id_product = '4910' 16/05/2024 04:34:02 pm >> UPDATE ps_product_lang SET name = 'ICONA DIPINTA A MANO 18X22', description = '' WHERE id_product = '4910' 16/05/2024 04:34:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '96.72131147540983' WHERE id_product = '4910' 16/05/2024 04:34:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '96.72131147540983', id_tax_rules_group = '1', id_category_default = '194', 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 = '4910' 16/05/2024 04:34:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '4910' 16/05/2024 04:56:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '210' , '2024-05-15' , '' , '0' , '5' , '2600' , 'VIA DEL MANDORLO, 52 70022 ALTAMURA' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '648.40' , '531.47' , NOW() , NOW() ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91841' 16/05/2024 04:56:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91841' 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '3' , '47.3360' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13079' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13079' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '13078' , 'LEGGIO IN LEGNO - 043' , '2' , '2' , '1' , '50' , '40.983606557377' , '22' , '3' , '118.3400' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13078' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13078' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '15047' , 'ICONA DIPINTA 32X44' , '1' , '1' , '1' , '139.7' , '114.50819672131' , '22' , '3' , '165.3210' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15047' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15047' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '13071' , 'ICONA DIPINTA A MANO 22X32' , '1' , '1' , '1' , '90' , '73.770491803279' , '22' , '3' , '106.5060' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13071' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13071' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '4911' , 'ICONA DIPINTA A MANO 18X22 - 2043' , '1' , '1' , '1' , '51.3' , '42.049180327869' , '22' , '3' , '60.7084' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4911' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4911' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '4909' , 'DIPINTA A MANO 18X22' , '1' , '1' , '1' , '64.3' , '52.704918032787' , '22' , '3' , '76.0926' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4909' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4909' , '5' , '1' ) 16/05/2024 04:56:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91841' , '4910' , 'ICONA DIPINTA A MANO 18X22' , '1' , '1' , '1' , '52.3' , '42.868852459016' , '22' , '3' , '61.8918' ) 16/05/2024 04:56:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4910' AND id_supplier = '5' 16/05/2024 04:56:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4910' , '5' , '1' ) 16/05/2024 04:59:04 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '8182' 16/05/2024 04:59:04 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '8182' 16/05/2024 04:59:27 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16452' 16/05/2024 04:59:27 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16452' 16/05/2024 05:03:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 05:03:23 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' , '1617' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 16/05/2024 05:03:23 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 = '91842' 16/05/2024 05:03:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '91842' 16/05/2024 05:03:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91842' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 16/05/2024 05:03:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91842' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 16/05/2024 05:03:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91842' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/05/2024 05:05:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1618' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 05:05:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1618' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 16/05/2024 05:05:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91843' 16/05/2024 05:05:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91843' 16/05/2024 05:05:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91843' , '4887' , 'ICONA LEGNO 10X15 - 1222 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/05/2024 05:12:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 05:12: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' , '1619' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 16/05/2024 05:12: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 = '91844' 16/05/2024 05:12:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '91844' 16/05/2024 05:12:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91844' , '19049' , 'ROSARIO MARIA SCIOGLIE NODI - 05313 - 440' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 16/05/2024 05:49:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 05:49:50 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' , '1620' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.10' , '9.92' , NOW() , NOW() ) 16/05/2024 05:49:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91845' 16/05/2024 05:49:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91845' 16/05/2024 05:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91845' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 16/05/2024 05:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91845' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 16/05/2024 05:49:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91845' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 16/05/2024 05:56:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 05:56:46 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' , '1621' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 16/05/2024 05:56:46 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 = '91846' 16/05/2024 05:56:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91846' 16/05/2024 05:56:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2024 05:56:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2024 06:41:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 06:41: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' , '1622' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.80' , '36.37' , NOW() , NOW() ) 16/05/2024 06:41: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 = '91847' 16/05/2024 06:41:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91847' 16/05/2024 06:41: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 ( '91847' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '26' , '-26' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.00' ) 16/05/2024 06:41: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 ( '91847' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 16/05/2024 06:41: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 ( '91847' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '26' , '-26' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.00' ) 16/05/2024 06:41: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 ( '91847' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '13' , '-13' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '9.10' ) 16/05/2024 06:41: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 ( '91847' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '2.60' ) 16/05/2024 06:41: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 ( '91847' , '11376' , 'VIENI SPIRITO SANTO' , '13' , '-13' , '4' , '0.20' , '0.2' , '0' , '0' , '2.60' ) 16/05/2024 06:43:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 06:43:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1623' , '2024-05-16' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.20' , '51.55' , NOW() , NOW() ) 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91848' 16/05/2024 06:43:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91848' 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91848' , '19884' , 'COPPIA SPOSI H 12 CON CUORE LUM - 4249/822' , '1' , '-1' , '1' , '29.0000' , '23.7705' , '22' , '0' , '29.00' ) 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91848' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.0000' , '0.8197' , '22' , '0' , '2.00' ) 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91848' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9231' , '4' , '0' , '4.00' ) 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91848' , '15096' , 'CORONA MATRIMONIO - ARG ' , '2' , '-2' , '1' , '7.5000' , '6.1475' , '22' , '0' , '15.00' ) 16/05/2024 06:43:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91848' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 16/05/2024 06:45:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 06:45:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1624' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '5.98' , NOW() , NOW() ) 16/05/2024 06:45: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 = '91849' 16/05/2024 06:45:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91849' 16/05/2024 06:45: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 ( '91849' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '4.80' ) 16/05/2024 06:45: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 ( '91849' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 16/05/2024 06:50:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 06:50:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1625' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 16/05/2024 06:50:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91850' 16/05/2024 06:50:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '91850' 16/05/2024 06:50:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91850' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 16/05/2024 06:54:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 06: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' , '1626' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '16.50' , NOW() , NOW() ) 16/05/2024 06: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 = '91851' 16/05/2024 06:54:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91851' 16/05/2024 06: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 ( '91851' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.5' , '16.5' , '0' , '0' , '16.50' ) 16/05/2024 07:00:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 07:00:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1627' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 16/05/2024 07:00:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91852' 16/05/2024 07:00:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91852' 16/05/2024 07:00:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91852' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 16/05/2024 07:12:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 07:12:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1628' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '95.01' , NOW() , NOW() ) 16/05/2024 07:12:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91853' 16/05/2024 07:12:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91853' 16/05/2024 07:12:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '31.6' , '25.901639344262' , '22' , '0' , '31.60' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '3.30' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '15500' , 'CROCE IN LEGNO CON BASE - CL44' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '1' , '-1' , '1' , '6.70' , '5.4918032786885' , '22' , '0' , '6.70' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '1' , '-1' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '7.80' ) 16/05/2024 07:12:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91853' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 16/05/2024 07:18:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 07:18: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' , '1629' , '2024-05-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 16/05/2024 07:18: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 = '91854' 16/05/2024 07:18:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91854' 16/05/2024 07:18: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 ( '91854' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '20' , '-20' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '74.00' ) 16/05/2024 07:45:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '91799' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-05-14') 16/05/2024 07:45:05 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '14', document_date = '2024-05-14', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '976.00', price_tax_excluded = '976.00', date_upd = NOW() WHERE id_document = '91799' 16/05/2024 07:45: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 = '91799' 16/05/2024 07:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91799' 16/05/2024 07:45: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 ( '91799' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '7' , '-7' , '4' , '8.0000' , '8' , '0' , '0' , '56.00' ) 16/05/2024 07:45: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 ( '91799' , '20909' , 'SAN GIOVANNI BATTISTA E SAN FRANCESCO DI PAOLA' , '10' , '-10' , '4' , '8.0000' , '8' , '0' , '0' , '80.00' ) 16/05/2024 07:45: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 ( '91799' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '30' , '-30' , '4' , '8.0000' , '8' , '0' , '0' , '240.00' ) 16/05/2024 07:45: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 ( '91799' , '22152' , 'A TE RICORRIAMO' , '200' , '-200' , '4' , '3.0000' , '3' , '0' , '0' , '600.00' ) 16/05/2024 07:45:17 pm >> DELETE FROM ps_document WHERE id_document = '91266' 16/05/2024 07:45:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91266' 16/05/2024 07:47:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002236' AND id_product != '22240' AND ean13 != '' 16/05/2024 07:47:55 pm >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '002236', date_upd = NOW() WHERE id_product = '22240' 16/05/2024 07:47:55 pm >> UPDATE ps_product_lang SET name = 'PERGAMENA CRESIMA', description = '' WHERE id_product = '22240' 16/05/2024 07:47:55 pm >> UPDATE ps_product SET wholesale_price = '0.28', on_sale = '0', price = '0.5738' WHERE id_product = '22240' 16/05/2024 07:47:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.28', price = '0.5738', id_tax_rules_group = '1', id_category_default = '92', 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 = '22240' 16/05/2024 07:47:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '22240' 16/05/2024 07:48:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1622' AND id_document != '91847' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 16/05/2024 07:48:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1622', document_date = '2024-05-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '43.80', price_tax_excluded = '36.37', date_upd = NOW() WHERE id_document = '91847' 16/05/2024 07: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 = '91847' 16/05/2024 07:48:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91847' 16/05/2024 07: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 ( '91847' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 16/05/2024 07: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 ( '91847' , '22240' , 'PERGAMENA CRESIMA' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 16/05/2024 07: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 ( '91847' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 16/05/2024 07: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 ( '91847' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '13' , '-13' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '9.10' ) 16/05/2024 07: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 ( '91847' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.6000' , '2.1311475409836' , '22' , '0' , '2.60' ) 16/05/2024 07: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 ( '91847' , '11376' , 'VIENI SPIRITO SANTO' , '13' , '-13' , '4' , '0.2000' , '0.2' , '0' , '0' , '2.60' ) 16/05/2024 07:55:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '825' AND id_document != '90854' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 16/05/2024 07:55:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '825', document_date = '2024-03-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '90854' 16/05/2024 07:55:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90854' 16/05/2024 07:55:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90854' 16/05/2024 07:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90854' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.74' , '5.74' , '0' , '0' , '5.74' ) 16/05/2024 07:55:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90854' , '1128' , 'BIBBIA DELLA CRESIMA - RIL' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 16/05/2024 07:56:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '697' AND id_document != '90687' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-08') 16/05/2024 07:56:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '697', document_date = '2024-03-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '225.00', price_tax_excluded = '195.25', date_upd = NOW() WHERE id_document = '90687' 16/05/2024 07:56: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 = '90687' 16/05/2024 07:56:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90687' 16/05/2024 07:56: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 ( '90687' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.8' , '0.8' , '0' , '0' , '0.80' ) 16/05/2024 07:56: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 ( '90687' , '18021' , 'MENORA H 35' , '1' , '-1' , '1' , '112.5000' , '92.213114754098' , '22' , '0' , '112.50' ) 16/05/2024 07:56: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 ( '90687' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '7' , '-7' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '52.50' ) 16/05/2024 07:56: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 ( '90687' , '22386' , 'CREDO SPIEGATO AI CRISTIANI UN PO SCETTICI ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 16/05/2024 07:56: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 ( '90687' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/05/2024 07:56: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 ( '90687' , '22084' , 'DALLA CENERE LA VITA - P. SCQUIZZATO' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 16/05/2024 07:56: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 ( '90687' , '22427' , 'ALLASCOLTO DELLA PAROLA - M. DELBREL' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 16/05/2024 07:56: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 ( '90687' , '1128' , 'BIBBIA DELLA CRESIMA - RIL' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 16/05/2024 07:57:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '981' AND id_document != '91038' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-30') 16/05/2024 07:57:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '981', document_date = '2024-03-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '67.00', price_tax_excluded = '58.16', date_upd = NOW() WHERE id_document = '91038' 16/05/2024 07:57:12 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 = '91038' 16/05/2024 07:57:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91038' 16/05/2024 07:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91038' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 16/05/2024 07:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91038' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '0' , '6.00' ) 16/05/2024 07:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91038' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 16/05/2024 07:57:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91038' , '1128' , 'BIBBIA DELLA CRESIMA - RIL' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 16/05/2024 07:59:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '989' AND id_document != '91046' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 16/05/2024 07:59:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '989', document_date = '2024-04-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.40', price_tax_excluded = '52.62', date_upd = NOW() WHERE id_document = '91046' 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91046' 16/05/2024 07:59:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91046' 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.36' , '2.36' , '0' , '0' , '2.36' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '7927' , 'PERGAMENE - BATTESIMO MOD. C' , '22' , '-22' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '15.40' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '22430' , 'MADONNA DI FATIMA - W. WALSH' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '22322' , 'PAROLA E PREGHIERA - GIU 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 16/05/2024 07:59:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91046' , '1128' , 'BIBBIA DELLA CRESIMA - RIL' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' )