22/03/2024 08:32:30 am >> SELECT document_num FROM ps_document WHERE document_num = 'nc/103' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-21') 22/03/2024 08:32:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , 'nc/103' , '2024-03-21' , '103' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.78' , '49.00' , NOW() , NOW() ) 22/03/2024 08:32:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90886' 22/03/2024 08:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90886' 22/03/2024 08:32: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 ( '90886' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '1' , '1' , '59.78' , '49' , '22' , '0' , '59.78' ) 22/03/2024 08:32:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '22317' AND id_supplier = '187' 22/03/2024 08:32:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22317' , '187' , '1' ) 22/03/2024 08:32:49 am >> DELETE FROM ps_document WHERE id_document = '90886' 22/03/2024 08:32:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90886' 22/03/2024 08:33:34 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 ( '34' , 'NC/103' , '2024-03-21' , '103' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.78' , '49.00' , NOW() , NOW() ) 22/03/2024 08:33:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90887' 22/03/2024 08:33:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90887' 22/03/2024 08:33:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90887' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '59.7800' ) 22/03/2024 08:33:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22317' AND id_supplier = '187' 22/03/2024 08:33:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22317' , '187' , '1' ) 22/03/2024 08:40:47 am >> SELECT document_num FROM ps_document WHERE document_num = '841' AND id_document != '90872' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 22/03/2024 08:40:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '841', document_date = '2024-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '529.00', price_tax_excluded = '433.61', date_upd = NOW() WHERE id_document = '90872' 22/03/2024 08:40:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90872' 22/03/2024 08:40:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90872' 22/03/2024 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90872' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/03/2024 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90872' , '22317' , 'CASULA PERSONALIZZATA' , '7' , '-7' , '1' , '70' , '57.377049180328' , '22' , '0' , '490.00' ) 22/03/2024 08:40:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90872' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 22/03/2024 08:41:47 am >> SELECT document_num FROM ps_document WHERE document_num = '751' AND id_document != '90758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-14') 22/03/2024 08:41:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '751', document_date = '2024-03-14', 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 = '260.00', price_tax_excluded = '213.11', date_upd = NOW() WHERE id_document = '90758' 22/03/2024 08:41: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 = '90758' 22/03/2024 08:41:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90758' 22/03/2024 08:41: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 ( '90758' , '22317' , 'CASULA PERSONALIZZATA' , '3' , '-3' , '1' , '70' , '57.377049180328' , '22' , '0' , '210.00' ) 22/03/2024 08:41: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 ( '90758' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 22/03/2024 08:42:33 am >> SELECT document_num FROM ps_document WHERE document_num = '652' AND id_document != '90637' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 22/03/2024 08:42:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '652', document_date = '2024-03-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '494.00', price_tax_excluded = '408.82', date_upd = NOW() WHERE id_document = '90637' 22/03/2024 08:42:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90637' 22/03/2024 08:42:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90637' 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '100.00' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '52.00' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '69.8000' , '57.213114754098' , '22' , '0' , '69.80' ) 22/03/2024 08:42:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90637' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 22/03/2024 08:43:08 am >> SELECT document_num FROM ps_document WHERE document_num = '614' AND id_document != '90574' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-01') 22/03/2024 08:43:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '614', document_date = '2024-03-01', 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 = '110.34', price_tax_excluded = '96.82', date_upd = NOW() WHERE id_document = '90574' 22/03/2024 08:43:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90574' 22/03/2024 08:43:08 am >> DELETE FROM ps_document_detail WHERE id_document = '90574' 22/03/2024 08:43:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90574' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 22/03/2024 08:43:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90574' , '22203' , 'AMERAI IL SIGNORE TUO DIO - A. CENCINI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '5' , '24.70' ) 22/03/2024 08:43:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90574' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '4' , '-4' , '4' , '2.8000' , '2.8' , '0' , '5' , '10.64' ) 22/03/2024 08:47:54 am >> SELECT document_num FROM ps_document WHERE document_num = '793' AND id_document != '90807' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-18') 22/03/2024 08:47:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '793', document_date = '2024-03-18', 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 = '164.00', price_tax_excluded = '134.43', date_upd = NOW() WHERE id_document = '90807' 22/03/2024 08:47: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 = '90807' 22/03/2024 08:47:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90807' 22/03/2024 08:47: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 ( '90807' , '22317' , 'CASULA PERSONALIZZATA' , '2' , '-2' , '1' , '71' , '58.196721311475' , '22' , '0' , '142.00' ) 22/03/2024 08:47:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90807' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 22/03/2024 08:48:33 am >> SELECT document_num FROM ps_document WHERE document_num = '821' AND id_document != '90848' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-20') 22/03/2024 08:48:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '821', 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 = '154.00', price_tax_excluded = '126.23', date_upd = NOW() WHERE id_document = '90848' 22/03/2024 08:48:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90848' 22/03/2024 08:48:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90848' 22/03/2024 08:48:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90848' , '22317' , 'CASULA PERSONALIZZATA' , '2' , '-2' , '1' , '77' , '63.114754098361' , '22' , '0' , '154.00' ) 22/03/2024 08:49:07 am >> SELECT document_num FROM ps_document WHERE document_num = '383' AND id_document != '90264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-06') 22/03/2024 08:49:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '383', document_date = '2024-02-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '90264' 22/03/2024 08:49:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90264' 22/03/2024 08:49:07 am >> DELETE FROM ps_document_detail WHERE id_document = '90264' 22/03/2024 08:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90264' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 22/03/2024 08:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90264' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 22/03/2024 08:49:33 am >> SELECT document_num FROM ps_document WHERE document_num = '425' AND id_document != '90321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-10') 22/03/2024 08:49:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '425', document_date = '2024-02-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '90321' 22/03/2024 08:49:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90321' 22/03/2024 08:49:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90321' 22/03/2024 08:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90321' , '21153' , 'ROSARIO CRISTALLO COPPIGLIATO ARGEBN - 18600' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/03/2024 08:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90321' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 22/03/2024 08:49:50 am >> SELECT document_num FROM ps_document WHERE document_num = '465' AND id_document != '90376' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-16') 22/03/2024 08:49:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '465', document_date = '2024-02-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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '90376' 22/03/2024 08:49:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90376' 22/03/2024 08:49:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90376' 22/03/2024 08:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90376' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 22/03/2024 08:50:13 am >> SELECT document_num FROM ps_document WHERE document_num = '484' AND id_document != '90397' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 22/03/2024 08:50:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '484', document_date = '2024-02-17', 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 = '51.00', price_tax_excluded = '41.80', date_upd = NOW() WHERE id_document = '90397' 22/03/2024 08:50: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 = '90397' 22/03/2024 08:50:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90397' 22/03/2024 08:50: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 ( '90397' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22.5' , '18.44262295082' , '22' , '0' , '45.00' ) 22/03/2024 08:50: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 ( '90397' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 22/03/2024 08:52:29 am >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '90632' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 22/03/2024 08:52:29 am >> UPDATE ps_document SET id_document_type = '24', document_num = '32/A', document_date = '2024-03-05', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '3408.00', price_tax_excluded = '2849.70', date_upd = NOW() WHERE id_document = '90632' 22/03/2024 08:52: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 = '90632' 22/03/2024 08:52:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90632' 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19971' , 'CALICE - ART. 642' , '1' , '-1' , '1' , '536.0000' , '439.34426229508' , '22' , '0' , '536.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '310.0000' , '254.09836065574' , '22' , '0' , '310.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '355.0000' , '290.98360655738' , '22' , '0' , '355.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19660' , 'CASULA POLIESTERE - 65/11648' , '1' , '-1' , '1' , '440.0000' , '360.65573770492' , '22' , '0' , '440.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '-3' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '510.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '-1' , '1' , '360.0000' , '295.08196721311' , '22' , '0' , '360.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '22163' , 'CALICE CLASSICO - 155' , '1' , '-1' , '1' , '459.0000' , '376.22950819672' , '22' , '0' , '459.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '126.00' ) 22/03/2024 08:52:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90632' , '' , 'ROMANO' , '6' , '-6' , '0' , '52' , '52' , '' , '0' , '312.00' ) 22/03/2024 09:10:51 am >> SELECT document_num FROM ps_document WHERE document_num = '58' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:10:51 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' , '58' , '2024-03-22' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.06' , '88.06' , NOW() , NOW() ) 22/03/2024 09:10:51 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 = '90888' 22/03/2024 09:10:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90888' 22/03/2024 09:10:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90888' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '37' , '-37' , '4' , '2.80' , '2.8' , '0' , '15' , '88.06' ) 22/03/2024 09:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:11:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '853' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.20' , '5.20' , NOW() , NOW() ) 22/03/2024 09:11:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90889' 22/03/2024 09:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '90889' 22/03/2024 09:11:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90889' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.2' , '5.2' , '0' , '0' , '5.20' ) 22/03/2024 09:12:35 am >> DELETE FROM ps_document WHERE id_document = '90883' 22/03/2024 09:12:35 am >> DELETE FROM ps_document_detail WHERE id_document = '90883' 22/03/2024 09:12:50 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '90888' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:12:50 am >> UPDATE ps_document SET id_document_type = '21', document_num = '57', document_date = '2024-03-22', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '88.06', price_tax_excluded = '88.06', date_upd = NOW() WHERE id_document = '90888' 22/03/2024 09:12:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90888' 22/03/2024 09:12:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90888' 22/03/2024 09:12:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90888' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '37' , '-37' , '4' , '2.8000' , '2.8' , '0' , '15' , '88.06' ) 22/03/2024 09:13:54 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:13: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 ( '24' , '40/A' , '2024-03-22' , 'A' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 22/03/2024 09:13: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 = '90890' 22/03/2024 09:13:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90890' 22/03/2024 09:13: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 ( '90890' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 22/03/2024 09:20:22 am >> SELECT document_num FROM ps_document WHERE document_num = '854' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:20:22 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' , '854' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.80' , '60.49' , NOW() , NOW() ) 22/03/2024 09:20:22 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 = '90891' 22/03/2024 09:20:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90891' 22/03/2024 09:20:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90891' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/03/2024 09:20:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 22/03/2024 09:20:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 09:25:52 am >> SELECT document_num FROM ps_document WHERE document_num = '555' AND id_document != '90496' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 22/03/2024 09:25:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '555', document_date = '2024-02-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '68.00', price_tax_excluded = '55.74', date_upd = NOW() WHERE id_document = '90496' 22/03/2024 09:25:52 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 = '90496' 22/03/2024 09:25:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90496' 22/03/2024 09:25:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90496' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/03/2024 09:25:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90496' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 09:25:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90496' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '7.2' , '5.9016393442623' , '22' , '0' , '7.20' ) 22/03/2024 09:26:18 am >> SELECT document_num FROM ps_document WHERE document_num = '854' AND id_document != '90891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:26:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '854', document_date = '2024-03-22', 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 = '73.80', price_tax_excluded = '60.49', date_upd = NOW() WHERE id_document = '90891' 22/03/2024 09:26:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90891' 22/03/2024 09:26:18 am >> DELETE FROM ps_document_detail WHERE id_document = '90891' 22/03/2024 09:26:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90891' , '22317' , 'CASULA PERSONALIZZATA' , '1' , '-1' , '1' , '73.8' , '60.491803278689' , '22' , '0' , '73.80' ) 22/03/2024 09:28:10 am >> SELECT document_num FROM ps_document WHERE document_num = '56' AND id_document != '89835' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-05') 22/03/2024 09:28:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '56', document_date = '2024-01-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '275.10', price_tax_excluded = '228.05', date_upd = NOW() WHERE id_document = '89835' 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89835' 22/03/2024 09:28:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89835' 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89835' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89835' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89835' , '14133' , 'NATIVITA DI GESU BAMBINO - 281' , '2' , '-2' , '1' , '3.5500' , '2.9098360655738' , '22' , '0' , '7.10' ) 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89835' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/03/2024 09:28:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89835' , '15210' , 'CERO PASQUALE API 80X120' , '3' , '-3' , '1' , '80' , '65.573770491803' , '22' , '0' , '240.00' ) 22/03/2024 09:34:47 am >> SELECT document_num FROM ps_document WHERE document_num = '855' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:34: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' , '855' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.70' , '1.52' , NOW() , NOW() ) 22/03/2024 09:34: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 = '90892' 22/03/2024 09:34:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90892' 22/03/2024 09:34: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 ( '90892' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 22/03/2024 09:34: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 ( '90892' , '4856' , 'ICONA CRISTO - 84 ' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 22/03/2024 09:34: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 ( '90892' , '10145' , 'SPIRITO SANTO - 263 ' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 22/03/2024 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90892' , '17748' , 'SEGNALIBRO - PR 349' , '1' , '-1' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '0.35' ) 22/03/2024 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90892' , '17939' , 'SAN GIUSEPPE -SER. PREGHIERA 62' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 22/03/2024 09:43:15 am >> SELECT document_num FROM ps_document WHERE document_num = '856' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:43:15 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' , '856' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.50' , '132.05' , NOW() , NOW() ) 22/03/2024 09:43:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90893' 22/03/2024 09:43:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90893' 22/03/2024 09:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90893' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '25' , '-25' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '87.50' ) 22/03/2024 09:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90893' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 22/03/2024 09:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90893' , '6590' , 'MEZZO VETRO ROSSO RUBINO - VKINGS2' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 22/03/2024 09:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90893' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 22/03/2024 09:53:22 am >> SELECT document_num FROM ps_document WHERE document_num = '857' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:53:22 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' , '857' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.59' , NOW() , NOW() ) 22/03/2024 09:53:22 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 = '90894' 22/03/2024 09:53:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90894' 22/03/2024 09:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90894' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 22/03/2024 09:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90894' , '17731' , 'VANGELO E ATTI - CRESIMA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/03/2024 09:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90894' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 22/03/2024 09:56:15 am >> SELECT document_num FROM ps_document WHERE document_num = '858' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 09:56:15 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' , '858' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 22/03/2024 09:56:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90895' 22/03/2024 09:56:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90895' 22/03/2024 09:56:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90895' , '20778' , 'PASSIO N.E.' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 22/03/2024 10:06:16 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 10:06: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 ( '24' , '41/A' , '2024-03-22' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.70' , '129.01' , NOW() , NOW() ) 22/03/2024 10:06: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 = '90896' 22/03/2024 10:06:16 am >> DELETE FROM ps_document_detail WHERE id_document = '90896' 22/03/2024 10:06: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 ( '90896' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 10:06: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 ( '90896' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2024 10:06: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 ( '90896' , '' , 'GRANI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 22/03/2024 10:06: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 ( '90896' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 10:06: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 ( '90896' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 22/03/2024 10:06: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 ( '90896' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '40.00' ) 22/03/2024 10:16:50 am >> SELECT document_num FROM ps_document WHERE document_num = '859' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 10:16:50 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' , '859' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 22/03/2024 10:16:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90897' 22/03/2024 10:16:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90897' 22/03/2024 10:16:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90897' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 22/03/2024 10:17:59 am >> SELECT document_num FROM ps_document WHERE document_num = '860' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 10:17:59 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' , '860' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '188.00' , '154.55' , NOW() , NOW() ) 22/03/2024 10:17:59 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 = '90898' 22/03/2024 10:17:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90898' 22/03/2024 10:17:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 22/03/2024 10:18:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 10:18:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.2' , '3.0769230769231' , '4' , '0' , '3.20' ) 22/03/2024 10:18:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '17005' , 'BIGLIETTO AUGURALE medio' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '9.00' ) 22/03/2024 10:31:33 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '90896' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 10:31:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '41/A', document_date = '2024-03-22', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '271.70', price_tax_excluded = '223.27', date_upd = NOW() WHERE id_document = '90896' 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90896' 22/03/2024 10:31:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90896' 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '0' , 'GRANI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '40.00' ) 22/03/2024 10:31:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.00' , '94.262295081967' , '22' , '0' , '115.00' ) 22/03/2024 10:35:58 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '90896' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 10:35:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '41/A', document_date = '2024-03-22', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '316.70', price_tax_excluded = '260.16', date_upd = NOW() WHERE id_document = '90896' 22/03/2024 10:35:58 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 = '90896' 22/03/2024 10:35:58 am >> DELETE FROM ps_document_detail WHERE id_document = '90896' 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '0' , 'GRANI' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '40.00' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 22/03/2024 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90896' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 22/03/2024 10:50:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/03/2024 10:50:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22321' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:50:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22321' , '1' , '1' , '2' , NOW() , NOW() ) 22/03/2024 10:50:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22321' , '0' , '1' , '0' , '0' ) 22/03/2024 10:50:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871397' AND id_product != '22321' AND ean13 != '' 22/03/2024 10:50:58 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788892871397', date_upd = NOW() WHERE id_product = '22321' 22/03/2024 10:50:58 am >> UPDATE ps_product_lang SET name = 'PERDONO CHE GUARISCE - L. PASQUA', description = '' WHERE id_product = '22321' 22/03/2024 10:50:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22321' 22/03/2024 10:50:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22321' 22/03/2024 10:50:58 am >> DELETE FROM ps_specific_price WHERE id_product = '22321' 22/03/2024 10:50:59 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22321' 22/03/2024 10:50:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22322' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:50:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22322' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22321' 22/03/2024 10:50:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22322' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22321' 22/03/2024 10:51:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457308' AND id_product != '22322' AND ean13 != '' 22/03/2024 10:51:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457308', date_upd = NOW() WHERE id_product = '22322' 22/03/2024 10:51:39 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - GIU 2024', description = '' WHERE id_product = '22322' 22/03/2024 10:51:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '22322' 22/03/2024 10:51:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22322' 22/03/2024 10:51:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22322' 22/03/2024 10:51:40 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22322' 22/03/2024 10:51:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22323' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:51:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22323' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22322' 22/03/2024 10:51:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22323' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22322' 22/03/2024 10:52:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457421' AND id_product != '22323' AND ean13 != '' 22/03/2024 10:52:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457421', date_upd = NOW() WHERE id_product = '22323' 22/03/2024 10:52:00 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - GIU 2024', description = '' WHERE id_product = '22323' 22/03/2024 10:52:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22323' 22/03/2024 10:52:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22323' 22/03/2024 10:52:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22323' 22/03/2024 10:52:01 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22323' 22/03/2024 10:52:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22324' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:52:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22324' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22323' 22/03/2024 10:52:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22324' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22323' 22/03/2024 10:52:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248084' AND id_product != '22324' AND ean13 != '' 22/03/2024 10:52:53 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788884248084', date_upd = NOW() WHERE id_product = '22324' 22/03/2024 10:52:53 am >> UPDATE ps_product_lang SET name = 'ESODO A CARATTERI GRANDI', description = '' WHERE id_product = '22324' 22/03/2024 10:52:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '22324' 22/03/2024 10:52:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22324' 22/03/2024 10:52:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22324' 22/03/2024 10:52:54 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22324' 22/03/2024 10:52:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22325' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:52:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22325' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22324' 22/03/2024 10:52:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22325' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22324' 22/03/2024 10:54:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243644' AND id_product != '22325' AND ean13 != '' 22/03/2024 10:54:18 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788892243644', date_upd = NOW() WHERE id_product = '22325' 22/03/2024 10:54:18 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI SALMI - R. VIRGILI', description = '' WHERE id_product = '22325' 22/03/2024 10:54:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '22325' 22/03/2024 10:54:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22325' 22/03/2024 10:54:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22325' 22/03/2024 10:54:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22325' 22/03/2024 10:54:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22326' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:54:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22326' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22325' 22/03/2024 10:54:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22326' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22325' 22/03/2024 10:55:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259753588' AND id_product != '22326' AND ean13 != '' 22/03/2024 10:55:05 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9791259753588', date_upd = NOW() WHERE id_product = '22326' 22/03/2024 10:55:05 am >> UPDATE ps_product_lang SET name = 'AIUTAMI A SUPERARE IL LUTTO ', description = '' WHERE id_product = '22326' 22/03/2024 10:55:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22326' 22/03/2024 10:55:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22326' 22/03/2024 10:55:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22326' 22/03/2024 10:55:05 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22326' 22/03/2024 10:55:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22327' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:55:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22327' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22326' 22/03/2024 10:55:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22327' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22326' 22/03/2024 10:55:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259753014' AND id_product != '22327' AND ean13 != '' 22/03/2024 10:55:44 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791259753014', date_upd = NOW() WHERE id_product = '22327' 22/03/2024 10:55:44 am >> UPDATE ps_product_lang SET name = 'UN SANTO PER AMICO - G. SANTINI', description = '' WHERE id_product = '22327' 22/03/2024 10:55:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22327' 22/03/2024 10:55:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22327' 22/03/2024 10:55:44 am >> DELETE FROM ps_specific_price WHERE id_product = '22327' 22/03/2024 10:55:45 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22327' 22/03/2024 10:55:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22328' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:55:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22328' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22327' 22/03/2024 10:55:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22328' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22327' 22/03/2024 10:56:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934598' AND id_product != '22328' AND ean13 != '' 22/03/2024 10:56:30 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934598', date_upd = NOW() WHERE id_product = '22328' 22/03/2024 10:56:30 am >> UPDATE ps_product_lang SET name = 'INDISPONIBILITA\' - H. ROSA', description = '' WHERE id_product = '22328' 22/03/2024 10:56:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22328' 22/03/2024 10:56:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22328' 22/03/2024 10:56:30 am >> DELETE FROM ps_specific_price WHERE id_product = '22328' 22/03/2024 10:56:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22328' 22/03/2024 10:56:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22329' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:56:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22329' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22328' 22/03/2024 10:56:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22329' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22328' 22/03/2024 10:57:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929716' AND id_product != '22329' AND ean13 != '' 22/03/2024 10:57:11 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839929716', date_upd = NOW() WHERE id_product = '22329' 22/03/2024 10:57:11 am >> UPDATE ps_product_lang SET name = 'DOGMI - M. FEDOU', description = '' WHERE id_product = '22329' 22/03/2024 10:57:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22329' 22/03/2024 10:57:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22329' 22/03/2024 10:57:11 am >> DELETE FROM ps_specific_price WHERE id_product = '22329' 22/03/2024 10:57:11 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22329' 22/03/2024 10:57:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22330' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 10:57:11 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22330' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22329' 22/03/2024 10:57:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22330' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22329' 22/03/2024 10:57:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '659535' , '2024-03-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.31' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.27' , '82.27' , NOW() , NOW() ) 22/03/2024 10:57:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90899' 22/03/2024 10:57:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90899' 22/03/2024 10:57:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22321' , 'PERDONO CHE GUARISCE - L. PASQUA' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 22/03/2024 10:57:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22321' AND id_supplier = '7' 22/03/2024 10:57:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22321' , '7' , '1' ) 22/03/2024 10:57:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22322' , 'PAROLA E PREGHIERA - GIU 2024' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 22/03/2024 10:57:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22322' AND id_supplier = '7' 22/03/2024 10:57:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22322' , '7' , '1' ) 22/03/2024 10:57:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22323' , 'INSIEME NELLA MESSA - GIU 2024' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 22/03/2024 10:57:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22323' AND id_supplier = '7' 22/03/2024 10:57:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22323' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22324' , 'ESODO A CARATTERI GRANDI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22324' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22324' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22325' , 'PREGHIERA DEI SALMI - R. VIRGILI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22325' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22325' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22326' , 'AIUTAMI A SUPERARE IL LUTTO ' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22326' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22326' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22327' , 'UN SANTO PER AMICO - G. SANTINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22327' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22327' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22328' , 'INDISPONIBILITA - H. ROSA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22328' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22328' , '7' , '1' ) 22/03/2024 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90899' , '22329' , 'DOGMI - M. FEDOU' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/03/2024 10:57:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '22329' AND id_supplier = '7' 22/03/2024 10:57:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22329' , '7' , '1' ) 22/03/2024 11:19:04 am >> SELECT document_num FROM ps_document WHERE document_num = '861' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 11:19:04 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' , '861' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 22/03/2024 11:19:04 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 = '90900' 22/03/2024 11:19:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90900' 22/03/2024 11:19:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90900' , '21679' , 'LAUDATE DEUM - 8583' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '0' , '50.00' ) 22/03/2024 12:38:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 22/03/2024 12:38:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '312.30', price_tax_excluded = '263.41', date_upd = NOW() WHERE id_document = '89917' 22/03/2024 12:38:14 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 = '89917' 22/03/2024 12:38:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89917' 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , '08/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , '15/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:38:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '75.00' ) 22/03/2024 12:40:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 22/03/2024 12:40:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '390.00', price_tax_excluded = '327.10', date_upd = NOW() WHERE id_document = '89917' 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89917' 22/03/2024 12:40:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89917' 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , '08/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/03/2024 12:40:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , '15/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '75.00' ) 22/03/2024 12:40:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.7' , '6.3114754098361' , '22' , '0' , '7.70' ) 22/03/2024 12:41:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '862' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 12:41: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' , '862' , '2024-03-22' , '' , '0' , '0' , '0' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '327.10' , NOW() , NOW() ) 22/03/2024 12:41: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 = '90901' 22/03/2024 12:41:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '90901' 22/03/2024 12:41: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 ( '90901' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 22/03/2024 12:41: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 ( '90901' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 22/03/2024 12:41: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 ( '90901' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/03/2024 12:41: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 ( '90901' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2951' , '22' , '0' , '8.90' ) 22/03/2024 12:41: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 ( '90901' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1148' , '22' , '0' , '3.80' ) 22/03/2024 12:41: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 ( '90901' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 22/03/2024 12:41: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 ( '90901' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8361' , '22' , '0' , '12.00' ) 22/03/2024 12:41: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 ( '90901' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377' , '22' , '0' , '140.00' ) 22/03/2024 12:41: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 ( '90901' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.4098' , '22' , '0' , '13.00' ) 22/03/2024 12:41: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 ( '90901' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.4098' , '22' , '0' , '13.00' ) 22/03/2024 12:41: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 ( '90901' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.4098' , '22' , '0' , '13.00' ) 22/03/2024 12:41: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 ( '90901' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '25.0000' , '20.4918' , '22' , '0' , '75.00' ) 22/03/2024 12:41: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 ( '90901' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.7000' , '6.3115' , '22' , '0' , '7.70' ) 22/03/2024 12:44:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 12:44:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '5/L' , '2024-03-22' , 'L' , '202' , '0' , '4670823' , 'VIA BRIGNANO INFERIORE, 31 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '43.20' , '35.41' , NOW() , NOW() ) 22/03/2024 12:44:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90902' 22/03/2024 12:44:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90902' 22/03/2024 12:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90902' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' ) 22/03/2024 12:44:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90902' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '13.20' ) 22/03/2024 12:46:24 pm >> DELETE FROM ps_document WHERE id_document = '89917' 22/03/2024 12:46:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89917' 22/03/2024 12:50:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259853226' AND id_product != '22330' AND ean13 != '' 22/03/2024 12:50:54 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791259853226', date_upd = NOW() WHERE id_product = '22330' 22/03/2024 12:50:54 pm >> UPDATE ps_product_lang SET name = 'LIFE - LA MIA STORIA - PAPA FRANCESCO', description = '' WHERE id_product = '22330' 22/03/2024 12:50:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '22330' 22/03/2024 12:50:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '533', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22330' 22/03/2024 12:50:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '22330' 22/03/2024 12:51:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22330' 22/03/2024 12:51:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22331' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 12:51:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22331' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22330' 22/03/2024 12:51:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22331' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22330' 22/03/2024 12:52:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810821466' AND id_product != '22331' AND ean13 != '' 22/03/2024 12:52:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '10/1', ean13 = '9788810821466', date_upd = NOW() WHERE id_product = '22331' 22/03/2024 12:52:51 pm >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME - BOTTONE', description = '' WHERE id_product = '22331' 22/03/2024 12:52:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '35' WHERE id_product = '22331' 22/03/2024 12:52:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '35', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22331' 22/03/2024 12:52:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '22331' 22/03/2024 12:52:52 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22331' 22/03/2024 12:52:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22332' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 12:52:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22332' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22331' 22/03/2024 12:52:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22332' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22331' 22/03/2024 12:54:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810711125' AND id_product != '22332' AND ean13 != '' 22/03/2024 12:54:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788810711125', date_upd = NOW() WHERE id_product = '22332' 22/03/2024 12:54:07 pm >> UPDATE ps_product_lang SET name = 'VOLTO DI GESU\', SERVO CROCIFISSO - VIA CRUCIS - E. BIANCHI', description = '' WHERE id_product = '22332' 22/03/2024 12:54:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '22332' 22/03/2024 12:54:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22332' 22/03/2024 12:54:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22332' 22/03/2024 12:54:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22332' 22/03/2024 12:54:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22333' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 12:54:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22333' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22332' 22/03/2024 12:54:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22333' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22332' 22/03/2024 12:55:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810978726' AND id_product != '22333' AND ean13 != '' 22/03/2024 12:55:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788810978726', date_upd = NOW() WHERE id_product = '22333' 22/03/2024 12:55:12 pm >> UPDATE ps_product_lang SET name = 'NARRAZIONI DELLA PASSIONE DI GESU\' CRISTO - G. BETORI', description = '' WHERE id_product = '22333' 22/03/2024 12:55:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22333' 22/03/2024 12:55:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22333' 22/03/2024 12:55:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22333' 22/03/2024 12:55:13 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22333' 22/03/2024 12:55:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22334' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 12:55:13 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22334' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22333' 22/03/2024 12:55:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22334' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22333' 22/03/2024 12:56:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872242353' AND id_product != '22334' AND ean13 != '' 22/03/2024 12:56:59 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788872242353', date_upd = NOW() WHERE id_product = '22334' 22/03/2024 12:56:59 pm >> UPDATE ps_product_lang SET name = 'DIO LA SCIENZA DELLE PROVE', description = '' WHERE id_product = '22334' 22/03/2024 12:56:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '22334' 22/03/2024 12:56:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22334' 22/03/2024 12:56:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '22334' 22/03/2024 12:57:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872242353' AND id_product != '22334' AND ean13 != '' 22/03/2024 12:57:16 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788872242353', date_upd = NOW() WHERE id_product = '22334' 22/03/2024 12:57:16 pm >> UPDATE ps_product_lang SET name = 'DIO LA SCIENZA DELLE PROVE', description = '' WHERE id_product = '22334' 22/03/2024 12:57:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.9' WHERE id_product = '22334' 22/03/2024 12:57:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.9', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22334' 22/03/2024 12:57:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '22334' 22/03/2024 12:58:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788822775696' AND id_product != '22332' AND ean13 != '' 22/03/2024 12:58:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788822775696', date_upd = NOW() WHERE id_product = '22332' 22/03/2024 12:58:22 pm >> UPDATE ps_product_lang SET name = 'NULLA SARA\' PIU\' COME PRIMA - L. NOWLIN', description = '' WHERE id_product = '22332' 22/03/2024 12:58:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '22332' 22/03/2024 12:58:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '484', id_argoment_default = '49', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22332' 22/03/2024 12:58:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '22332' 22/03/2024 12:58:25 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22332' 22/03/2024 12:58:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22335' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 12:58:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22335' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22332' 22/03/2024 12:58:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22335' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22332' 22/03/2024 12:59:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791255840671' AND id_product != '22335' AND ean13 != '' 22/03/2024 12:59:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791255840671', date_upd = NOW() WHERE id_product = '22335' 22/03/2024 12:59:38 pm >> UPDATE ps_product_lang SET name = 'TUA LUCE SULLA MIA STRADA - D. GUILLAUME', description = '' WHERE id_product = '22335' 22/03/2024 12:59:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23' WHERE id_product = '22335' 22/03/2024 12:59:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23', id_tax_rules_group = '4', id_category_default = '297', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22335' 22/03/2024 12:59:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22335' 22/03/2024 01:00:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '80385' , '2024-03-21' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '233.30' , '233.30' , NOW() , NOW() ) 22/03/2024 01:00: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 = '90903' 22/03/2024 01:00:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90903' 22/03/2024 01:00: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 ( '90903' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '2' , '2' , '4' , '19.00' , '19' , '0' , '0' , '38.0000' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '1' , '4' , '35.00' , '35' , '0' , '0' , '35.00' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22331' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22331' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '0' , '24.90' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22334' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22334' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22333' , 'NARRAZIONI DELLA PASSIONE DI GESU CRISTO - G. BETORI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22333' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22333' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22332' , 'VOLTO DI GESU, SERVO CROCIFISSO - VIA CRUCIS - E. BIANCHI' , '5' , '5' , '4' , '3.90' , '3.9' , '0' , '0' , '19.5000' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22332' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22332' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22335' , 'TUA LUCE SULLA MIA STRADA - D. GUILLAUME' , '1' , '1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22335' AND id_supplier = '109' 22/03/2024 01:00:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22335' , '109' , '1' ) 22/03/2024 01:00: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 ( '90903' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 22/03/2024 01:00:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22332' AND id_supplier = '109' 22/03/2024 01:00:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22332' , '109' , '1' ) 22/03/2024 01:00:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90903' , '22186' , 'VANGELO DI MARCO - MASCILONGO' , '1' , '1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 22/03/2024 01:00:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22186' AND id_supplier = '109' 22/03/2024 01:00:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22186' , '109' , '1' ) 22/03/2024 02:12:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 22/03/2024 02:12:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.30', price_tax_excluded = '100.30', date_upd = NOW() WHERE id_document = '89846' 22/03/2024 02:12: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 = '89846' 22/03/2024 02:12:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 22/03/2024 02:12: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 22/03/2024 02:12: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 ( '89846' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 22/03/2024 02:12: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 ( '89846' , '10064' , 'SOLO L\'AMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 22/03/2024 02:12: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 ( '89846' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 22/03/2024 02:12: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 ( '89846' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 22/03/2024 02:12: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 ( '89846' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 22/03/2024 03:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '863' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 03:26: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' , '863' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1194.00' , '978.69' , NOW() , NOW() ) 22/03/2024 03:26: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 = '90904' 22/03/2024 03:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90904' 22/03/2024 03:26: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 ( '90904' , '22320' , 'CANDELABRO CM 40 - 621' , '6' , '-6' , '1' , '180' , '147.54098360656' , '22' , '0' , '1080.00' ) 22/03/2024 03:26: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 ( '90904' , '22319' , 'FINTA CANDELA CON CARTUCCIA 3,2 X40 - 1133 ' , '6' , '-6' , '1' , '19' , '15.573770491803' , '22' , '0' , '114.00' ) 22/03/2024 03:34:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '864' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 03:34: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' , '864' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.20' , '28.66' , NOW() , NOW() ) 22/03/2024 03:34: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 = '90905' 22/03/2024 03:34:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90905' 22/03/2024 03:34: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 ( '90905' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/03/2024 03:34: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 ( '90905' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/03/2024 03:34: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 ( '90905' , '2766' , 'CORONA PLASTICA FOSFORO - 0100F' , '9' , '-9' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '2.70' ) 22/03/2024 04:16:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '865' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 04:16:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '865' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 22/03/2024 04:16:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90906' 22/03/2024 04:16:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90906' 22/03/2024 04:16:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90906' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 22/03/2024 04:37:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '866' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 04:37: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' , '866' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '207.50' , '170.08' , NOW() , NOW() ) 22/03/2024 04:37: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 = '90907' 22/03/2024 04:37:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90907' 22/03/2024 04:37: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 ( '90907' , '22155' , 'CROCE MET. SMALTATA ARG. - CL271' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 22/03/2024 04:37: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 ( '90907' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 22/03/2024 04:37: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 ( '90907' , '3181' , 'CALAMITE CROCIFISSO 6X9' , '40' , '-40' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '196.00' ) 22/03/2024 05:57:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '867' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 05:57: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' , '867' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.90' , '143.36' , NOW() , NOW() ) 22/03/2024 05:57: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 = '90908' 22/03/2024 05:57:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90908' 22/03/2024 05:57: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 ( '90908' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 22/03/2024 05:57: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 ( '90908' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 22/03/2024 05:57: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 ( '90908' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 22/03/2024 06:00:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '868' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 06:00:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '868' , '2024-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.00' , '103.28' , NOW() , NOW() ) 22/03/2024 06:00: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 = '90909' 22/03/2024 06:00:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90909' 22/03/2024 06:00: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 ( '90909' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 22/03/2024 06:00: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 ( '90909' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '2' , '-2' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '16.00' ) 22/03/2024 07:01:00 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/03/2024 07:01:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22336' , '1' , '' , 'nuovo-prodotto' ) 22/03/2024 07:01:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22336' , '1' , '1' , '2' , NOW() , NOW() ) 22/03/2024 07:01:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22336' , '0' , '1' , '0' , '0' ) 22/03/2024 07:02:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PROF' AND id_product != '16249' AND ean13 != '' 22/03/2024 07:02:38 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = 'PROF', date_upd = NOW() WHERE id_product = '16249' 22/03/2024 07:02:38 pm >> UPDATE ps_product_lang SET name = 'PROFUMATORE', description = '' WHERE id_product = '16249' 22/03/2024 07:02:38 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '27.868852459016395' WHERE id_product = '16249' 22/03/2024 07:02:38 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '276', 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 = '16249' 22/03/2024 07:02:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '16249' 22/03/2024 07:05:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'RECA' AND id_product != '22336' AND ean13 != '' 22/03/2024 07:05:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'RECA', date_upd = NOW() WHERE id_product = '22336' 22/03/2024 07:05:33 pm >> UPDATE ps_product_lang SET name = 'CALAMITE ', description = '' WHERE id_product = '22336' 22/03/2024 07:05:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '22336' 22/03/2024 07:05:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '276', 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 = '22336' 22/03/2024 07:05:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '22336' 22/03/2024 07:30:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '182' , '2024-03-19' , '' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '8' , '1' , '-2' , '0' , '0' , '' , '3' , '0' , '248.88' , '204.00' , NOW() , NOW() ) 22/03/2024 07:30:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90910' 22/03/2024 07:30:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90910' 22/03/2024 07:30:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90910' , '16249' , 'PROFUMATORE' , '2' , '2' , '1' , '14' , '11.475409836066' , '22' , '0' , '34.1600' ) 22/03/2024 07:30:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16249' AND id_supplier = '50' 22/03/2024 07:30:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16249' , '50' , '1' ) 22/03/2024 07:30:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90910' , '3181' , 'CALAMITE CROCIFISSO 6X9' , '50' , '50' , '1' , '2' , '1.6393442622951' , '22' , '0' , '122.0000' ) 22/03/2024 07:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3181' AND id_supplier = '50' 22/03/2024 07:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3181' , '50' , '1' ) 22/03/2024 07:30:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90910' , '22336' , 'CALAMITE ' , '34' , '34' , '1' , '2' , '1.6393442622951' , '22' , '0' , '82.9600' ) 22/03/2024 07:30:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22336' AND id_supplier = '50' 22/03/2024 07:30:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22336' , '50' , '1' ) 22/03/2024 07:31:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '866' AND id_document != '90907' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 07:31:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '866', document_date = '2024-03-22', 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 = '207.50', price_tax_excluded = '170.08', date_upd = NOW() WHERE id_document = '90907' 22/03/2024 07:31: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 = '90907' 22/03/2024 07:31:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90907' 22/03/2024 07:31: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 ( '90907' , '22155' , 'CROCE MET. SMALTATA ARG. - CL271' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 22/03/2024 07:31: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 ( '90907' , '3069' , 'CROCE PENITENZA 10X13 - 1380' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 22/03/2024 07:31: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 ( '90907' , '3181' , 'CALAMITE CROCIFISSO 6X9' , '20' , '-20' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '98.00' ) 22/03/2024 07:31: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 ( '90907' , '22336' , 'CALAMITE ' , '20' , '-20' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '98.00' ) 22/03/2024 07:32:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '864' AND id_document != '90905' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 07:32:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '864', document_date = '2024-03-22', 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 = '30.20', price_tax_excluded = '28.66', date_upd = NOW() WHERE id_document = '90905' 22/03/2024 07:32:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90905' 22/03/2024 07:32:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90905' 22/03/2024 07:32:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90905' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/03/2024 07:32:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90905' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/03/2024 07:32:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90905' , '9123' , 'ROSARIO IN PLASTICA - AZZURRO' , '9' , '-9' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '2.70' ) 22/03/2024 07:32:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '862' AND id_document != '90901' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 22/03/2024 07:32:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '862', document_date = '2024-03-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '390.00', price_tax_excluded = '327.10', date_upd = NOW() WHERE id_document = '90901' 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90901' 22/03/2024 07:32:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90901' 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.2' , '6.2' , '0' , '0' , '6.20' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '75.00' ) 22/03/2024 07:32:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90901' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.7000' , '6.3114754098361' , '22' , '0' , '7.70' ) 22/03/2024 07:35:36 pm >> DELETE FROM ps_document WHERE id_document = '90688' 22/03/2024 07:35:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90688' 22/03/2024 07:36:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '89869' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-09') 22/03/2024 07:36:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2024-01-09', document_letter = 'A', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '287.20', price_tax_excluded = '281.79', date_upd = NOW() WHERE id_document = '89869' 22/03/2024 07:36:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89869' 22/03/2024 07:36:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '89869' 22/03/2024 07:36:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '15294' , 'BENEDIZIONI - RISURREZIONE B' , '200' , '-200' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '30.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '0' , 'IN VISIONE' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '7753' , 'PECCATO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '4500' , 'GESÙ SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '13129' , 'ESAME DI COSCIENZA SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '0' , '4.90' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '' , 'PORTATI A CASA' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 22/03/2024 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89869' , '15020' , 'PREGARE OGNI GIORNO' , '100' , '-100' , '4' , '1.00' , '1' , '0' , '0' , '100.00' )