18/02/2025 10:28:32 am >> SELECT document_num FROM ps_document WHERE document_num = '523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 10:28:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '523' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 18/02/2025 10:28:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95792' 18/02/2025 10:28:32 am >> DELETE FROM ps_document_detail WHERE id_document = '95792' 18/02/2025 10:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95792' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '4.70' ) 18/02/2025 10:28:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95792' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/02/2025 11:06:28 am >> SELECT document_num FROM ps_document WHERE document_num = '524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 11:06:28 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' , '524' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '309.00' , '264.98' , NOW() , NOW() ) 18/02/2025 11:06:28 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 = '95793' 18/02/2025 11:06:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95793' 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '48.33' , '39.614754098361' , '22' , '0' , '48.33' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '17863' , 'PENTECOSTE - CONGAR/RAHNER' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '22402' , 'REGNO DI DIO E UNA SFIDA - F. SHEEN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '11151' , 'LIBRI' , '7' , '-7' , '4' , '1.5' , '1.5' , '0' , '5' , '10.01' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '6629' , 'MIA PREGHIERA' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '5' , '8.60' ) 18/02/2025 11:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95793' , '17349' , 'CROCE TRILOBATA H21 - CL56' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 18/02/2025 11:06: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 ( '95793' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 18/02/2025 11:06: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 ( '95793' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/02/2025 11:09:15 am >> SELECT document_num FROM ps_document WHERE document_num = '525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 11:09: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' , '525' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 18/02/2025 11:09: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 = '95794' 18/02/2025 11:09:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95794' 18/02/2025 11:09: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 ( '95794' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 18/02/2025 11:18:45 am >> SELECT document_num FROM ps_document WHERE document_num = '526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 11:18:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '526' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.60' , '93.33' , NOW() , NOW() ) 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95795' 18/02/2025 11:18:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95795' 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95795' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95795' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '23.70' ) 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95795' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95795' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 18/02/2025 11:18:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95795' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 18/02/2025 12:00:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/02/2025 12:00:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23468' , '1' , '' , 'nuovo-prodotto' ) 18/02/2025 12:00:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23468' , '1' , '1' , '2' , NOW() , NOW() ) 18/02/2025 12:00:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23468' , '0' , '1' , '0' , '0' ) 18/02/2025 12:02:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '65/019945-M' AND id_product != '23468' AND ean13 != '' 18/02/2025 12:02:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '65/019945-M', date_upd = NOW() WHERE id_product = '23468' 18/02/2025 12:02:18 pm >> UPDATE ps_product_lang SET name = 'CASULA MARIANA LANA/RASO - 65/019945-M', description = '' WHERE id_product = '23468' 18/02/2025 12:02:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1307.377049180328' WHERE id_product = '23468' 18/02/2025 12:02:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1307.377049180328', id_tax_rules_group = '1', id_category_default = '468', 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 = '23468' 18/02/2025 12:02:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23468' 18/02/2025 12:02:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '54' , '2025-02-14' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 18/02/2025 12:02:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95796' 18/02/2025 12:02:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95796' 18/02/2025 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95796' , '19906' , 'FASCIA PER TALARE' , '3' , '3' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 18/02/2025 12:02:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19906' AND id_supplier = '143' 18/02/2025 12:02:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19906' , '143' , '1' ) 18/02/2025 12:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95796' , '23468' , 'CASULA MARIANA LANA/RASO - 65/019945-M' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 18/02/2025 12:02:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23468' AND id_supplier = '143' 18/02/2025 12:02:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23468' , '143' , '1' ) 18/02/2025 12:03:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 12:03:42 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' , '527' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 18/02/2025 12:03: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 = '95797' 18/02/2025 12:03:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95797' 18/02/2025 12:03: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 ( '95797' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 18/02/2025 12:58:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 18/02/2025 12:58:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '94912' 18/02/2025 12:58:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94912' 18/02/2025 12:58:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 18/02/2025 12:58:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '19906' , 'FASCIA PER TALARE' , '2' , '-2' , '1' , '100.00' , '81.967213114754' , '22' , '0' , '200.00' ) 18/02/2025 03:10:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 03:10:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '528' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.92' , NOW() , NOW() ) 18/02/2025 03:10:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95798' 18/02/2025 03:10:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '95798' 18/02/2025 03:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95798' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/02/2025 03:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95798' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 18/02/2025 03:33:58 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/02/2025 03:33:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23469' , '1' , '' , 'nuovo-prodotto' ) 18/02/2025 03:33:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23469' , '1' , '1' , '2' , NOW() , NOW() ) 18/02/2025 03:33:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23469' , '0' , '1' , '0' , '0' ) 18/02/2025 03:37:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618220' AND id_product != '23469' AND ean13 != '' 18/02/2025 03:37:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9791281618220', date_upd = NOW() WHERE id_product = '23469' 18/02/2025 03:37:05 pm >> UPDATE ps_product_lang SET name = 'suo amore e\' per sempre', description = '' WHERE id_product = '23469' 18/02/2025 03:37:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9' WHERE id_product = '23469' 18/02/2025 03:37:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23469' 18/02/2025 03:37:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '23469' 18/02/2025 03:37:07 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 = '23469' 18/02/2025 03:37:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23470' , '1' , '' , 'nuovo-prodotto' ) 18/02/2025 03:37:07 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 '23470' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23469' 18/02/2025 03:37:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23470' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23469' 18/02/2025 03:37:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618237' AND id_product != '23470' AND ean13 != '' 18/02/2025 03:37:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9791281618237', date_upd = NOW() WHERE id_product = '23470' 18/02/2025 03:37:51 pm >> UPDATE ps_product_lang SET name = 'suo amore e\' per sempre - spartito', description = '' WHERE id_product = '23470' 18/02/2025 03:37:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.538461538461538' WHERE id_product = '23470' 18/02/2025 03:37:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.538461538461538', id_tax_rules_group = '3', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23470' 18/02/2025 03:37:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '23470' 18/02/2025 03:38:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618220' AND id_product != '23469' AND ean13 != '' 18/02/2025 03:38:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9791281618220', date_upd = NOW() WHERE id_product = '23469' 18/02/2025 03:38:11 pm >> UPDATE ps_product_lang SET name = 'SUO AMORE E\' PER SEMPRE', description = '' WHERE id_product = '23469' 18/02/2025 03:38:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.9000' WHERE id_product = '23469' 18/02/2025 03:38:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.9000', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23469' 18/02/2025 03:38:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23469' 18/02/2025 03:38:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618237' AND id_product != '23470' AND ean13 != '' 18/02/2025 03:38:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9791281618237', date_upd = NOW() WHERE id_product = '23470' 18/02/2025 03:38:38 pm >> UPDATE ps_product_lang SET name = 'SUO AMORE E\' PER SEMPRE - SPARTITO', description = '' WHERE id_product = '23470' 18/02/2025 03:38:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.5385' WHERE id_product = '23470' 18/02/2025 03:38:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.5385', id_tax_rules_group = '3', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23470' 18/02/2025 03:38:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '23470' 18/02/2025 03:39:34 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 = '23470' 18/02/2025 03:39:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23471' , '1' , '' , 'nuovo-prodotto' ) 18/02/2025 03:39:34 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 '23471' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23470' 18/02/2025 03:39:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23471' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23470' 18/02/2025 03:41:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069464' AND id_product != '23471' AND ean13 != '' 18/02/2025 03:41:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788801069464', date_upd = NOW() WHERE id_product = '23471' 18/02/2025 03:41:47 pm >> UPDATE ps_product_lang SET name = 'NUOVO TESTAMENTO', description = '' WHERE id_product = '23471' 18/02/2025 03:41:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23471' 18/02/2025 03:41:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '19', 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 = '23471' 18/02/2025 03:41:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '23471' 18/02/2025 03:42:14 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' , '689938' , '2025-02-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '130.59' , '129.89' , NOW() , NOW() ) 18/02/2025 03:42: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 = '95799' 18/02/2025 03:42:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95799' 18/02/2025 03:42: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 ( '95799' , '6962' , 'NELLA CASA DEL DEFUNTO' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '33' , '12.0600' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '3930' , 'ESPERTI IN UMANITÀ - T. LORENZIN' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3930' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3930' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '15137' , 'TESTIMONIANZA DEL DISCEPOLO - C. DOGLIO' , '2' , '2' , '4' , '22.00' , '22' , '0' , '35' , '28.6000' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15137' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15137' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '21906' , 'AMORIS LAETITIA' , '3' , '3' , '4' , '2.70' , '2.7' , '0' , '33' , '5.4270' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21906' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21906' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '18710' , 'SERVIRE A MESSA ' , '1' , '1' , '4' , '6.00' , '6' , '0' , '33' , '4.0200' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18710' AND id_supplier = '7' 18/02/2025 03:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18710' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '23353' , 'VANGELO A CARETTERI GRANDI' , '1' , '1' , '4' , '7.00' , '7' , '0' , '30' , '4.9000' ) 18/02/2025 03:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23353' AND id_supplier = '7' 18/02/2025 03:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23353' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 18/02/2025 03:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20804' AND id_supplier = '7' 18/02/2025 03:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20804' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '23469' , 'SUO AMORE E PER SEMPRE' , '2' , '2' , '4' , '15.90' , '15.9' , '0' , '27' , '23.2140' ) 18/02/2025 03:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23469' AND id_supplier = '7' 18/02/2025 03:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23469' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '23470' , 'SUO AMORE E PER SEMPRE - SPARTITO' , '2' , '2' , '3' , '12.00' , '11.538461538462' , '4' , '27' , '18.2208' ) 18/02/2025 03:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23470' AND id_supplier = '7' 18/02/2025 03:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23470' , '7' , '1' ) 18/02/2025 03:42: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 ( '95799' , '23471' , 'NUOVO TESTAMENTO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 18/02/2025 03:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23471' AND id_supplier = '7' 18/02/2025 03:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23471' , '7' , '1' ) 18/02/2025 04:02:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 04:02:10 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' , '529' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 18/02/2025 04:02:10 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 = '95800' 18/02/2025 04:02:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95800' 18/02/2025 04:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95800' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 18/02/2025 04:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95800' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 18/02/2025 04:15:22 pm >> DELETE FROM ps_product WHERE id_product = '11167' 18/02/2025 04:15:22 pm >> DELETE FROM ps_product_shop WHERE id_product = '11167' 18/02/2025 04:15:23 pm >> DELETE FROM ps_product_lang WHERE id_product = '11167' 18/02/2025 04:15:23 pm >> DELETE FROM ps_stock_available WHERE id_product = '11167' 18/02/2025 04:59:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 04:59:54 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' , '530' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '528.00' , '432.79' , NOW() , NOW() ) 18/02/2025 04:59:54 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 = '95801' 18/02/2025 04:59:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '95801' 18/02/2025 04:59:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95801' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '528' , '432.7868852459' , '22' , '0' , '528.00' ) 18/02/2025 05:17:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:17:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '531' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '203.93' , '173.93' , NOW() , NOW() ) 18/02/2025 05:17:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95802' 18/02/2025 05:17:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '95802' 18/02/2025 05:17: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 ( '95802' , '23411' , 'CARLO ACUTIS SULLE ORME DI FRANCESCO - D. SORRENTINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/02/2025 05:17: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 ( '95802' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 18/02/2025 05:17: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 ( '95802' , '23359' , 'SUSSIDIO DI QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 18/02/2025 05:17: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 ( '95802' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 18/02/2025 05:17: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 ( '95802' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 18/02/2025 05:17: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 ( '95802' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 18/02/2025 05:17: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 ( '95802' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 18/02/2025 05:17: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 ( '95802' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/02/2025 05:17:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95802' , '22298' , 'RELIQUIARIO DORATO CON PIETRE CM 23' , '1' , '-1' , '1' , '145.00' , '118.85245901639' , '22' , '0' , '145.00' ) 18/02/2025 05:17:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95802' , '16637' , 'LUCE DEL MONDO - SPARTITO' , '1' , '-1' , '3' , '13.5' , '12.980769230769' , '4' , '5' , '12.83' ) 18/02/2025 05:18:10 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'p0yYok5XLO54OxGw' , NOW() , NOW() ) 18/02/2025 05:18:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4164' , '1' ) 18/02/2025 05:18:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4164' , '2' ) 18/02/2025 05:18:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4164' , '3' ) 18/02/2025 05:20:30 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4164' 18/02/2025 05:20:30 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4164' , '10' , '130' , 'PARROCCHIA S. MARIA DEL CARMINE' , 'SCIARAFFA' , 'DON CRISTIAN' , 'VIA CONCEZIONE MONTE ' , '' , '83036' , 'MIRABELLA ECLANO' , '' , '' , '' , '' , '90002070648' , NOW() , NOW() ) 18/02/2025 05:20:30 pm >> UPDATE ps_customer SET email = 'chiesasantamariadelcarmine@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4164' 18/02/2025 05:20:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:20:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '33' , '2025-02-18' , '' , '4164' , '0' , '4679465' , 'VIA CONCEZIONE MONTE 83036 MIRABELLA ECLANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '54.40' , '54.40' , NOW() , NOW() ) 18/02/2025 05:20:58 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 = '95803' 18/02/2025 05:20:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95803' 18/02/2025 05:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95803' , '15019' , 'PREGHIAMO CON MARIA' , '80' , '-80' , '4' , '0.80' , '0.8' , '0' , '15' , '54.40' ) 18/02/2025 05:24:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:24:44 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' , '532' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '118.69' , NOW() , NOW() ) 18/02/2025 05:24:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95804' 18/02/2025 05:24:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '95804' 18/02/2025 05:24:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '18' , '18' , '0' , '0' , '90.00' ) 18/02/2025 05:24:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95804' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 18/02/2025 05:26:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '95803' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:26:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '33', document_date = '2025-02-18', document_letter = '', id_customer = '4164', id_supplier = '', id_address = '4679465', address1 = 'VIA CONCEZIONE MONTE 83036 MIRABELLA ECLANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '54.40', price_tax_excluded = '54.40', date_upd = NOW() WHERE id_document = '95803' 18/02/2025 05:26:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95803' 18/02/2025 05:26:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '95803' 18/02/2025 05:26:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95803' , '15019' , 'PREGHIAMO CON MARIA' , '80' , '-80' , '4' , '0.8000' , '0.8' , '0' , '15' , '54.40' ) 18/02/2025 05:33:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '530' AND id_document != '95801' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:33:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '530', document_date = '2025-02-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 = '528.00', price_tax_excluded = '432.79', date_upd = NOW() WHERE id_document = '95801' 18/02/2025 05:33: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 = '95801' 18/02/2025 05:33:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '95801' 18/02/2025 05:33: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 ( '95801' , '23391' , 'DALMATICA - 86/D16212' , '2' , '-2' , '1' , '264' , '216.39344262295' , '22' , '0' , '528.00' ) 18/02/2025 05:33:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '483' AND id_document != '95741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-14') 18/02/2025 05:33:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '483', document_date = '2025-02-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 = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '95741' 18/02/2025 05:33:57 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 = '95741' 18/02/2025 05:33:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95741' 18/02/2025 05:33:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95741' , '23408' , 'STOLA DIACONALE - 60/3088 D' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 18/02/2025 05:44:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 05:44:10 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' , '533' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.70' , '40.77' , NOW() , NOW() ) 18/02/2025 05:44:10 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 = '95805' 18/02/2025 05:44:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95805' 18/02/2025 05:44:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95805' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 18/02/2025 05:44:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95805' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.7' , '4.7' , '0' , '0' , '4.70' ) 18/02/2025 05:44:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95805' , '21082' , 'BRACCIALE ARG. ESAGONALE - 1941CAV' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 18/02/2025 06:21:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-18') 18/02/2025 06:21:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '534' , '2025-02-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '10.90' , NOW() , NOW() ) 18/02/2025 06:21:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95806' 18/02/2025 06:21:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '95806' 18/02/2025 06:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95806' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 18/02/2025 06:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95806' , '18130' , 'TAU GRANDE CM 4 - T9' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 18/02/2025 06:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95806' , '22532' , 'SPILLA COLOMBA - G023' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 18/02/2025 07:05:59 pm >> DELETE FROM ps_product WHERE id_product = '7862' 18/02/2025 07:06:00 pm >> DELETE FROM ps_product_shop WHERE id_product = '7862' 18/02/2025 07:06:00 pm >> DELETE FROM ps_product_lang WHERE id_product = '7862' 18/02/2025 07:06:00 pm >> DELETE FROM ps_stock_available WHERE id_product = '7862' 18/02/2025 07:08:23 pm >> DELETE FROM ps_product WHERE id_product = '9943' 18/02/2025 07:08:23 pm >> DELETE FROM ps_product_shop WHERE id_product = '9943' 18/02/2025 07:08:23 pm >> DELETE FROM ps_product_lang WHERE id_product = '9943' 18/02/2025 07:08:23 pm >> DELETE FROM ps_stock_available WHERE id_product = '9943' 18/02/2025 07:08:54 pm >> DELETE FROM ps_product WHERE id_product = '10473' 18/02/2025 07:08:54 pm >> DELETE FROM ps_product_shop WHERE id_product = '10473' 18/02/2025 07:08:54 pm >> DELETE FROM ps_product_lang WHERE id_product = '10473' 18/02/2025 07:08:54 pm >> DELETE FROM ps_stock_available WHERE id_product = '10473'