19/02/2025 09:19:42 am >> SELECT document_num FROM ps_document WHERE document_num = '535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 09:19:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '535' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '22.40' , NOW() , NOW() ) 19/02/2025 09:19: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 = '95807' 19/02/2025 09:19:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95807' 19/02/2025 09:19: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 ( '95807' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.04' , '0.04' , '0' , '0' , '22.40' ) 19/02/2025 09:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 09:41:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '536' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '267.90' , '227.80' , NOW() , NOW() ) 19/02/2025 09:41: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 = '95808' 19/02/2025 09:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '95808' 19/02/2025 09:41: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 ( '95808' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 19/02/2025 09:41: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 ( '95808' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 19/02/2025 09:41: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 ( '95808' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 19/02/2025 09:41: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 ( '95808' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '3' , '-3' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '210.00' ) 19/02/2025 09:45:10 am >> SELECT document_num FROM ps_document WHERE document_num = '537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 09:45: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' , '537' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '184.43' , NOW() , NOW() ) 19/02/2025 09:45: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 = '95809' 19/02/2025 09:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '95809' 19/02/2025 09:45: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 ( '95809' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 19/02/2025 09:45: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 ( '95809' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '90' , '73.770491803279' , '22' , '0' , '180.00' ) 19/02/2025 10:12:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 10:12:57 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' , '4' , '2025-02-19' , '' , '7103' , '0' , '177359036' , 'VIA GIOVANNI PASCOLI 20 84014 CASTEL BOLOGNESE' , '' , '' , '6.87' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 19/02/2025 10:12:57 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 = '14789' 19/02/2025 10:12:57 am >> DELETE FROM ps_document_detail WHERE id_document = '14789' 19/02/2025 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14789' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '5' , '7.13' ) 19/02/2025 10:20:02 am >> SELECT document_num FROM ps_document WHERE document_num = '538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 10:20:02 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' , '538' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '6.39' , NOW() , NOW() ) 19/02/2025 10:20:02 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 = '95810' 19/02/2025 10:20:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95810' 19/02/2025 10:20:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95810' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '4.80' ) 19/02/2025 10:20:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95810' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 19/02/2025 10:25:11 am >> SELECT document_num FROM ps_document WHERE document_num = '539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 10:25:11 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' , '539' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.10' , '18.29' , NOW() , NOW() ) 19/02/2025 10:25:11 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 = '95811' 19/02/2025 10:25:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95811' 19/02/2025 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95811' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 19/02/2025 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95811' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/02/2025 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95811' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/02/2025 10:28:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7103' 19/02/2025 10:28:35 am >> 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 ( '7103' , '10' , '203' , '' , 'BALDRATI ' , 'ANGELA' , 'VIA GIOVANNI PASCOLI 20' , '' , '48014' , 'CASTEL BOLOGNESE' , 'campanello Giuseppe Baldrati' , '' , '3495867117' , '' , '' , NOW() , NOW() ) 19/02/2025 10:28:35 am >> UPDATE ps_customer SET email = 'angybaldrati.ab@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7103' 19/02/2025 10:34:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7103' 19/02/2025 10:34:35 am >> 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 ( '7103' , '10' , '203' , '' , 'BALDRATI ' , 'ANGELA' , 'VIA GIOVANNI PASCOLI 20' , '' , '48014' , 'CASTEL BOLOGNESE' , 'campanello Giuseppe Baldrati' , '' , '3495867117' , '' , '' , NOW() , NOW() ) 19/02/2025 10:34:35 am >> UPDATE ps_customer SET email = 'angybaldrati.ab@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7103' 19/02/2025 10:52:11 am >> SELECT document_num FROM ps_document WHERE document_num = '540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 10:52:11 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' , '540' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.04' , '148.34' , NOW() , NOW() ) 19/02/2025 10:52:11 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 = '95812' 19/02/2025 10:52:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95812' 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '5' , '20.92' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '5' , '20.92' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '4443' , 'GESÙ ENTRÒ PER RIMANERE CON LORO - A. FONTANA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '5' , '18.10' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 19/02/2025 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95812' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 19/02/2025 11:25:17 am >> SELECT document_num FROM ps_document WHERE document_num = '541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 11:25:17 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' , '541' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '282.69' , NOW() , NOW() ) 19/02/2025 11:25:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95813' 19/02/2025 11:25:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95813' 19/02/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95813' , '12238' , 'NAVETTA CLASSICA H13 CM - 12-460' , '1' , '-1' , '1' , '47.89' , '39.254098360656' , '22' , '0' , '47.89' ) 19/02/2025 11:25:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95813' , '12237' , 'TURIBOLO H28 CM' , '1' , '-1' , '1' , '180.00' , '147.54098360656' , '22' , '0' , '180.00' ) 19/02/2025 11:25: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 ( '95813' , '17141' , 'RICAMBIO VETRO - 34/V' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 19/02/2025 11:25: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 ( '95813' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 19/02/2025 11:25: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 ( '95813' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '9' , '-9' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '9.90' ) 19/02/2025 11:25: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 ( '95813' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 19/02/2025 11:25: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 ( '95813' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 19/02/2025 11:25: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 ( '95813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 19/02/2025 11:25: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 ( '95813' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/02/2025 11:28:11 am >> SELECT document_num FROM ps_document WHERE document_num = '542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 11:28:11 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' , '542' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '5.77' , NOW() , NOW() ) 19/02/2025 11:28:11 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 = '95814' 19/02/2025 11:28:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95814' 19/02/2025 11:28:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95814' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 19/02/2025 11:49:30 am >> SELECT document_num FROM ps_document WHERE document_num = '543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 11:49:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '543' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 19/02/2025 11:49: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 = '95815' 19/02/2025 11:49:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95815' 19/02/2025 11:49: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 ( '95815' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '16' , '-16' , '4' , '5.00' , '5' , '0' , '5' , '76.00' ) 19/02/2025 12:37:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 12:37:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '544' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.87' , '84.87' , NOW() , NOW() ) 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95816' 19/02/2025 12:37:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '95816' 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95816' , '21906' , 'AMORIS LAETITIA' , '11' , '-11' , '4' , '2.70' , '2.7' , '0' , '5' , '28.27' ) 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95816' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95816' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95816' , '23438' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 19/02/2025 12:37:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95816' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15' , '-15' , '4' , '2.38' , '2.38' , '0' , '0' , '35.70' ) 19/02/2025 12:39:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '95699' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-10') 19/02/2025 12:39:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2025-02-10', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'p. giuseppe castronuovo - baronissi - acconto € 110', 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 = '220.38', price_tax_excluded = '184.06', date_upd = NOW() WHERE id_document = '95699' 19/02/2025 12:39: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 = '95699' 19/02/2025 12:39:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95699' 19/02/2025 12:39: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 ( '95699' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 19/02/2025 12:39: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 ( '95699' , '17748' , 'SEGNALIBRO - PR 349' , '4' , '-4' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '1.40' ) 19/02/2025 12:39: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 ( '95699' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 19/02/2025 12:39: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 ( '95699' , '22366' , 'SAN GIUSEPPE CM 60 - 08.423' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 19/02/2025 12:39: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 ( '95699' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/02/2025 12:39:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '4.05' , '4.05' , '0' , '0' , '4.05' ) 19/02/2025 12:44:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 12:44: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 ( '11' , '545' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/02/2025 12:44: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 = '95817' 19/02/2025 12:44:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95817' 19/02/2025 12:44: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 ( '95817' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/02/2025 12:50:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/02/2025 12:50:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23472' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:50:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23472' , '1' , '1' , '2' , NOW() , NOW() ) 19/02/2025 12:50:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23472' , '0' , '1' , '0' , '0' ) 19/02/2025 12:51:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002345' AND id_product != '23472' AND ean13 != '' 19/02/2025 12:51:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002345', date_upd = NOW() WHERE id_product = '23472' 19/02/2025 12:51:28 pm >> UPDATE ps_product_lang SET name = 'CALENDARIO DI QUARESIMA BEATI VOI', description = '' WHERE id_product = '23472' 19/02/2025 12:51:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3' WHERE id_product = '23472' 19/02/2025 12:51:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3', id_tax_rules_group = '4', id_category_default = '517', 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 = '23472' 19/02/2025 12:51:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '23472' 19/02/2025 12:52:42 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 = '23472' 19/02/2025 12:52:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23473' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:52:42 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 '23473' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23472' 19/02/2025 12:52:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23473' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23472' 19/02/2025 12:53:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505216' AND id_product != '23473' AND ean13 != '' 19/02/2025 12:53:20 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9791281505216', date_upd = NOW() WHERE id_product = '23473' 19/02/2025 12:53:20 pm >> UPDATE ps_product_lang SET name = 'RACCONTAMI DI CARLO - C. GALATOLO', description = '' WHERE id_product = '23473' 19/02/2025 12:53:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '23473' 19/02/2025 12:53:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '517', 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 = '23473' 19/02/2025 12:53:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23473' 19/02/2025 12:53:21 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 = '23473' 19/02/2025 12:53:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23474' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:53:21 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 '23474' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23473' 19/02/2025 12:53:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23474' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23473' 19/02/2025 12:54:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505308' AND id_product != '23474' AND ean13 != '' 19/02/2025 12:54:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281505308', date_upd = NOW() WHERE id_product = '23474' 19/02/2025 12:54:07 pm >> UPDATE ps_product_lang SET name = 'QUARESIMA PASQUA IN FAMIGLIA', description = '' WHERE id_product = '23474' 19/02/2025 12:54:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.3' WHERE id_product = '23474' 19/02/2025 12:54:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.3', id_tax_rules_group = '4', id_category_default = '517', 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 = '23474' 19/02/2025 12:54:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23474' 19/02/2025 12:54:08 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 = '23474' 19/02/2025 12:54:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23475' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:54:08 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 '23475' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23474' 19/02/2025 12:54:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23475' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23474' 19/02/2025 12:55:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505278' AND id_product != '23475' AND ean13 != '' 19/02/2025 12:55:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281505278', date_upd = NOW() WHERE id_product = '23475' 19/02/2025 12:55:30 pm >> UPDATE ps_product_lang SET name = 'CAMMINIAMO VERSO LE NOZZE - GUIDA - S. LONGOBARDI', description = '' WHERE id_product = '23475' 19/02/2025 12:55:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '23475' 19/02/2025 12:55:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23475' 19/02/2025 12:55:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '23475' 19/02/2025 12:55:37 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23475' 19/02/2025 12:55:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23476' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:55:37 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 '23476' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23475' 19/02/2025 12:55:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23476' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23475' 19/02/2025 12:56:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505285' AND id_product != '23476' AND ean13 != '' 19/02/2025 12:56:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281505285', date_upd = NOW() WHERE id_product = '23476' 19/02/2025 12:56:05 pm >> UPDATE ps_product_lang SET name = 'CAMMINIAMO VERSO LE NOZZE - QUADERNO - S. LONGOBARDI', description = '' WHERE id_product = '23476' 19/02/2025 12:56:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.9' WHERE id_product = '23476' 19/02/2025 12:56:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23476' 19/02/2025 12:56:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '23476' 19/02/2025 12:56:06 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 = '23476' 19/02/2025 12:56:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23477' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:56:06 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 '23477' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23476' 19/02/2025 12:56:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23477' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23476' 19/02/2025 12:57:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505308-' AND id_product != '23477' AND ean13 != '' 19/02/2025 12:57:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281505308-', date_upd = NOW() WHERE id_product = '23477' 19/02/2025 12:57:55 pm >> UPDATE ps_product_lang SET name = 'GIUBILEO DELL\'AMORE', description = '' WHERE id_product = '23477' 19/02/2025 12:57:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.6' WHERE id_product = '23477' 19/02/2025 12:57:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.6', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23477' 19/02/2025 12:57:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '23477' 19/02/2025 12:58:05 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 = '23477' 19/02/2025 12:58:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23478' , '1' , '' , 'nuovo-prodotto' ) 19/02/2025 12:58:05 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 '23478' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23477' 19/02/2025 12:58:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23478' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23477' 19/02/2025 12:58: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 ( '31' , 'FPR11/25' , '2025-02-18' , '25' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '104.30' , '104.30' , NOW() , NOW() ) 19/02/2025 12:58: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 = '95818' 19/02/2025 12:58:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '95818' 19/02/2025 12:58: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 ( '95818' , '23472' , 'CALENDARIO DI QUARESIMA BEATI VOI' , '4' , '4' , '4' , '3.30' , '3.3' , '0' , '30' , '9.2400' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23472' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23472' , '174' , '1' ) 19/02/2025 12:58: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 ( '95818' , '23473' , 'RACCONTAMI DI CARLO - C. GALATOLO' , '3' , '3' , '4' , '13.00' , '13' , '0' , '30' , '27.3000' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23473' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23473' , '174' , '1' ) 19/02/2025 12:58: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 ( '95818' , '23474' , 'QUARESIMA PASQUA IN FAMIGLIA' , '4' , '4' , '4' , '3.30' , '3.3' , '0' , '30' , '9.2400' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23474' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23474' , '174' , '1' ) 19/02/2025 12:58: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 ( '95818' , '23475' , 'CAMMINIAMO VERSO LE NOZZE - GUIDA - S. LONGOBARDI' , '2' , '2' , '4' , '19.00' , '19' , '0' , '30' , '26.6000' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23475' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23475' , '174' , '1' ) 19/02/2025 12:58: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 ( '95818' , '23476' , 'CAMMINIAMO VERSO LE NOZZE - QUADERNO - S. LONGOBARDI' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '30' , '8.2600' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23476' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23476' , '174' , '1' ) 19/02/2025 12:58: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 ( '95818' , '23477' , 'GIUBILEO DELLAMORE' , '13' , '13' , '4' , '2.60' , '2.6' , '0' , '30' , '23.6600' ) 19/02/2025 12:58:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23477' AND id_supplier = '174' 19/02/2025 12:58:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23477' , '174' , '1' ) 19/02/2025 02:50:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609652' AND id_product != '23478' AND ean13 != '' 19/02/2025 02:50:11 pm >> UPDATE ps_product SET id_supplier = '', reference = 'BANCO', ean13 = '9788826609652', date_upd = NOW() WHERE id_product = '23478' 19/02/2025 02:50:11 pm >> UPDATE ps_product_lang SET name = 'MESSAGGIO PER LA QUARESIMA 2025', description = '' WHERE id_product = '23478' 19/02/2025 02:50:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2' WHERE id_product = '23478' 19/02/2025 02:50:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2', id_tax_rules_group = '4', id_category_default = '104', 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 = '23478' 19/02/2025 02:50:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23478' 19/02/2025 02:50:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826609652' AND id_product != '23478' AND ean13 != '' 19/02/2025 02:50:29 pm >> UPDATE ps_product SET id_supplier = '', reference = 'BANCO', ean13 = '9788826609652', date_upd = NOW() WHERE id_product = '23478' 19/02/2025 02:50:29 pm >> UPDATE ps_product_lang SET name = 'MESSAGGIO PER LA QUARESIMA 2025', description = '' WHERE id_product = '23478' 19/02/2025 02:50:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2' WHERE id_product = '23478' 19/02/2025 02:50:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2', id_tax_rules_group = '4', id_category_default = '104', 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 = '23478' 19/02/2025 02:50:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '23478' 19/02/2025 02:50:59 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' , '377' , '2025-02-18' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '232.75' , '232.75' , NOW() , NOW() ) 19/02/2025 02:50:59 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 = '95819' 19/02/2025 02:50:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95819' 19/02/2025 02:50:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95819' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '3' , '3' , '4' , '20.00' , '20' , '0' , '35' , '39.0000' ) 19/02/2025 02:50:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 19/02/2025 02:50:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 19/02/2025 02:50:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95819' , '10119' , 'SPE SALVI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '45' , '2.2000' ) 19/02/2025 02:50:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 19/02/2025 02:50:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 19/02/2025 02:50:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95819' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '3' , '3' , '4' , '30.00' , '30' , '0' , '35' , '58.5000' ) 19/02/2025 02:50:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 19/02/2025 02:50:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 19/02/2025 02:50:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95819' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '3' , '3' , '4' , '20.00' , '20' , '0' , '35' , '39.0000' ) 19/02/2025 02:50:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21615' AND id_supplier = '79' 19/02/2025 02:50:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21615' , '79' , '1' ) 19/02/2025 02:50:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95819' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '2' , '2' , '4' , '9.50' , '9.5' , '0' , '45' , '10.4500' ) 19/02/2025 02:50:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23313' AND id_supplier = '79' 19/02/2025 02:50:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23313' , '79' , '1' ) 19/02/2025 02:51: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 ( '95819' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 19/02/2025 02:51:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 19/02/2025 02:51:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 19/02/2025 02:51: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 ( '95819' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '10' , '10' , '4' , '1.20' , '1.2' , '0' , '45' , '6.6000' ) 19/02/2025 02:51:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23478' AND id_supplier = '79' 19/02/2025 02:51:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23478' , '79' , '1' ) 19/02/2025 03:25:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 03:25:47 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' , '546' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 19/02/2025 03:25:47 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 = '95820' 19/02/2025 03:25:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '95820' 19/02/2025 03:25:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95820' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/02/2025 03:33:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 03:33: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' , '547' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.26' , '69.20' , NOW() , NOW() ) 19/02/2025 03:33: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 = '95821' 19/02/2025 03:33:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '95821' 19/02/2025 03:33: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 ( '95821' , '22880' , 'CODICE DI DIRITTO CANONICO' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 19/02/2025 03:33: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 ( '95821' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/02/2025 03:33: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 ( '95821' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 19/02/2025 03:33: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 ( '95821' , '21646' , 'PERDONATI - QUADERNO' , '2' , '-2' , '4' , '7.50' , '7.5' , '0' , '5' , '14.26' ) 19/02/2025 03:54:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '498' AND id_document != '95762' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-15') 19/02/2025 03:54:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '498', document_date = '2025-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.00', price_tax_excluded = '132.33', date_upd = NOW() WHERE id_document = '95762' 19/02/2025 03:54:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95762' 19/02/2025 03:54:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '95762' 19/02/2025 03:54:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95762' , '22255' , 'SAN GIUSEPPE CM 40 - 804' , '1' , '-1' , '1' , '98.0000' , '80.327868852459' , '22' , '0' , '98.00' ) 19/02/2025 03:54:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95762' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '31.1' , '31.1' , '0' , '0' , '31.10' ) 19/02/2025 03:54:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95762' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 19/02/2025 04:02:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 04:02: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 ( '21' , '34' , '2025-02-19' , '' , '4163' , '0' , '4679464' , 'VIA SAN ROCCO 17 84038 SASSANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '39.20' , '39.20' , NOW() , NOW() ) 19/02/2025 04:02: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 = '95822' 19/02/2025 04:02:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95822' 19/02/2025 04:02: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 ( '95822' , '8408' , 'PRENDETE E MANGIATE' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '5' , '34.20' ) 19/02/2025 04:22:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '548' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 04:22:57 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' , '548' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.90' , '33.52' , NOW() , NOW() ) 19/02/2025 04:22: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 = '95823' 19/02/2025 04:22:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95823' 19/02/2025 04:22: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 ( '95823' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '6' , '-6' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '36.00' ) 19/02/2025 04:22: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 ( '95823' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 19/02/2025 04:30:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 04:30:19 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' , '549' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '87.37' , NOW() , NOW() ) 19/02/2025 04:30:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95824' 19/02/2025 04:30:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95824' 19/02/2025 04:30:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95824' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 19/02/2025 04:30:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95824' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 19/02/2025 06:04:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 19/02/2025 06:04:47 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', 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 = '140.70', price_tax_excluded = '126.18', date_upd = NOW() WHERE id_document = '95409' 19/02/2025 06:04:47 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 = '95409' 19/02/2025 06:04:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '95409' 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '10' , '18.00' ) 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23463' , 'GRUPPO LITURGICO PARROCCHIALE - F. GILARDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 19/02/2025 06:04:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 19/02/2025 06:10:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 19/02/2025 06:10:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', 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 = '185.70', price_tax_excluded = '163.07', date_upd = NOW() WHERE id_document = '95409' 19/02/2025 06:10: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 = '95409' 19/02/2025 06:10:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '95409' 19/02/2025 06:10: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 ( '95409' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 19/02/2025 06:10: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 ( '95409' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 19/02/2025 06:10: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 ( '95409' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '10' , '18.00' ) 19/02/2025 06:10: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 ( '95409' , '23463' , 'GRUPPO LITURGICO PARROCCHIALE - F. GILARDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/02/2025 06:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 19/02/2025 06:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 19/02/2025 06:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '20' , '-20' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '44.00' ) 19/02/2025 06:10:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/02/2025 06:52:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 06:52:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '550' , '2025-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.52' , '5.52' , NOW() , NOW() ) 19/02/2025 06:52: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 = '95825' 19/02/2025 06:52:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95825' 19/02/2025 06:52: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 ( '95825' , '23459' , 'PAROLA E PREGHIERA - APR 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 19/02/2025 06:52: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 ( '95825' , '23356' , 'PAROLA E PREGHIERA - MAR 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 19/02/2025 07:06:10 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'bNcVCuypgdIPHKTS' , NOW() , NOW() ) 19/02/2025 07:06:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7124' , '1' ) 19/02/2025 07:06:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7124' , '2' ) 19/02/2025 07:06:10 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7124' , '3' ) 19/02/2025 07:07:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7124' 19/02/2025 07:07:52 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 ( '7124' , '10' , '148' , 'PARROCCHIA SAN LEUCIO' , 'GROSSI' , 'DON LORETO' , 'VIA TRENTO E TRIESTE 1' , '' , '66041' , 'ATESSA' , '' , '' , '3491121014' , '' , '94000010697' , NOW() , NOW() ) 19/02/2025 07:07:53 pm >> UPDATE ps_customer SET email = 'loreto.grossi@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7124' 19/02/2025 07:08:30 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7124' 19/02/2025 07:08: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 ( '7124' , '10' , '148' , 'PARROCCHIA SAN LEUCIO' , 'GROSSI' , 'DON LORETO' , 'VIA TRENTO E TRIESTE 1' , '' , '66041' , 'ATESSA' , '' , '' , '3491121014' , '' , '94000010697' , NOW() , NOW() ) 19/02/2025 07:08:30 pm >> UPDATE ps_customer SET email = 'loreto.grossi@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7124' 19/02/2025 07:10:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-19') 19/02/2025 07:10:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '5' , '2025-02-19' , '' , '7124' , '0' , '177359075' , 'VIA TRENTO E TRIESTE 1 66041 ATESSA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '49.40' , '49.40' , NOW() , NOW() ) 19/02/2025 07:10:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14790' 19/02/2025 07:10:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '14790' 19/02/2025 07:10:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14790' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 19/02/2025 07:19:21 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3796' 19/02/2025 07:19:21 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 ( '3796' , '10' , '148' , 'PARR. SAN LEUCIO' , 'GROSSI' , 'DON LORETO' , 'VIA TRENTO E TRIESTE 1' , '' , '66041' , 'ATESSA ' , '' , '' , '3491121014' , '' , '94000010697' , NOW() , NOW() ) 19/02/2025 07:19:21 pm >> UPDATE ps_customer SET email = 'loreto.grossi@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3796' 19/02/2025 07:19:27 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7124' 19/02/2025 07:19:27 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 ( '7124' , '10' , '148' , 'PARROCCHIA SAN LEUCIO' , 'GROSSI' , 'DON LORETO' , 'VIA TRENTO E TRIESTE 1' , '' , '66041' , 'ATESSA' , '' , '' , '3491121014' , '' , '94000010697' , NOW() , NOW() ) 19/02/2025 07:19:27 pm >> UPDATE ps_customer SET email = 'loreto.grossi@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7124'