11/10/2023 08:29:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2269' AND id_document != '86598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-01') 11/10/2023 08:29:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2269', document_date = '2023-07-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '585.00', price_tax_excluded = '479.51', date_upd = NOW() WHERE id_document = '86598' 11/10/2023 08:29:43 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 = '86598' 11/10/2023 08:29:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86598' 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '16' , '-16' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '56.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '93.3' , '76.475409836066' , '22' , '0' , '93.30' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '13845' , 'COLLANINA IN ACCIAIO ANGELO - 1984/A48' , '20' , '-20' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '70.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '13550' , 'COLLANINA ARGENTATA ORME DELLA SABBIA - 1984/J98' , '7' , '-7' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '24.50' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '9' , '-9' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '58.50' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18220' , 'CATENA CON CROCE - NS020' , '28' , '-28' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '70.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '21100' , 'COLLANA CON CROCE ACCIAIO - NS014' , '12' , '-12' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '30.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '12.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '8' , '-8' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '4.80' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '20072' , 'BRACCIALE - BC1759N' , '3' , '-3' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '6.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '21099' , 'BRACCIALE DECINA - BD008' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 11/10/2023 08:29:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '7202' , 'ROSARIO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '13549' , 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97' , '9' , '-9' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '31.50' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '63.0000' , '51.639344262295' , '22' , '0' , '63.00' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/10/2023 08:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86598' , '5573' , 'LAVABO ' , '4' , '-4' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '12.00' ) 11/10/2023 09:09:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 09:09:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3109' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.20' , '11.20' , NOW() , NOW() ) 11/10/2023 09:09:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88209' 11/10/2023 09:09:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88209' 11/10/2023 09:09:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88209' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 11/10/2023 09:09:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88209' , '20056' , 'BEATA COLEI CHE HA CREDUTO' , '1' , '-1' , '4' , '3.55' , '3.55' , '0' , '0' , '3.55' ) 11/10/2023 09:09:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88209' , '14543' , 'CALENDARIO LITURGICO MARIANO 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 11/10/2023 09:17: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 ( '33' , '643671' , '2023-10-09' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.04' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '159.56' , '159.56' , NOW() , NOW() ) 11/10/2023 09:17: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 = '88210' 11/10/2023 09:17:45 am >> DELETE FROM ps_document_detail WHERE id_document = '88210' 11/10/2023 09:17: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 ( '88210' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '2' , '2' , '4' , '24.00' , '24' , '0' , '35' , '31.2000' ) 11/10/2023 09:17:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '12809' AND id_supplier = '7' 11/10/2023 09:17:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12809' , '7' , '1' ) 11/10/2023 09:17: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 ( '88210' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '4' , '4' , '4' , '12.00' , '12' , '0' , '35+7' , '29.0160' ) 11/10/2023 09:17:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '5451' AND id_supplier = '7' 11/10/2023 09:17:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5451' , '7' , '1' ) 11/10/2023 09:17: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 ( '88210' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '4' , '4' , '4' , '12.00' , '12' , '0' , '35+7' , '29.0160' ) 11/10/2023 09:17:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 11/10/2023 09:17:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 11/10/2023 09:17: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 ( '88210' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '3' , '3' , '4' , '12.00' , '12' , '0' , '35+7' , '21.7620' ) 11/10/2023 09:17:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9681' AND id_supplier = '7' 11/10/2023 09:17:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9681' , '7' , '1' ) 11/10/2023 09:17:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88210' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '3' , '3' , '4' , '12.00' , '12' , '0' , '35+7' , '21.7620' ) 11/10/2023 09:17:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 11/10/2023 09:17:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 11/10/2023 09:17:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88210' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '3' , '3' , '4' , '12.00' , '12' , '0' , '35+7' , '21.7620' ) 11/10/2023 09:17:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '7' 11/10/2023 09:17:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '7' , '1' ) 11/10/2023 10:04:09 am >> SELECT document_num FROM ps_document WHERE document_num = '149' AND id_document != '88207' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-10') 11/10/2023 10:04:09 am >> UPDATE ps_document SET id_document_type = '21', document_num = '149', document_date = '2023-10-10', document_letter = '', id_customer = '3455', id_supplier = '', id_address = '4672079', address1 = 'C. DA SANTA DOMENICA, SNC 84031 AULETTA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '101.59', price_tax_excluded = '101.59', date_upd = NOW() WHERE id_document = '88207' 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88207' 11/10/2023 10:04:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88207' 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '8408' , 'PRENDETE E MANGIATE' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '5' , '37.05' ) 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '13' , '-13' , '4' , '1.9000' , '1.9' , '0' , '5' , '23.46' ) 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 11/10/2023 10:04:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88207' , '11151' , 'moccoli' , '4' , '-4' , '4' , '4' , '4' , '0' , '0' , '16.00' ) 11/10/2023 10:18:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/10/2023 10:18:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21658' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:18:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21658' , '1' , '1' , '2' , NOW() , NOW() ) 11/10/2023 10:18:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21658' , '0' , '1' , '0' , '0' ) 11/10/2023 10:19:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556354' AND id_product != '21658' AND ean13 != '' 11/10/2023 10:19:57 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788831556354', date_upd = NOW() WHERE id_product = '21658' 11/10/2023 10:19:57 am >> UPDATE ps_product_lang SET name = 'SONO IO CHE TI PARLO - ANNO B - S. RAMIREZ', description = '' WHERE id_product = '21658' 11/10/2023 10:19:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21658' 11/10/2023 10:19:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21658' 11/10/2023 10:19:58 am >> DELETE FROM ps_specific_price WHERE id_product = '21658' 11/10/2023 10:19:59 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21658' 11/10/2023 10:19:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21659' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:19:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21659' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21658' 11/10/2023 10:19:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21659' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21658' 11/10/2023 10:32:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555876' AND id_product != '21659' AND ean13 != '' 11/10/2023 10:32:23 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788831555876', date_upd = NOW() WHERE id_product = '21659' 11/10/2023 10:32:23 am >> UPDATE ps_product_lang SET name = 'MARIA RITRATTO DI UNA DONNA ', description = '' WHERE id_product = '21659' 11/10/2023 10:32:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21659' 11/10/2023 10:32:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21659' 11/10/2023 10:32:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21659' 11/10/2023 10:32:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555876' AND id_product != '21659' AND ean13 != '' 11/10/2023 10:32:36 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788831555876', date_upd = NOW() WHERE id_product = '21659' 11/10/2023 10:32:36 am >> UPDATE ps_product_lang SET name = 'MARIA RITRATTO DI UNA DONNA ', description = '' WHERE id_product = '21659' 11/10/2023 10:32:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21659' 11/10/2023 10:32:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21659' 11/10/2023 10:32:36 am >> DELETE FROM ps_specific_price WHERE id_product = '21659' 11/10/2023 10:32:38 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21659' 11/10/2023 10:32:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21660' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:32:38 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21660' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21659' 11/10/2023 10:32:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21660' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21659' 11/10/2023 10:33:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556347' AND id_product != '21660' AND ean13 != '' 11/10/2023 10:33:24 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788831556347', date_upd = NOW() WHERE id_product = '21660' 11/10/2023 10:33:24 am >> UPDATE ps_product_lang SET name = 'PREGHIERA SEMINA GIOIA', description = '' WHERE id_product = '21660' 11/10/2023 10:33:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21660' 11/10/2023 10:33:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21660' 11/10/2023 10:33:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21660' 11/10/2023 10:33:25 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21660' 11/10/2023 10:33:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21661' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:33:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21661' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21660' 11/10/2023 10:33:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21661' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21660' 11/10/2023 10:34:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556248' AND id_product != '21661' AND ean13 != '' 11/10/2023 10:34:02 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788831556248', date_upd = NOW() WHERE id_product = '21661' 11/10/2023 10:34:02 am >> UPDATE ps_product_lang SET name = 'MIO NATALE DA SCOPRIRE', description = '' WHERE id_product = '21661' 11/10/2023 10:34:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.9' WHERE id_product = '21661' 11/10/2023 10:34:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21661' 11/10/2023 10:34:02 am >> DELETE FROM ps_specific_price WHERE id_product = '21661' 11/10/2023 10:34:04 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21661' 11/10/2023 10:34:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21662' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:34:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21662' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21661' 11/10/2023 10:34:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21662' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21661' 11/10/2023 10:35:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555302' AND id_product != '21662' AND ean13 != '' 11/10/2023 10:35:02 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831555302', date_upd = NOW() WHERE id_product = '21662' 11/10/2023 10:35:02 am >> UPDATE ps_product_lang SET name = 'ANDIAMO VERSO GESU\'', description = '' WHERE id_product = '21662' 11/10/2023 10:35:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21662' 11/10/2023 10:35:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21662' 11/10/2023 10:35:02 am >> DELETE FROM ps_specific_price WHERE id_product = '21662' 11/10/2023 10:35:04 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21662' 11/10/2023 10:35:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21663' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:35:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21663' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21662' 11/10/2023 10:35:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21663' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21662' 11/10/2023 10:36:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885952447' AND id_product != '21663' AND ean13 != '' 11/10/2023 10:36:27 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788885952447', date_upd = NOW() WHERE id_product = '21663' 11/10/2023 10:36:27 am >> UPDATE ps_product_lang SET name = 'CORAGGIO DI UNA DONNA ', description = '' WHERE id_product = '21663' 11/10/2023 10:36:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21663' 11/10/2023 10:36:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '497', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21663' 11/10/2023 10:36:27 am >> DELETE FROM ps_specific_price WHERE id_product = '21663' 11/10/2023 10:36:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21663' 11/10/2023 10:36:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21664' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:36:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21664' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21663' 11/10/2023 10:36:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21664' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21663' 11/10/2023 10:37:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 10:37:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3110' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 11/10/2023 10:37:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88211' 11/10/2023 10:37:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88211' 11/10/2023 10:37:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88211' , '19880' , 'CROCE CM 25 ARGENTO - 4975/837' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 11/10/2023 10:38:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934550' AND id_product != '21664' AND ean13 != '' 11/10/2023 10:38:59 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934550', date_upd = NOW() WHERE id_product = '21664' 11/10/2023 10:38:59 am >> UPDATE ps_product_lang SET name = 'STORIA DEL DOGMA CRISTOLOGICO - F. DUNZL', description = '' WHERE id_product = '21664' 11/10/2023 10:38:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '21664' 11/10/2023 10:38:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21664' 11/10/2023 10:38:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21664' 11/10/2023 10:39:00 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21664' 11/10/2023 10:39:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21665' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:39:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21665' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21664' 11/10/2023 10:39:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21665' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21664' 11/10/2023 10:39:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253247' AND id_product != '21665' AND ean13 != '' 11/10/2023 10:39:54 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791281253247', date_upd = NOW() WHERE id_product = '21665' 11/10/2023 10:39:54 am >> UPDATE ps_product_lang SET name = 'GRIDIAMO IL VANGELO - A. COMASTRI', description = '' WHERE id_product = '21665' 11/10/2023 10:39:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '21665' 11/10/2023 10:39:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21665' 11/10/2023 10:39:54 am >> DELETE FROM ps_specific_price WHERE id_product = '21665' 11/10/2023 10:40:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253247' AND id_product != '21665' AND ean13 != '' 11/10/2023 10:40:40 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791281253247', date_upd = NOW() WHERE id_product = '21665' 11/10/2023 10:40:40 am >> UPDATE ps_product_lang SET name = 'GRIDIAMO IL VANGELO - A. COMASTRI', description = '' WHERE id_product = '21665' 11/10/2023 10:40:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '21665' 11/10/2023 10:40:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21665' 11/10/2023 10:40:40 am >> DELETE FROM ps_specific_price WHERE id_product = '21665' 11/10/2023 10:40:41 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21665' 11/10/2023 10:40:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21666' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:40:41 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21666' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21665' 11/10/2023 10:40:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21666' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21665' 11/10/2023 10:41:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055863' AND id_product != '21666' AND ean13 != '' 11/10/2023 10:41:39 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788825055863', date_upd = NOW() WHERE id_product = '21666' 11/10/2023 10:41:39 am >> UPDATE ps_product_lang SET name = 'UN ANNO CON IL VANGELO', description = '' WHERE id_product = '21666' 11/10/2023 10:41:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '21666' 11/10/2023 10:41:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21666' 11/10/2023 10:41:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21666' 11/10/2023 10:41:42 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21666' 11/10/2023 10:41:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21667' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:41:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21667' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21666' 11/10/2023 10:41:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21667' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21666' 11/10/2023 10:42:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242654' AND id_product != '21667' AND ean13 != '' 11/10/2023 10:42:35 am >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788892242654', date_upd = NOW() WHERE id_product = '21667' 11/10/2023 10:42:35 am >> UPDATE ps_product_lang SET name = 'IN CAMMINO CON VOI - GENTILI/VISCARDI', description = '' WHERE id_product = '21667' 11/10/2023 10:42:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21667' 11/10/2023 10:42:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21667' 11/10/2023 10:42:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21667' 11/10/2023 10:42:36 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21667' 11/10/2023 10:42:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21668' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:42:36 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21668' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21667' 11/10/2023 10:42:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21668' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21667' 11/10/2023 10:43:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243019' AND id_product != '21668' AND ean13 != '' 11/10/2023 10:43:13 am >> UPDATE ps_product SET id_supplier = '', reference = '11/5', ean13 = '9788892243019', date_upd = NOW() WHERE id_product = '21668' 11/10/2023 10:43:13 am >> UPDATE ps_product_lang SET name = 'ALFABETO DI DIO - G. RAVASI', description = '' WHERE id_product = '21668' 11/10/2023 10:43:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21668' 11/10/2023 10:43:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21668' 11/10/2023 10:43:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21668' 11/10/2023 10:43:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21668' 11/10/2023 10:43:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21669' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:43:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21669' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21668' 11/10/2023 10:43:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21669' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21668' 11/10/2023 10:43:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556309' AND id_product != '21669' AND ean13 != '' 11/10/2023 10:43:54 am >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788831556309', date_upd = NOW() WHERE id_product = '21669' 11/10/2023 10:43:54 am >> UPDATE ps_product_lang SET name = '24 RACCONTI DI NATALE', description = '' WHERE id_product = '21669' 11/10/2023 10:43:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29' WHERE id_product = '21669' 11/10/2023 10:43:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29', id_tax_rules_group = '4', id_category_default = '27', 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 = '21669' 11/10/2023 10:43:54 am >> DELETE FROM ps_specific_price WHERE id_product = '21669' 11/10/2023 10:43:55 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21669' 11/10/2023 10:43:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21670' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 10:43:55 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21670' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21669' 11/10/2023 10:43:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21670' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21669' 11/10/2023 10:47: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 ( '33' , '643281' , '2023-10-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.78' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.79' , '165.79' , NOW() , NOW() ) 11/10/2023 10:47: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 = '88212' 11/10/2023 10:47:32 am >> DELETE FROM ps_document_detail WHERE id_document = '88212' 11/10/2023 10:47: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 ( '88212' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21668' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21668' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21660' , 'PREGHIERA SEMINA GIOIA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '33' , '20.1000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21660' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21660' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21669' , '24 RACCONTI DI NATALE' , '1' , '1' , '4' , '29.00' , '29' , '0' , '35' , '18.8500' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21669' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21669' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '1' , '4' , '14.90' , '14.9' , '0' , '35' , '9.6850' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21661' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21661' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21658' , 'SONO IO CHE TI PARLO - ANNO B - S. RAMIREZ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21658' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21658' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21662' , 'ANDIAMO VERSO GESU' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '35' , '8.9700' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21662' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21662' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21663' , 'CORAGGIO DI UNA DONNA ' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21663' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21663' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21667' , 'IN CAMMINO CON VOI - GENTILI/VISCARDI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21667' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21667' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21665' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21665' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21659' , 'MARIA RITRATTO DI UNA DONNA ' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '33' , '9.2460' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21659' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21659' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21666' , 'UN ANNO CON IL VANGELO' , '2' , '2' , '4' , '8.00' , '8' , '0' , '30' , '11.2000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21666' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21666' , '7' , '1' ) 11/10/2023 10:47: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 ( '88212' , '21664' , 'STORIA DEL DOGMA CRISTOLOGICO - F. DUNZL' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 11/10/2023 10:47:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '21664' AND id_supplier = '7' 11/10/2023 10:47:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21664' , '7' , '1' ) 11/10/2023 11:15:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:15:43 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' , '3111' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.15' , '35.15' , NOW() , NOW() ) 11/10/2023 11:15:43 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 = '88213' 11/10/2023 11:15:43 am >> DELETE FROM ps_document_detail WHERE id_document = '88213' 11/10/2023 11:15:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88213' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 11/10/2023 11:15:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88213' , '21411' , 'ANNO LITURGICO - A. BERGAMINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 11/10/2023 11:15:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88213' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 11/10/2023 11:16:47 am >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:16:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '150' , '2023-10-11' , '' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '448.80' , '448.80' , NOW() , NOW() ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88214' 11/10/2023 11:16:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88214' 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '-15' , '4' , '3.4000' , '3.4' , '0' , '15' , '43.35' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '8' , '-8' , '4' , '10.0000' , '10' , '0' , '15' , '68.00' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '6' , '-6' , '4' , '10.0000' , '10' , '0' , '15' , '51.00' ) 11/10/2023 11:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '15' , '95.20' ) 11/10/2023 11:17:08 am >> DELETE FROM ps_document WHERE id_document = '88202' 11/10/2023 11:17:08 am >> DELETE FROM ps_document_detail WHERE id_document = '88202' 11/10/2023 11:19:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:19: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' , '3112' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 11/10/2023 11:19: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 = '88215' 11/10/2023 11:19:15 am >> DELETE FROM ps_document_detail WHERE id_document = '88215' 11/10/2023 11:19: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 ( '88215' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/10/2023 11:19:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:19: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' , '3113' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 11/10/2023 11:19: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 = '88216' 11/10/2023 11:19:32 am >> DELETE FROM ps_document_detail WHERE id_document = '88216' 11/10/2023 11:19: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 ( '88216' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/10/2023 11:37:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806260194' AND id_product != '21670' AND ean13 != '' 11/10/2023 11:37:30 am >> UPDATE ps_product SET id_supplier = '', reference = 'gondola 1', ean13 = '9788806260194', date_upd = NOW() WHERE id_product = '21670' 11/10/2023 11:37:30 am >> UPDATE ps_product_lang SET name = 'PER CUSTODIRE IL FUOCO - L. M. EPICOCO', description = '' WHERE id_product = '21670' 11/10/2023 11:37:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21670' 11/10/2023 11:37:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '278', 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 = '21670' 11/10/2023 11:37:30 am >> DELETE FROM ps_specific_price WHERE id_product = '21670' 11/10/2023 11:37:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21670' 11/10/2023 11:37:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21671' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 11:37:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21671' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21670' 11/10/2023 11:37:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21671' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21670' 11/10/2023 11:38:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804781653' AND id_product != '21671' AND ean13 != '' 11/10/2023 11:38:10 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788804781653', date_upd = NOW() WHERE id_product = '21671' 11/10/2023 11:38:10 am >> UPDATE ps_product_lang SET name = 'RESISTI CUORE', description = '' WHERE id_product = '21671' 11/10/2023 11:38:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21671' 11/10/2023 11:38:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '46', 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 = '21671' 11/10/2023 11:38:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21671' 11/10/2023 11:38: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 ( '33' , '1190921' , '2023-10-10' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '211.00' , '211.00' , NOW() , NOW() ) 11/10/2023 11:38: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 = '88217' 11/10/2023 11:38:57 am >> DELETE FROM ps_document_detail WHERE id_document = '88217' 11/10/2023 11:38: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 ( '88217' , '21670' , 'PER CUSTODIRE IL FUOCO - L. M. EPICOCO' , '3' , '3' , '4' , '12.00' , '12' , '0' , '0' , '36.0000' ) 11/10/2023 11:38:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '21670' AND id_supplier = '177' 11/10/2023 11:38:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21670' , '177' , '1' ) 11/10/2023 11:38: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 ( '88217' , '21671' , 'RESISTI CUORE' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 11/10/2023 11:38:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '21671' AND id_supplier = '177' 11/10/2023 11:38:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21671' , '177' , '1' ) 11/10/2023 11:38:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88217' , '20393' , 'DON MILANI - TUTTE LE OPERE' , '1' , '1' , '4' , '140.00' , '140' , '0' , '0' , '140.00' ) 11/10/2023 11:38:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20393' AND id_supplier = '177' 11/10/2023 11:38:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20393' , '177' , '1' ) 11/10/2023 11:38:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88217' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 11/10/2023 11:38:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '21606' AND id_supplier = '177' 11/10/2023 11:38:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21606' , '177' , '1' ) 11/10/2023 11:39:19 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 11/10/2023 11:39:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.30', price_tax_excluded = '36.30', date_upd = NOW() WHERE id_document = '81317' 11/10/2023 11:39:19 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 = '81317' 11/10/2023 11:39:19 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 11/10/2023 11:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 11/10/2023 11:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 11/10/2023 11:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 11/10/2023 11:39:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 11/10/2023 11:44:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:44:06 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' , '3114' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '49.30' , NOW() , NOW() ) 11/10/2023 11:44:06 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 = '88218' 11/10/2023 11:44:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88218' 11/10/2023 11:44:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88218' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 11/10/2023 11:44:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88218' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '37' , '37' , '0' , '0' , '37.00' ) 11/10/2023 11:47:41 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'nlBxwKaBIrsCZeIB' , NOW() , NOW() ) 11/10/2023 11:47:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4035' , '1' ) 11/10/2023 11:47:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4035' , '2' ) 11/10/2023 11:47:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4035' , '3' ) 11/10/2023 11:49:17 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4035' 11/10/2023 11:49:17 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 ( '4035' , '10' , '210' , 'PARROCCHIA SS SALVATORE' , 'CALVANO' , 'PADRE MASSIMO' , 'VIA DEL SALVATORE' , '' , '84076' , 'TORCHIARA' , '' , '' , '' , '' , '90001790659' , NOW() , NOW() ) 11/10/2023 11:49:17 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4035' 11/10/2023 11:49:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4035' 11/10/2023 11:49:28 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 ( '4035' , '10' , '210' , 'PARROCCHIA SS SALVATORE' , 'CALVANO' , 'PADRE MASSIMO' , 'VIA DEL SALVATORE' , '' , '84076' , 'TORCHIARA' , '' , '' , '3337831403' , '' , '90001790659' , NOW() , NOW() ) 11/10/2023 11:49:28 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4035' 11/10/2023 11:51:47 am >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:51:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '151' , '2023-10-11' , '' , '4035' , '0' , '4679123' , 'VIA DEL SALVATORE 84076 TORCHIARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '324.70' , '324.70' , NOW() , NOW() ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88219' 11/10/2023 11:51:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88219' 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '4154' , 'FESTA DEL PERDONO' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '15' , '102.00' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '30' , '-30' , '4' , '3.40' , '3.4' , '0' , '15' , '86.70' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 11/10/2023 11:51:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88219' , '4120' , 'FEDE NELLO ZAINETTO' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '15' , '21.25' ) 11/10/2023 11:55:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 11:55: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 ( '11' , '3115' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.30' , '68.30' , NOW() , NOW() ) 11/10/2023 11:55: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 = '88220' 11/10/2023 11:55:57 am >> DELETE FROM ps_document_detail WHERE id_document = '88220' 11/10/2023 11:55: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 ( '88220' , '21645' , 'LAUDATE DEUM' , '4' , '-4' , '4' , '1.90' , '1.9' , '0' , '0' , '7.60' ) 11/10/2023 11:55: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 ( '88220' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/10/2023 11:55: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 ( '88220' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 11/10/2023 11:55: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 ( '88220' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '32.2' , '32.2' , '0' , '0' , '32.20' ) 11/10/2023 12:05:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 12:05: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' , '3116' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.78' , '19.46' , NOW() , NOW() ) 11/10/2023 12:05: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 = '88221' 11/10/2023 12:05:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '88221' 11/10/2023 12:05: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 ( '88221' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 11/10/2023 12:05: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 ( '88221' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/10/2023 12:05: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 ( '88221' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 11/10/2023 12:05: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 ( '88221' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 11/10/2023 12:05: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 ( '88221' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 11/10/2023 12:08:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 12:08:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3117' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '7.42' , NOW() , NOW() ) 11/10/2023 12:08:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88222' 11/10/2023 12:08:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '88222' 11/10/2023 12:08:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88222' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/10/2023 12:08:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88222' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 11/10/2023 12:11:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '88214' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 12:11:17 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '150', document_date = '2023-10-11', document_letter = '', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', 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 = '448.80', price_tax_excluded = '448.80', date_upd = NOW() WHERE id_document = '88214' 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88214' 11/10/2023 12:11:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88214' 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '-15' , '4' , '3.4000' , '3.4' , '0' , '15' , '43.35' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '8' , '-8' , '4' , '10.0000' , '10' , '0' , '15' , '68.00' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '6' , '-6' , '4' , '10.0000' , '10' , '0' , '15' , '51.00' ) 11/10/2023 12:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88214' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '40' , '-40' , '4' , '2.8000' , '2.8' , '0' , '15' , '95.20' ) 11/10/2023 12:12:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '88219' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 12:12:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '151', document_date = '2023-10-11', document_letter = '', id_customer = '4035', id_supplier = '', id_address = '4679123', address1 = 'VIA DEL SALVATORE 84076 TORCHIARA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '324.70', price_tax_excluded = '324.70', date_upd = NOW() WHERE id_document = '88219' 11/10/2023 12:12: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 = '88219' 11/10/2023 12:12:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '88219' 11/10/2023 12:12: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 ( '88219' , '4154' , 'FESTA DEL PERDONO' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '15' , '102.00' ) 11/10/2023 12:12: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 ( '88219' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 11/10/2023 12:12: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 ( '88219' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 11/10/2023 12:12: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 ( '88219' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 11/10/2023 12:12: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 ( '88219' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 11/10/2023 12:12: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 ( '88219' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '15' , '12.75' ) 11/10/2023 12:12: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 ( '88219' , '4120' , 'FEDE NELLO ZAINETTO' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '15' , '21.25' ) 11/10/2023 12:19:07 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/10/2023 12:19:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21672' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 12:19:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21672' , '1' , '1' , '2' , NOW() , NOW() ) 11/10/2023 12:19:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21672' , '0' , '1' , '0' , '0' ) 11/10/2023 12:20:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576297' AND id_product != '21672' AND ean13 != '' 11/10/2023 12:20:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788873576297', date_upd = NOW() WHERE id_product = '21672' 11/10/2023 12:20:14 pm >> UPDATE ps_product_lang SET name = 'sono venuto perche\' abbiano la vita - m. bergamasco', description = '' WHERE id_product = '21672' 11/10/2023 12:20:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '21672' 11/10/2023 12:20:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21672' 11/10/2023 12:20:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '21672' 11/10/2023 12:20:15 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 = '21672' 11/10/2023 12:20:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21673' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 12:20:15 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 '21673' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21672' 11/10/2023 12:20:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21673' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21672' 11/10/2023 12:22:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821315718' AND id_product != '21673' AND ean13 != '' 11/10/2023 12:22:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788821315718', date_upd = NOW() WHERE id_product = '21673' 11/10/2023 12:22:22 pm >> UPDATE ps_product_lang SET name = 'PARTECIPARE LA BIBBIA - AAVV', description = '' WHERE id_product = '21673' 11/10/2023 12:22:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21673' 11/10/2023 12:22:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '87', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21673' 11/10/2023 12:22:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21673' 11/10/2023 12:22:23 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 = '21673' 11/10/2023 12:22:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21674' , '1' , '' , 'nuovo-prodotto' ) 11/10/2023 12:22:23 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 '21674' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21673' 11/10/2023 12:22:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21674' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21673' 11/10/2023 12:24:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000055305' , '2023-10-10' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.03' , '114.03' , NOW() , NOW() ) 11/10/2023 12:24:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88223' 11/10/2023 12:24:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88223' 11/10/2023 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '21672' , 'sono venuto perche abbiano la vita - m. bergamasco' , '3' , '3' , '4' , '6.00' , '6' , '0' , '35' , '11.7000' ) 11/10/2023 12:24:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21672' AND id_supplier = '107' 11/10/2023 12:24:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21672' , '107' , '1' ) 11/10/2023 12:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '20395' , 'SANTA FAMIGLIA ' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 11/10/2023 12:24:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20395' AND id_supplier = '107' 11/10/2023 12:24:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20395' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '1' , '4' , '22.00' , '22' , '0' , '35' , '14.3000' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5868' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5868' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '1' , '4' , '35.00' , '35' , '0' , '35' , '22.7500' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19139' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19139' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '1' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '21673' , 'PARTECIPARE LA BIBBIA - AAVV' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21673' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21673' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '26' , '26' , '4' , '1.20' , '1.2' , '0' , '35' , '20.2800' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '107' , '1' ) 11/10/2023 12:24:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88223' , '21621' , 'CALENDARIO FRATE INDOVINO 2024' , '2' , '2' , '4' , '5.00' , '5' , '0' , '35' , '6.5000' ) 11/10/2023 12:24:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21621' AND id_supplier = '107' 11/10/2023 12:24:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21621' , '107' , '1' ) 11/10/2023 03:37:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '152' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:37: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 ( '21' , '152' , '2023-10-11' , '' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 11/10/2023 03:37: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 = '88224' 11/10/2023 03:37:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '88224' 11/10/2023 03:37: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 ( '88224' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/10/2023 03:38:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:38:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3118' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 11/10/2023 03:38:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88225' 11/10/2023 03:38:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88225' 11/10/2023 03:38:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88225' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 11/10/2023 03:39:08 pm >> DELETE FROM ps_document WHERE id_document = '88224' 11/10/2023 03:39:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88224' 11/10/2023 03:40:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:40:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3119' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 11/10/2023 03:40:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88226' 11/10/2023 03:40:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '88226' 11/10/2023 03:40:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88226' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/10/2023 03:41:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:41: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 ( '23' , '46/E' , '2023-10-11' , 'E' , '2482' , '0' , '4669475' , 'VIA DI PORTA ROMANA, 7 06024 GUBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 11/10/2023 03:41: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 = '88227' 11/10/2023 03:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88227' 11/10/2023 03:41: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 ( '88227' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 11/10/2023 03:41:43 pm >> DELETE FROM ps_document WHERE id_document = '88227' 11/10/2023 03:41:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '88227' 11/10/2023 03:51:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3120' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:51:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3120' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 11/10/2023 03:51: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 = '88228' 11/10/2023 03:51:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88228' 11/10/2023 03:51: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 ( '88228' , '21388' , 'AGENDA DEL CATECHISTA 2023-2024' , '6' , '-6' , '4' , '1.50' , '1.5' , '0' , '0' , '9.00' ) 11/10/2023 03:57:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:57:43 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' , '3121' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.55' , '79.14' , NOW() , NOW() ) 11/10/2023 03:57:43 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 = '88229' 11/10/2023 03:57:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '88229' 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '5' , '8.55' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/10/2023 03:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88229' , '21595' , 'SEGNALIBRO SAN PAOLO' , '30' , '-30' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '7.50' ) 11/10/2023 03:58:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 03:58: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' , '3122' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 11/10/2023 03:58: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 = '88230' 11/10/2023 03:58:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '88230' 11/10/2023 03:58: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 ( '88230' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 11/10/2023 04:21:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 04:21: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' , '3123' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '82.31' , NOW() , NOW() ) 11/10/2023 04:21: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 = '88231' 11/10/2023 04:21:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88231' 11/10/2023 04:21: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 ( '88231' , '16764' , 'AMPOLLE SU VASSOIO IN VETRO - 1521' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 11/10/2023 04:21: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 ( '88231' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '49.1' , '40.245901639344' , '22' , '0' , '49.10' ) 11/10/2023 04:21: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 ( '88231' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 11/10/2023 04:24:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3123' AND id_document != '88231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 04:24:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3123', document_date = '2023-10-11', 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 = '100.00', price_tax_excluded = '82.31', date_upd = NOW() WHERE id_document = '88231' 11/10/2023 04:24:20 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 = '88231' 11/10/2023 04:24:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '88231' 11/10/2023 04:24:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 11/10/2023 04:24:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '49.1000' , '40.245901639344' , '22' , '0' , '49.10' ) 11/10/2023 04:24:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 11/10/2023 04:29:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 04:29:45 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' , '3124' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.30' , '15.82' , NOW() , NOW() ) 11/10/2023 04:29:45 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 = '88232' 11/10/2023 04:29:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '88232' 11/10/2023 04:29: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 ( '88232' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 11/10/2023 04:29: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 ( '88232' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 11/10/2023 04:48:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 04:48: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' , '3125' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.15' , '27.15' , NOW() , NOW() ) 11/10/2023 04:48: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 = '88233' 11/10/2023 04:48:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88233' 11/10/2023 04:48: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 ( '88233' , '21645' , 'LAUDATE DEUM' , '15' , '-15' , '4' , '1.90' , '1.9' , '0' , '5' , '27.15' ) 11/10/2023 05:31:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 05:31:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '46/E' , '2023-10-11' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '20' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '627.60' , '627.60' , NOW() , NOW() ) 11/10/2023 05:31:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88234' 11/10/2023 05:31:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '88234' 11/10/2023 05:31:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88234' , '5457' , 'IO SONO CON VOI 1 PARTE' , '350' , '-350' , '4' , '2.80' , '2.8' , '0' , '38' , '607.60' ) 11/10/2023 05:31:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/E' AND id_document != '88234' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 05:31:51 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '46/E', document_date = '2023-10-11', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '20.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '627.60', price_tax_excluded = '627.60', date_upd = NOW() WHERE id_document = '88234' 11/10/2023 05:31:51 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 = '88234' 11/10/2023 05:31:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88234' 11/10/2023 05:31:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88234' , '5457' , 'IO SONO CON VOI 1 PARTE' , '350' , '-350' , '4' , '2.8000' , '2.8' , '0' , '38' , '607.60' ) 11/10/2023 05:40:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 05:40:38 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' , '3126' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.58' , '32.58' , NOW() , NOW() ) 11/10/2023 05:40:38 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 = '88235' 11/10/2023 05:40:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88235' 11/10/2023 05:40:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88235' , '21645' , 'LAUDATE DEUM' , '18' , '-18' , '4' , '1.90' , '1.9' , '0' , '5' , '32.58' ) 11/10/2023 05:41:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '98/A' AND id_document != '87553' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-03') 11/10/2023 05:41:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '98/A', document_date = '2023-10-03', document_letter = 'A', id_customer = '232', id_supplier = '', id_address = '4671450', address1 = 'VIA V. LASPRO, 8/A 84126 SALERNO', 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 = '71.92', price_tax_excluded = '71.92', date_upd = NOW() WHERE id_document = '87553' 11/10/2023 05:41:22 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 = '87553' 11/10/2023 05:41:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '87553' 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '4' , '1.0000' , '1' , '0' , '15' , '3.40' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '-4' , '4' , '3.4000' , '3.4' , '0' , '15' , '11.56' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '2679' , 'CONOSCERE GESU' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 11/10/2023 05:41:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87553' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 11/10/2023 05:42:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 05:42:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3127' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 11/10/2023 05:42:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88236' 11/10/2023 05:42:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '88236' 11/10/2023 05:42:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88236' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 11/10/2023 06:16:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 06:16:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3128' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.25' , '90.25' , NOW() , NOW() ) 11/10/2023 06:16:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88237' 11/10/2023 06:16:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88237' 11/10/2023 06:16:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88237' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 11/10/2023 06:16:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88237' , '12104' , 'MINISTERO ORDINATO - E. CASTELLUCCI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 11/10/2023 06:16:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88237' , '21657' , 'MATRIMONIO - M. ALIOTTA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 11/10/2023 06:16:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88237' , '20188' , 'PENITENZA E UNZIONE DEI MALATI - A. MAFFEIS' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 11/10/2023 06:21:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 06:21:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3129' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.98' , '7.98' , NOW() , NOW() ) 11/10/2023 06:21: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 = '88238' 11/10/2023 06:21:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88238' 11/10/2023 06:21: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 ( '88238' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 11/10/2023 06:21: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 ( '88238' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/10/2023 06:28:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 11/10/2023 06:28: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' , '3130' , '2023-10-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.20' , '34.20' , NOW() , NOW() ) 11/10/2023 06:28: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 = '88239' 11/10/2023 06:28:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88239' 11/10/2023 06:28: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 ( '88239' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 11/10/2023 06:28: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 ( '88239' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' )