18/10/2023 09:21:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:21:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3203' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '83.61' , NOW() , NOW() ) 18/10/2023 09:21:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88351' 18/10/2023 09:21:44 am >> DELETE FROM ps_document_detail WHERE id_document = '88351' 18/10/2023 09:21: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 ( '88351' , '11389' , 'VINO ROSSO DOLCE - 103' , '12' , '-12' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '102.00' ) 18/10/2023 09:28:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:28:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3204' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.52' , '5.52' , NOW() , NOW() ) 18/10/2023 09:28:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88352' 18/10/2023 09:28:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88352' 18/10/2023 09:28:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88352' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 18/10/2023 09:28:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88352' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 18/10/2023 09:40:39 am >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:40:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '170' , '2023-10-18' , '' , '1235' , '0' , '4672075' , 'P. ZZA SAN MARCO - CURTERI 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.89' , '108.89' , NOW() , NOW() ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88353' 18/10/2023 09:40:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88353' 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '-11' , '4' , '2.40' , '2.4' , '0' , '15' , '22.44' ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.80' , '2.8' , '0' , '15' , '40.46' ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 18/10/2023 09:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88353' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '15' , '23.80' ) 18/10/2023 09:56:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3205' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:56: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' , '3205' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 18/10/2023 09:56: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 = '88354' 18/10/2023 09:56:43 am >> DELETE FROM ps_document_detail WHERE id_document = '88354' 18/10/2023 09:56: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 ( '88354' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 18/10/2023 09:57:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:57:33 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' , '3206' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.08' , '8.08' , NOW() , NOW() ) 18/10/2023 09:57:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88355' 18/10/2023 09:57:33 am >> DELETE FROM ps_document_detail WHERE id_document = '88355' 18/10/2023 09:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88355' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 18/10/2023 09:57:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88355' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 18/10/2023 09:58:58 am >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '88353' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 09:58:58 am >> UPDATE ps_document SET id_document_type = '21', document_num = '170', document_date = '2023-10-18', document_letter = '', id_customer = '1235', id_supplier = '', id_address = '4672075', address1 = 'P. ZZA SAN MARCO - CURTERI 84085 MERCATO S. SEVERINO', 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 = '108.89', price_tax_excluded = '108.89', date_upd = NOW() WHERE id_document = '88353' 18/10/2023 09:58:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88353' 18/10/2023 09:58:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88353' 18/10/2023 09:58: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 ( '88353' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '-11' , '4' , '2.4000' , '2.4' , '0' , '15' , '22.44' ) 18/10/2023 09:58: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 ( '88353' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 18/10/2023 09:58: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 ( '88353' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.8000' , '2.8' , '0' , '15' , '40.46' ) 18/10/2023 09:58: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 ( '88353' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 18/10/2023 09:58: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 ( '88353' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 18/10/2023 09:58: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 ( '88353' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 18/10/2023 10:19:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 10:19:25 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' , '3207' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/10/2023 10:19:25 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 = '88356' 18/10/2023 10:19:25 am >> DELETE FROM ps_document_detail WHERE id_document = '88356' 18/10/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88356' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/10/2023 10:20:23 am >> SELECT document_num FROM ps_document WHERE document_num = '48/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 10:20:23 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 ( '23' , '48/E' , '2023-10-18' , 'E' , '3546' , '0' , '4671004' , 'VIA TORQUATO TASSO, 10 24020 GORLE ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 18/10/2023 10:20:23 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 = '88357' 18/10/2023 10:20:23 am >> DELETE FROM ps_document_detail WHERE id_document = '88357' 18/10/2023 10:20:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88357' , '12819' , 'REGISTRO DEL CATECHISTA ' , '200' , '-200' , '1' , '1.00' , '0.81967213114754' , '22' , '40' , '120.00' ) 18/10/2023 10:45:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 10:45:36 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' , '3208' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '65.65' , NOW() , NOW() ) 18/10/2023 10:45:36 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 = '88358' 18/10/2023 10:45:36 am >> DELETE FROM ps_document_detail WHERE id_document = '88358' 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '2' , '-2' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '5.80' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.40' , '2.4' , '0' , '5' , '2.28' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '0' , '5.00' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.38' , '2.38' , '0' , '0' , '2.38' ) 18/10/2023 10:45:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/10/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/10/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 18/10/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20706' , 'ANGELO PENDENTE - AM' , '1' , '-1' , '1' , '13.80' , '11.311475409836' , '22' , '0' , '13.80' ) 18/10/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/10/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88358' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 18/10/2023 11:02:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 11:02:49 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' , '3209' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '34.43' , NOW() , NOW() ) 18/10/2023 11:02:49 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 = '88359' 18/10/2023 11:02:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88359' 18/10/2023 11:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88359' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 18/10/2023 11:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88359' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 18/10/2023 11:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88359' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/10/2023 11:02:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 11:02:58 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' , '3210' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 18/10/2023 11:02:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88360' 18/10/2023 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88360' 18/10/2023 11:02: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 ( '88360' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 18/10/2023 11:16:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 11:16: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' , '3211' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 18/10/2023 11:16: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 = '88361' 18/10/2023 11:16:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88361' 18/10/2023 11:16: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 ( '88361' , '6356' , 'MEDAGLIA S.CUORE- MAD. CARMINE' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 18/10/2023 11:21:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 11:21:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3212' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 18/10/2023 11:21:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88362' 18/10/2023 11:21:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88362' 18/10/2023 11:21:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88362' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 18/10/2023 11:43:11 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3134' 18/10/2023 11:43:11 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 ( '3134' , '10' , '154' , 'PARROCCHIA MARIA SS. DELLA CATENA' , 'LO GRASSO' , 'DON ANTONINO' , 'VIA MICHELANGELO 2' , '' , '94013' , 'LEONFORTE' , '' , '0935901388' , '' , '' , '91005260863' , NOW() , NOW() ) 18/10/2023 11:43:11 am >> UPDATE ps_customer SET email = 'antoninolograsso@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3134' 18/10/2023 11:52:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 11:52:09 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' , '3213' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.75' , '15.75' , NOW() , NOW() ) 18/10/2023 11:52: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 = '88363' 18/10/2023 11:52:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88363' 18/10/2023 11:52:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88363' , '2679' , 'CONOSCERE GESU' , '5' , '-5' , '4' , '3.15' , '3.15' , '0' , '0' , '15.75' ) 18/10/2023 12:06:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 12:06:30 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' , '3214' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.66' , '92.80' , NOW() , NOW() ) 18/10/2023 12:06:30 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 = '88364' 18/10/2023 12:06:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88364' 18/10/2023 12:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88364' , '5444' , 'IO SONO CON VOI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.15' ) 18/10/2023 12:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88364' , '11193' , 'VENITE CON ME CAT.' , '12' , '-12' , '4' , '5.50' , '5.5' , '0' , '5' , '62.76' ) 18/10/2023 12:06: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 ( '88364' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '4.75' ) 18/10/2023 12:06:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '171' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 12:06:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '171' , '2023-10-18' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '190.83' , '190.83' , NOW() , NOW() ) 18/10/2023 12:06:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88365' 18/10/2023 12:06:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '88365' 18/10/2023 12:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '15' , '32.73' ) 18/10/2023 12:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 18/10/2023 12:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '5458' , 'IO SONO CON VOI 2 PARTE' , '17' , '-17' , '4' , '2.80' , '2.8' , '0' , '15' , '40.46' ) 18/10/2023 12:06:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.80' , '2.8' , '0' , '15' , '33.32' ) 18/10/2023 12:06:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 18/10/2023 12:06:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '-11' , '4' , '2.40' , '2.4' , '0' , '15' , '22.44' ) 18/10/2023 12:06:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88365' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '15' , '28.56' ) 18/10/2023 12:10:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '172' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 12:10:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '172' , '2023-10-18' , '' , '1127' , '0' , '4672060' , 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '77.69' , '77.69' , NOW() , NOW() ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88366' 18/10/2023 12:10:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '88366' 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '15' , '14.28' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '11191' , 'VENITE CON ME 1 PARTE' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '15' , '7.14' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '-6' , '4' , '2.40' , '2.4' , '0' , '15' , '12.24' ) 18/10/2023 12:10:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '15' , '14.28' ) 18/10/2023 12:10:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 12:10:22 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' , '3215' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.61' , '36.61' , NOW() , NOW() ) 18/10/2023 12:10: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 = '88367' 18/10/2023 12:10:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88367' 18/10/2023 12:10: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 ( '88367' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.50' , '5.5' , '0' , '5' , '20.92' ) 18/10/2023 12:10: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 ( '88367' , '11193' , 'VENITE CON ME CAT.' , '3' , '-3' , '4' , '5.50' , '5.5' , '0' , '5' , '15.69' ) 18/10/2023 12:34:42 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/10/2023 12:34:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21682' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 12:34:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21682' , '1' , '1' , '2' , NOW() , NOW() ) 18/10/2023 12:34:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21682' , '0' , '1' , '0' , '0' ) 18/10/2023 12:43:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851427306' AND id_product != '21682' AND ean13 != '' 18/10/2023 12:43:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788851427306', date_upd = NOW() WHERE id_product = '21682' 18/10/2023 12:43:02 pm >> UPDATE ps_product_lang SET name = 'ORDO VIRGINUM', description = '' WHERE id_product = '21682' 18/10/2023 12:43:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21682' 18/10/2023 12:43:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21682' 18/10/2023 12:43:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '21682' 18/10/2023 12:43:44 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 = '21682' 18/10/2023 12:43:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21683' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 12:43:44 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 '21683' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21682' 18/10/2023 12:43:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21683' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21682' 18/10/2023 12:44:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851427603' AND id_product != '21683' AND ean13 != '' 18/10/2023 12:44:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788851427603', date_upd = NOW() WHERE id_product = '21683' 18/10/2023 12:44:45 pm >> UPDATE ps_product_lang SET name = 'DIO CHE SI RIVELA IN GESU\' CRISTO - P. BRAMBILLA', description = '' WHERE id_product = '21683' 18/10/2023 12:44:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '21683' 18/10/2023 12:44:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '98', 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 = '21683' 18/10/2023 12:44:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '21683' 18/10/2023 12:45:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '230374' , '2023-10-16' , '' , '0' , '119' , '4669226' , 'VIA B. CRESPI, 30 20159 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '82.40' , '82.40' , NOW() , NOW() ) 18/10/2023 12:45:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88368' 18/10/2023 12:45:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '88368' 18/10/2023 12:45:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88368' , '21682' , 'ORDO VIRGINUM' , '6' , '6' , '4' , '14.00' , '14' , '0' , '38' , '52.0800' ) 18/10/2023 12:45:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21682' AND id_supplier = '119' 18/10/2023 12:45:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21682' , '119' , '1' ) 18/10/2023 12:45:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88368' , '21683' , 'DIO CHE SI RIVELA IN GESU CRISTO - P. BRAMBILLA' , '1' , '1' , '4' , '24.00' , '24' , '0' , '38' , '14.8800' ) 18/10/2023 12:45:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21683' AND id_supplier = '119' 18/10/2023 12:45:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21683' , '119' , '1' ) 18/10/2023 12:46:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88368' , '18115' , 'BIBBIA GIOVANE' , '1' , '1' , '4' , '24.90' , '24.9' , '0' , '38' , '15.4380' ) 18/10/2023 12:46:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18115' AND id_supplier = '119' 18/10/2023 12:46:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18115' , '119' , '1' ) 18/10/2023 12:48:08 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/10/2023 12:48:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21684' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 12:48:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21684' , '1' , '1' , '2' , NOW() , NOW() ) 18/10/2023 12:48:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21684' , '0' , '1' , '0' , '0' ) 18/10/2023 12:48:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608426' AND id_product != '21684' AND ean13 != '' 18/10/2023 12:48:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788826608426', date_upd = NOW() WHERE id_product = '21684' 18/10/2023 12:48:46 pm >> UPDATE ps_product_lang SET name = 'C\'EST LA CONFIANCE ', description = '' WHERE id_product = '21684' 18/10/2023 12:48:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '21684' 18/10/2023 12:48:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21684' 18/10/2023 12:48:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '21684' 18/10/2023 12:48:48 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 = '21684' 18/10/2023 12:48:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21685' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 12:48:48 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 '21685' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21684' 18/10/2023 12:48:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21685' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21684' 18/10/2023 12:51:09 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' , '3014' , '2023-10-17' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '493.05' , '493.05' , NOW() , NOW() ) 18/10/2023 12:51:09 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 = '88369' 18/10/2023 12:51:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88369' 18/10/2023 12:51: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 ( '88369' , '21684' , 'CEST LA CONFIANCE ' , '50' , '50' , '4' , '1.90' , '1.9' , '0' , '45' , '52.2500' ) 18/10/2023 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21684' AND id_supplier = '79' 18/10/2023 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21684' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '2' , '4' , '25.00' , '25' , '0' , '35' , '32.5000' ) 18/10/2023 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 18/10/2023 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '45' , '5.5000' ) 18/10/2023 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 18/10/2023 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 18/10/2023 12:51:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 18/10/2023 12:51:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 18/10/2023 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 18/10/2023 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '4' , '4' , '6.00' , '6' , '0' , '30' , '16.8000' ) 18/10/2023 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 18/10/2023 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '1' , '4' , '150.00' , '150' , '0' , '35' , '97.5000' ) 18/10/2023 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5757' AND id_supplier = '79' 18/10/2023 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5757' , '79' , '1' ) 18/10/2023 12:51: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 ( '88369' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '1' , '4' , '250.00' , '250' , '0' , '35' , '162.5000' ) 18/10/2023 12:51:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5754' AND id_supplier = '79' 18/10/2023 12:51:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5754' , '79' , '1' ) 18/10/2023 12:53:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3115' AND id_document != '88220' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 18/10/2023 12:53:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3115', 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 = '68.30', price_tax_excluded = '68.30', date_upd = NOW() WHERE id_document = '88220' 18/10/2023 12:53:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88220' 18/10/2023 12:53:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88220' 18/10/2023 12:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88220' , '21645' , 'LAUDATE DEUM' , '4' , '-4' , '4' , '1.9000' , '1.9' , '0' , '0' , '7.60' ) 18/10/2023 12:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88220' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 18/10/2023 12:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88220' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 18/10/2023 12:53:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88220' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '32.2' , '32.2' , '0' , '0' , '32.20' ) 18/10/2023 12:59:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 12:59: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' , '3216' , '2023-10-18' , '' , '0' , '0' , '0' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '349.50' , '349.50' , NOW() , NOW() ) 18/10/2023 12:59: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 = '88370' 18/10/2023 12:59:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88370' 18/10/2023 12:59: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 ( '88370' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '5' , '95.00' ) 18/10/2023 12:59: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 ( '88370' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 18/10/2023 12:59: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 ( '88370' , '11193' , 'VENITE CON ME CAT.' , '20' , '-20' , '4' , '5.5000' , '5.5' , '0' , '5' , '104.50' ) 18/10/2023 01:00:00 pm >> DELETE FROM ps_document WHERE id_document = '88312' 18/10/2023 01:00:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '88312' 18/10/2023 02:10:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 02:10:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '173' , '2023-10-18' , '' , '1429' , '0' , '4679117' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '250.00' , NOW() , NOW() ) 18/10/2023 02:10:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88371' 18/10/2023 02:10:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88371' 18/10/2023 02:10:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88371' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '-1' , '4' , '250.00' , '250' , '0' , '0' , '250.00' ) 18/10/2023 02:10:38 pm >> DELETE FROM ps_document WHERE id_document = '88371' 18/10/2023 02:10:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88371' 18/10/2023 02:11:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 02:11:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '109/A' , '2023-10-18' , 'A' , '1429' , '0' , '4679117' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '250.00' , '250.00' , NOW() , NOW() ) 18/10/2023 02:11:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88372' 18/10/2023 02:11:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '88372' 18/10/2023 02:11:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88372' , '5754' , 'LEZIONARI KIT CELEBRAZIONE DEI SANTI' , '1' , '-1' , '4' , '250.00' , '250' , '0' , '0' , '250.00' ) 18/10/2023 02:19:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'ART.18' AND id_product != '21685' AND ean13 != '' 18/10/2023 02:19:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'ART.18', date_upd = NOW() WHERE id_product = '21685' 18/10/2023 02:19:28 pm >> UPDATE ps_product_lang SET name = 'STELLARIO CM 30 - ART.18', description = '' WHERE id_product = '21685' 18/10/2023 02:19:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '77.04918032786885' WHERE id_product = '21685' 18/10/2023 02:19:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '77.04918032786885', id_tax_rules_group = '1', id_category_default = '424', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21685' 18/10/2023 02:19:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '21685' 18/10/2023 02:19:31 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 = '21685' 18/10/2023 02:19:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21686' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 02:19:32 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 '21686' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21685' 18/10/2023 02:19:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21686' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21685' 18/10/2023 02:19:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'ART. 19' AND id_product != '21686' AND ean13 != '' 18/10/2023 02:19:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'ART. 19', date_upd = NOW() WHERE id_product = '21686' 18/10/2023 02:19:55 pm >> UPDATE ps_product_lang SET name = 'STELLARIO CM 30 - ART.19', description = '' WHERE id_product = '21686' 18/10/2023 02:19:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '68.85245901639344' WHERE id_product = '21686' 18/10/2023 02:19:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '68.85245901639344', id_tax_rules_group = '1', id_category_default = '424', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21686' 18/10/2023 02:19:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '21686' 18/10/2023 02:19:56 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 = '21686' 18/10/2023 02:19:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21687' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 02:19:56 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 '21687' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21686' 18/10/2023 02:19:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21687' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21686' 18/10/2023 02:20:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '2/250' AND id_product != '21687' AND ean13 != '' 18/10/2023 02:20:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '2/250', date_upd = NOW() WHERE id_product = '21687' 18/10/2023 02:20:44 pm >> UPDATE ps_product_lang SET name = 'PORTA RELIQUIE - 2/250', description = '' WHERE id_product = '21687' 18/10/2023 02:20:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '21687' 18/10/2023 02:20:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '424', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21687' 18/10/2023 02:20:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '21687' 18/10/2023 02:20:45 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 = '21687' 18/10/2023 02:20:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21688' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 02:20:45 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 '21688' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21687' 18/10/2023 02:20:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21688' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21687' 18/10/2023 02:21:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'ART.19' AND id_product != '21686' AND ean13 != '' 18/10/2023 02:21:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'ART.19', date_upd = NOW() WHERE id_product = '21686' 18/10/2023 02:21:16 pm >> UPDATE ps_product_lang SET name = 'STELLARIO CM 30 - ART.19', description = '' WHERE id_product = '21686' 18/10/2023 02:21:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '68.8525' WHERE id_product = '21686' 18/10/2023 02:21:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '68.8525', id_tax_rules_group = '1', id_category_default = '424', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21686' 18/10/2023 02:21:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '21686' 18/10/2023 02:22: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 ( '31' , '265/A' , '2023-10-17' , 'A' , '0' , '116' , '4669160' , 'VIA SAN DOMENICO snc 80044 OTTAVIANO' , '' , '' , '10.00' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '116.67' , '95.64' , NOW() , NOW() ) 18/10/2023 02:22: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 = '88373' 18/10/2023 02:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88373' 18/10/2023 02:22: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 ( '88373' , '21685' , 'STELLARIO CM 30 - ART.18' , '1' , '1' , '1' , '79.2' , '64.918032786885' , '22' , '45' , '53.1432' ) 18/10/2023 02:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21685' AND id_supplier = '116' 18/10/2023 02:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21685' , '116' , '1' ) 18/10/2023 02:22: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 ( '88373' , '21686' , 'STELLARIO CM 30 - ART.19' , '1' , '1' , '1' , '66' , '54.098360655738' , '22' , '45' , '44.2860' ) 18/10/2023 02:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21686' AND id_supplier = '116' 18/10/2023 02:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21686' , '116' , '1' ) 18/10/2023 02:22: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 ( '88373' , '21687' , 'PORTA RELIQUIE - 2/250' , '1' , '1' , '1' , '10.5' , '8.6065573770492' , '22' , '45' , '7.0455' ) 18/10/2023 02:22:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21687' AND id_supplier = '116' 18/10/2023 02:22:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21687' , '116' , '1' ) 18/10/2023 02:25:05 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 18/10/2023 02:25:05 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '181' , '1' ) 18/10/2023 02:25:05 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '181' , '1' ) 18/10/2023 02:25:05 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '181' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 18/10/2023 02:26:47 pm >> UPDATE ps_address SET id_state = '232', lastname = 'EDIZIONI FDIF SRLS', address1 = 'PODERE PISCINO 1', address2 = '', postcode = '01020', dni = '', vat_number = '02257100566', city = 'PROCENO', phone = '', phone_mobile = '335457464', date_upd = NOW() WHERE id_supplier = '181' 18/10/2023 02:26:47 pm >> UPDATE ps_supplier SET email = 'edizionifdif@virgilio.it', name = 'EDIZIONI FDIF SRLS', date_upd = NOW() WHERE id_supplier = '181' 18/10/2023 02:26:48 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '181' 18/10/2023 02:27:21 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 18/10/2023 02:27:21 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '525' , '1' ) 18/10/2023 02:27:21 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '525' , '2' ) 18/10/2023 02:27:21 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '525' , '3' ) 18/10/2023 02:27:22 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '525' , '1' , 'EDIZIONI FDIF' , LOWER('EDIZIONI-FDIF') ) 18/10/2023 02:27:22 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '525' , '1' , '0' ) 18/10/2023 02:52:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 02:52: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' , '173' , '2023-10-18' , '' , '3134' , '0' , '4679140' , 'VIA MICHELANGELO 2 94013 LEONFORTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '275.82' , '275.82' , NOW() , NOW() ) 18/10/2023 02:52: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 = '88374' 18/10/2023 02:52:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '88374' 18/10/2023 02:52: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 ( '88374' , '5444' , 'IO SONO CON VOI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '10' , '24.75' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '5457' , 'IO SONO CON VOI 1 PARTE' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '5458' , 'IO SONO CON VOI 2 PARTE' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '11193' , 'VENITE CON ME CAT.' , '8' , '-8' , '4' , '5.50' , '5.5' , '0' , '10' , '39.60' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.80' , '2.8' , '0' , '15' , '33.32' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '11192' , 'VENITE CON ME 2 PARTE' , '14' , '-14' , '4' , '2.80' , '2.8' , '0' , '15' , '33.32' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '8' , '-8' , '4' , '5.50' , '5.5' , '0' , '10' , '39.60' ) 18/10/2023 02:52:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88374' , '9675' , 'SARETE MIEI TESTIMONI' , '18' , '-18' , '4' , '3.50' , '3.5' , '0' , '15' , '53.55' ) 18/10/2023 03:05:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 03:05:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3217' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.43' , '5.43' , NOW() , NOW() ) 18/10/2023 03:05:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88375' 18/10/2023 03:05:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '88375' 18/10/2023 03:05:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88375' , '21645' , 'LAUDATE DEUM' , '3' , '-3' , '4' , '1.90' , '1.9' , '0' , '5' , '5.43' ) 18/10/2023 03:11:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 03:11: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' , '3218' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.73' , '78.95' , NOW() , NOW() ) 18/10/2023 03:11: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 = '88376' 18/10/2023 03:11:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '88376' 18/10/2023 03:11: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 ( '88376' , '21556' , 'CAPOCULLA SMALTATO ROSA' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 18/10/2023 03:11: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 ( '88376' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 18/10/2023 03:11: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 ( '88376' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '6.8' , '6.8' , '0' , '0' , '6.80' ) 18/10/2023 03:11: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 ( '88376' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.15' , '2.15' , '0' , '0' , '2.15' ) 18/10/2023 03:11: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 ( '88376' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 18/10/2023 03:11: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 ( '88376' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/10/2023 03:14:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 03:14:34 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' , '3219' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.40' , '13.79' , NOW() , NOW() ) 18/10/2023 03:14:34 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 = '88377' 18/10/2023 03:14:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '88377' 18/10/2023 03:14:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88377' , '17287' , 'CAPOCULLA 7X9' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 18/10/2023 03:14:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88377' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 18/10/2023 03:15:16 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') 18/10/2023 03:15:16 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 = '98.43', price_tax_excluded = '98.43', date_upd = NOW() WHERE id_document = '87553' 18/10/2023 03:15:16 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' 18/10/2023 03:15:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '87553' 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' , '7' , '-7' , '4' , '3.4000' , '3.4' , '0' , '15' , '20.23' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' ) 18/10/2023 03:15:16 pm >> INSERT INTO ps_document_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' ) 18/10/2023 03:36:30 pm >> 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') 18/10/2023 03:36:30 pm >> 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 = '63.20', price_tax_excluded = '63.20', date_upd = NOW() WHERE id_document = '81317' 18/10/2023 03:36:30 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 = '81317' 18/10/2023 03:36:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 18/10/2023 03:36: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 ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/10/2023 03:36: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 ( '81317' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 18/10/2023 03:36: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 ( '81317' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 18/10/2023 03:36: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 ( '81317' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/10/2023 03:36: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 ( '81317' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/10/2023 03:36: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 ( '81317' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 18/10/2023 03:47:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '172' AND id_document != '88366' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 03:47:21 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '172', document_date = '2023-10-18', document_letter = '', id_customer = '1127', id_supplier = '', id_address = '4672060', address1 = 'VIA CAMPOMANFOLI 84083 CASTEL S. GIORGIO', 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 = '77.69', price_tax_excluded = '77.69', date_upd = NOW() WHERE id_document = '88366' 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88366' 18/10/2023 03:47:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88366' 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '2679' , 'CONOSCERE GESU\'' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '15' , '14.28' ) 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '11191' , 'VENITE CON ME 1 PARTE' , '3' , '-3' , '4' , '2.8000' , '2.8' , '0' , '15' , '7.14' ) 18/10/2023 03:47:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88366' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '15' , '11.90' ) 18/10/2023 03:47: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 ( '88366' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '-6' , '4' , '2.4000' , '2.4' , '0' , '15' , '12.24' ) 18/10/2023 03:47: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 ( '88366' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '15' , '14.28' ) 18/10/2023 04:13:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 04:13:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3220' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 18/10/2023 04:13:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88378' 18/10/2023 04:13:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88378' 18/10/2023 04:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88378' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 18/10/2023 04:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88378' , '20515' , 'DECINA ULIVO - 04/7-D' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 18/10/2023 05:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 05:21:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '174' , '2023-10-18' , '' , '284' , '0' , '4671723' , 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '402.65' , '402.65' , NOW() , NOW() ) 18/10/2023 05:21: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 = '88379' 18/10/2023 05:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '88379' 18/10/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88379' , '5458' , 'IO SONO CON VOI 2 PARTE' , '80' , '-80' , '4' , '2.80' , '2.8' , '0' , '15' , '190.40' ) 18/10/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88379' , '11192' , 'VENITE CON ME 2 PARTE' , '80' , '-80' , '4' , '2.80' , '2.8' , '0' , '15' , '190.40' ) 18/10/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88379' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/10/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88379' , '21679' , 'LAUDATE DEUM - 8583' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '5' , '4.75' ) 18/10/2023 05:27:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 05:27:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3221' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.45' , '142.77' , NOW() , NOW() ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88380' 18/10/2023 05:27:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '88380' 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '19540' , 'CRESIMA N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 18/10/2023 05:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88380' , '17617' , 'IMMAGINI ISONZO X 100' , '9' , '-9' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '31.50' ) 18/10/2023 05:47:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 05:47:49 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' , '3222' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '20.33' , NOW() , NOW() ) 18/10/2023 05:47:49 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 = '88381' 18/10/2023 05:47:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '88381' 18/10/2023 05:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88381' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 18/10/2023 05:47:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88381' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 18/10/2023 06:12:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2879' AND id_document != '87370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 18/10/2023 06:12:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2879', document_date = '2023-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '75.48', date_upd = NOW() WHERE id_document = '87370' 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87370' 18/10/2023 06:12:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87370' 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '30.00' ) 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '21511' , 'INSTRUMENTUM LABORIS - SINODO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '20678' , 'SINODALITA - C. MILITELLO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '8855' , 'REGISTRO DEL CATECHISTA' , '1' , '-1' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '0.75' ) 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 18/10/2023 06:12:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '19779' , 'ANELLO CROCE/CUORE' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 18/10/2023 07:02:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 07:02: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' , '3223' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.48' , NOW() , NOW() ) 18/10/2023 07:02: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 = '88382' 18/10/2023 07:02:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88382' 18/10/2023 07:02: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 ( '88382' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 18/10/2023 07:02:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88382' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 18/10/2023 07:05:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 07:05:17 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' , '3224' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 18/10/2023 07:05: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 = '88383' 18/10/2023 07:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88383' 18/10/2023 07:05: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 ( '88383' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 18/10/2023 07:06:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3225' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-18') 18/10/2023 07:06: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' , '3225' , '2023-10-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 18/10/2023 07:06: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 = '88384' 18/10/2023 07:06:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '88384' 18/10/2023 07:06: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 ( '88384' , '21564' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 18/10/2023 07:13:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002184' AND id_product != '21688' AND ean13 != '' 18/10/2023 07:13:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002184', date_upd = NOW() WHERE id_product = '21688' 18/10/2023 07:13:34 pm >> UPDATE ps_product_lang SET name = 'ANGELO PIEGHEVOLE CM 15', description = '' WHERE id_product = '21688' 18/10/2023 07:13:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '21688' 18/10/2023 07:13:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21688' 18/10/2023 07:13:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '21688' 18/10/2023 07:15:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002184' AND id_product != '21688' AND ean13 != '' 18/10/2023 07:15:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002184', date_upd = NOW() WHERE id_product = '21688' 18/10/2023 07:15:16 pm >> UPDATE ps_product_lang SET name = 'ANGELO PIEGHEVOLE CM 15', description = '' WHERE id_product = '21688' 18/10/2023 07:15:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '21688' 18/10/2023 07:15:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21688' 18/10/2023 07:15:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '21688' 18/10/2023 07:15:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21688' 18/10/2023 07:15:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21689' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 07:15:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21689' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21688' 18/10/2023 07:15:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21689' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21688' 18/10/2023 07:15:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002185' AND id_product != '21689' AND ean13 != '' 18/10/2023 07:15:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002185', date_upd = NOW() WHERE id_product = '21689' 18/10/2023 07:15:49 pm >> UPDATE ps_product_lang SET name = 'ANGELO PIEGHEVOLE CM 12', description = '' WHERE id_product = '21689' 18/10/2023 07:15:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '21689' 18/10/2023 07:15:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21689' 18/10/2023 07:15:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '21689' 18/10/2023 07:15:51 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 = '21689' 18/10/2023 07:15:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21690' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 07:15:51 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 '21690' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21689' 18/10/2023 07:15:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21690' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21689' 18/10/2023 07:17:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002186' AND id_product != '21690' AND ean13 != '' 18/10/2023 07:17:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002186', date_upd = NOW() WHERE id_product = '21690' 18/10/2023 07:17:43 pm >> UPDATE ps_product_lang SET name = 'PRESEPE 12X15', description = '' WHERE id_product = '21690' 18/10/2023 07:17:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.245901639344263' WHERE id_product = '21690' 18/10/2023 07:17:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21690' 18/10/2023 07:17:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '21690' 18/10/2023 07:19:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21690' 18/10/2023 07:19:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21691' , '1' , '' , 'nuovo-prodotto' ) 18/10/2023 07:19:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21691' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21690' 18/10/2023 07:19:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21691' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21690' 18/10/2023 07:19:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002187' AND id_product != '21691' AND ean13 != '' 18/10/2023 07:19:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002187', date_upd = NOW() WHERE id_product = '21691' 18/10/2023 07:19:56 pm >> UPDATE ps_product_lang SET name = 'PENDENTE FF 10X11', description = '' WHERE id_product = '21691' 18/10/2023 07:19:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '21691' 18/10/2023 07:19:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21691' 18/10/2023 07:19:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '21691' 18/10/2023 07:25: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 ( '31' , '614/2023' , '2023-10-18' , '2023' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '398.33' , '326.50' , NOW() , NOW() ) 18/10/2023 07:25: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 = '88385' 18/10/2023 07:25:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88385' 18/10/2023 07:25: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 ( '88385' , '21689' , 'ANGELO PIEGHEVOLE CM 12' , '25' , '25' , '1' , '8' , '6.5573770491803' , '22' , '50' , '122.0000' ) 18/10/2023 07:25:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21689' AND id_supplier = '50' 18/10/2023 07:25:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21689' , '50' , '1' ) 18/10/2023 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88385' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '25' , '25' , '1' , '9' , '7.3770491803279' , '22' , '50' , '137.2500' ) 18/10/2023 07:25:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21688' AND id_supplier = '50' 18/10/2023 07:25:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21688' , '50' , '1' ) 18/10/2023 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88385' , '21690' , 'PRESEPE 12X15' , '12' , '12' , '1' , '10' , '8.1967213114754' , '22' , '50' , '73.2000' ) 18/10/2023 07:25:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21690' AND id_supplier = '50' 18/10/2023 07:25:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21690' , '50' , '1' ) 18/10/2023 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88385' , '20705' , 'CANDELA CUBO' , '4' , '4' , '1' , '11' , '9.016393442623' , '22' , '50' , '26.8400' ) 18/10/2023 07:25:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20705' AND id_supplier = '50' 18/10/2023 07:25:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20705' , '50' , '1' ) 18/10/2023 07:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88385' , '21691' , 'PENDENTE FF 10X11' , '8' , '8' , '1' , '8' , '6.5573770491803' , '22' , '50' , '39.0400' ) 18/10/2023 07:25:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21691' AND id_supplier = '50' 18/10/2023 07:25:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21691' , '50' , '1' )