17/01/2024 08:28:40 am >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '89958' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-16') 17/01/2024 08:28:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '154', document_date = '2024-01-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '89958' 17/01/2024 08:28:40 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 = '89958' 17/01/2024 08:28:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89958' 17/01/2024 08:28:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89958' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/01/2024 09:21:40 am >> SELECT document_num FROM ps_document WHERE document_num = '163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 09:21:40 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' , '163' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.00' , '151.64' , NOW() , NOW() ) 17/01/2024 09:21:40 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 = '89969' 17/01/2024 09:21:40 am >> DELETE FROM ps_document_detail WHERE id_document = '89969' 17/01/2024 09:21:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89969' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '2' , '-2' , '1' , '39.9' , '32.704918032787' , '22' , '0' , '79.80' ) 17/01/2024 09:21:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89969' , '2233' , 'CLERGY F/F ML GRIGIO CHIARO - 44' , '2' , '-2' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '66.00' ) 17/01/2024 09:21:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89969' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '1' , '-1' , '1' , '39.2' , '32.131147540984' , '22' , '0' , '39.20' ) 17/01/2024 09:29:02 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2211' 17/01/2024 09:29:02 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '2211' 17/01/2024 09:46:35 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2232' 17/01/2024 09:46:35 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '2232' 17/01/2024 09:47:02 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2204' 17/01/2024 09:47:02 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '2204' 17/01/2024 10:16:55 am >> SELECT document_num FROM ps_document WHERE document_num = '164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 10:16:55 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' , '164' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '47.13' , NOW() , NOW() ) 17/01/2024 10:16:55 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 = '89970' 17/01/2024 10:16:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89970' 17/01/2024 10:16:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89970' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/01/2024 10:16:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89970' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 17/01/2024 10:26:09 am >> SELECT document_num FROM ps_document WHERE document_num = '165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 10:26: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' , '165' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 17/01/2024 10:26: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 = '89971' 17/01/2024 10:26:09 am >> DELETE FROM ps_document_detail WHERE id_document = '89971' 17/01/2024 10:26:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89971' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 17/01/2024 11:56:23 am >> SELECT document_num FROM ps_document WHERE document_num = '166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 11:56: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 ( '11' , '166' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 17/01/2024 11:56: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 = '89972' 17/01/2024 11:56:23 am >> DELETE FROM ps_document_detail WHERE id_document = '89972' 17/01/2024 11:56:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89972' , '5894' , 'LITURGIA DELLE ORE IV - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 17/01/2024 12:41:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 12:41: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' , '167' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 17/01/2024 12:41: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 = '89973' 17/01/2024 12:41:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89973' 17/01/2024 12:41: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 ( '89973' , '14936' , 'E NATO, ALBUM DA COLORARE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 17/01/2024 12:41: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 ( '89973' , '21701' , 'NASCITA DI GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 17/01/2024 12:58:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 12:58:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '168' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.10' , '94.10' , NOW() , NOW() ) 17/01/2024 12:58:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89974' 17/01/2024 12:58:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89974' 17/01/2024 12:58:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89974' , '1090' , 'BIBBIA' , '10' , '-10' , '4' , '9.90' , '9.9' , '0' , '5' , '94.10' ) 17/01/2024 03:15:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 03:15:26 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' , '169' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 17/01/2024 03:15: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 = '89975' 17/01/2024 03:15:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89975' 17/01/2024 03:15: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 ( '89975' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/01/2024 03:15: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 ( '89975' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/01/2024 03:26:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 03:26:29 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' , '170' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 17/01/2024 03:26:29 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 = '89976' 17/01/2024 03:26:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89976' 17/01/2024 03:26:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89976' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '5' , '17.10' ) 17/01/2024 04:07:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '171' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 04:07:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '171' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '37.02' , NOW() , NOW() ) 17/01/2024 04:07:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89977' 17/01/2024 04:07:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89977' 17/01/2024 04:07:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89977' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 17/01/2024 04:07:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89977' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 17/01/2024 04:09:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '172' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 04:09:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '172' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.03' , '38.54' , NOW() , NOW() ) 17/01/2024 04:09:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89978' 17/01/2024 04:09:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89978' 17/01/2024 04:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89978' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/01/2024 04:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89978' , '5823' , 'LIBRO DORO' , '30' , '-30' , '4' , '0.60' , '0.6' , '0' , '5' , '17.10' ) 17/01/2024 04:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89978' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 17/01/2024 04:09:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89978' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 17/01/2024 04:10:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '173' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 04:10:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '173' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 17/01/2024 04:10:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89979' 17/01/2024 04:10:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89979' 17/01/2024 04:10:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89979' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 17/01/2024 04:12:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 04:12:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '10/A' , '2024-01-17' , 'A' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '7' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '193.00' , '193.00' , NOW() , NOW() ) 17/01/2024 04:12:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89980' 17/01/2024 04:12:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89980' 17/01/2024 04:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89980' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '300' , '-300' , '4' , '1.00' , '1' , '0' , '38' , '186.00' ) 17/01/2024 04:24:07 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/01/2024 04:24:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22056' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:24:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22056' , '1' , '1' , '2' , NOW() , NOW() ) 17/01/2024 04:24:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22056' , '0' , '1' , '0' , '0' ) 17/01/2024 04:24:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577140' AND id_product != '22056' AND ean13 != '' 17/01/2024 04:24:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788873577140', date_upd = NOW() WHERE id_product = '22056' 17/01/2024 04:24:52 pm >> UPDATE ps_product_lang SET name = 'E IO VI RISTORERO\' - M. ZUPPI', description = '' WHERE id_product = '22056' 17/01/2024 04:24:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22056' 17/01/2024 04:24:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22056' 17/01/2024 04:24:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22056' 17/01/2024 04:24:54 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 = '22056' 17/01/2024 04:24:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22057' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:24:54 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 '22057' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22056' 17/01/2024 04:24:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22057' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22056' 17/01/2024 04:25:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577157' AND id_product != '22057' AND ean13 != '' 17/01/2024 04:25:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788873577157', date_upd = NOW() WHERE id_product = '22057' 17/01/2024 04:25:47 pm >> UPDATE ps_product_lang SET name = 'SEQUELA CHRISTI - C.M. MARTINI', description = '' WHERE id_product = '22057' 17/01/2024 04:25:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22057' 17/01/2024 04:25:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22057' 17/01/2024 04:25:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22057' 17/01/2024 04:25: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 = '22057' 17/01/2024 04:25:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22058' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:25: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 '22058' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22057' 17/01/2024 04:25:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22058' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22057' 17/01/2024 04:27:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254822012' AND id_product != '22058' AND ean13 != '' 17/01/2024 04:27:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9791254822012', date_upd = NOW() WHERE id_product = '22058' 17/01/2024 04:27:17 pm >> UPDATE ps_product_lang SET name = 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES', description = '' WHERE id_product = '22058' 17/01/2024 04:27:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '22058' 17/01/2024 04:27:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '272', 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 = '22058' 17/01/2024 04:27:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '22058' 17/01/2024 04:27:18 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 = '22058' 17/01/2024 04:27:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22059' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:27:18 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 '22059' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22058' 17/01/2024 04:27:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22059' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22058' 17/01/2024 04:28:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192370' AND id_product != '22059' AND ean13 != '' 17/01/2024 04:28:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280192370', date_upd = NOW() WHERE id_product = '22059' 17/01/2024 04:28:28 pm >> UPDATE ps_product_lang SET name = 'CREARE CASA - SUSSIDIO', description = '' WHERE id_product = '22059' 17/01/2024 04:28:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '22059' 17/01/2024 04:28:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '356', id_argoment_default = '245', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22059' 17/01/2024 04:28:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22059' 17/01/2024 04:28:33 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 = '22059' 17/01/2024 04:28:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22060' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:28:33 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 '22060' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22059' 17/01/2024 04:28:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22060' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22059' 17/01/2024 04:29:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192417' AND id_product != '22060' AND ean13 != '' 17/01/2024 04:29:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280192417', date_upd = NOW() WHERE id_product = '22060' 17/01/2024 04:29:36 pm >> UPDATE ps_product_lang SET name = 'CREARE CASA - IMMAGINETTE', description = '' WHERE id_product = '22060' 17/01/2024 04:29:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.1' WHERE id_product = '22060' 17/01/2024 04:29:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.1', id_tax_rules_group = '4', id_category_default = '356', id_argoment_default = '245', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22060' 17/01/2024 04:29:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '22060' 17/01/2024 04:29:38 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 = '22060' 17/01/2024 04:29:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22061' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:29:38 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 '22061' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22060' 17/01/2024 04:29:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22061' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22060' 17/01/2024 04:30:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821315701' AND id_product != '22061' AND ean13 != '' 17/01/2024 04:30:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788821315701', date_upd = NOW() WHERE id_product = '22061' 17/01/2024 04:30:38 pm >> UPDATE ps_product_lang SET name = 'FEDE DI ABRAMO E FEDE CRISTIANA - F. MOSETTO', description = '' WHERE id_product = '22061' 17/01/2024 04:30:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22061' 17/01/2024 04:30:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '87', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22061' 17/01/2024 04:30:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22061' 17/01/2024 04:30:40 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 = '22061' 17/01/2024 04:30:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22062' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:30:40 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 '22062' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22061' 17/01/2024 04:30:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22062' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22061' 17/01/2024 04:31:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832049657' AND id_product != '22062' AND ean13 != '' 17/01/2024 04:31:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/6', ean13 = '9788832049657', date_upd = NOW() WHERE id_product = '22062' 17/01/2024 04:31:43 pm >> UPDATE ps_product_lang SET name = 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON', description = '' WHERE id_product = '22062' 17/01/2024 04:31:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22062' 17/01/2024 04:31:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '465', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22062' 17/01/2024 04:31:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22062' 17/01/2024 04:31: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 = '22062' 17/01/2024 04:31:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22063' , '1' , '' , 'nuovo-prodotto' ) 17/01/2024 04:31: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 '22063' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22062' 17/01/2024 04:31:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22063' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22062' 17/01/2024 04:32:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024000000213' , '2024-01-16' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.30' , '124.30' , NOW() , NOW() ) 17/01/2024 04:32:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89981' 17/01/2024 04:32:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89981' 17/01/2024 04:32: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 ( '89981' , '22056' , 'E IO VI RISTORERO - M. ZUPPI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22056' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22056' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22057' , 'SEQUELA CHRISTI - C.M. MARTINI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22057' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22057' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '5' , '0' , '4' , '9.00' , '9' , '0' , '35' , '29.2500' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '2' , '0' , '4' , '20.00' , '20' , '0' , '35' , '26.0000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22058' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES' , '1' , '0' , '4' , '30.00' , '30' , '0' , '35' , '19.5000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22058' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22058' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22059' , 'CREARE CASA - SUSSIDIO' , '3' , '0' , '4' , '4.00' , '4' , '0' , '35' , '7.8000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22059' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22059' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22060' , 'CREARE CASA - IMMAGINETTE' , '100' , '0' , '4' , '0.10' , '0.1' , '0' , '35' , '6.5000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22060' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22060' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22061' , 'FEDE DI ABRAMO E FEDE CRISTIANA - F. MOSETTO' , '1' , '0' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22061' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22061' , '107' , '1' ) 17/01/2024 04:32: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 ( '89981' , '22062' , 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON' , '1' , '0' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 17/01/2024 04:32:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22062' AND id_supplier = '107' 17/01/2024 04:32:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22062' , '107' , '1' ) 17/01/2024 05:00:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '174' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 05:00:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '174' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.66' , '73.11' , NOW() , NOW() ) 17/01/2024 05:00:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89982' 17/01/2024 05:00:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89982' 17/01/2024 05:00:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89982' , '16965' , 'PALLA IN S/MOIRE - 7989M' , '1' , '-1' , '1' , '62.00' , '50.819672131148' , '22' , '0' , '62.00' ) 17/01/2024 05:00:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89982' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 17/01/2024 05:00:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89982' , '21873' , 'IN TERRA SANTA - G. RAVASI' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 17/01/2024 05:16:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 05:16:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '1/E' , '2024-01-17' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '972.00' , '796.72' , NOW() , NOW() ) 17/01/2024 05:16:37 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 = '89983' 17/01/2024 05:16:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89983' 17/01/2024 05:16: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 ( '89983' , '15300' , 'BENEDIZIONI - MADONNA MURILLO' , '1000' , '-1000' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '108.00' ) 17/01/2024 05:16: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 ( '89983' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:16: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 ( '89983' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:16: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 ( '89983' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:27: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 ( '33' , '14' , '2024-01-16' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 17/01/2024 05:27: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 = '89984' 17/01/2024 05:27:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89984' 17/01/2024 05:27: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 ( '89984' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '200' , '200' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 17/01/2024 05:27:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22053' AND id_supplier = '145' 17/01/2024 05:27:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22053' , '145' , '1' ) 17/01/2024 05:28: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 ( '33' , '15' , '2024-01-16' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 17/01/2024 05:28: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 = '89985' 17/01/2024 05:28:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89985' 17/01/2024 05:28: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 ( '89985' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '400' , '400' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 17/01/2024 05:28:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22053' AND id_supplier = '145' 17/01/2024 05:28:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22053' , '145' , '1' ) 17/01/2024 05:32:54 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'JVNQ6lXGIoBgqJpa' , NOW() , NOW() ) 17/01/2024 05:32:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4081' , '1' ) 17/01/2024 05:32:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4081' , '2' ) 17/01/2024 05:32:54 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4081' , '3' ) 17/01/2024 05:34:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4081' 17/01/2024 05:34:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4081' , '10' , '183' , '' , 'TUBELLI' , 'LUIGI' , 'VIA PAZZIGNO 6' , '' , '84146' , 'NAPOLI' , '' , '' , '3389922636' , '' , '' , NOW() , NOW() ) 17/01/2024 05:34:23 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4081' 17/01/2024 05:42:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 05:42: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 ( '24' , '1' , '2024-01-17' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12420.00' , '12420.00' , NOW() , NOW() ) 17/01/2024 05:42: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 = '89986' 17/01/2024 05:42:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89986' 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2400' , '-2400' , '4' , '3.00' , '3' , '0' , '0' , '7200.00' ) 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '960' , '-960' , '4' , '2.50' , '2.5' , '0' , '0' , '2400.00' ) 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '200' , '-200' , '4' , '2.00' , '2' , '0' , '0' , '400.00' ) 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '200' , '-200' , '4' , '2.00' , '2' , '0' , '0' , '400.00' ) 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '90' , '-90' , '4' , '10.00' , '10' , '0' , '0' , '900.00' ) 17/01/2024 05:42:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89986' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.00' , '1' , '0' , '0' , '1120.00' ) 17/01/2024 05:52:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/E' AND id_document != '89983' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 05:52:24 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '1/E', document_date = '2024-01-17', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '972.00', price_tax_excluded = '796.72', date_upd = NOW() WHERE id_document = '89983' 17/01/2024 05:52:24 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 = '89983' 17/01/2024 05:52:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89983' 17/01/2024 05:52:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.18' , '0.14754098360656' , '22' , '40' , '108.00' ) 17/01/2024 05:52:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:52:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:52:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:53:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/E' AND id_document != '89983' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 05:53:02 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '1/E', document_date = '2024-01-17', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '972.00', price_tax_excluded = '796.72', date_upd = NOW() WHERE id_document = '89983' 17/01/2024 05:53: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 = '89983' 17/01/2024 05:53:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89983' 17/01/2024 05:53:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '1041' , 'BENEDIZIONI - MADONNA MURILLO' , '1000' , '-1000' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '108.00' ) 17/01/2024 05:53:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:53:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:53:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89983' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/01/2024 05:53:32 pm >> DELETE FROM ps_document WHERE id_document = '88854' 17/01/2024 05:53:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88854' 17/01/2024 06:00:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '89986' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 06:00:38 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1', document_date = '2024-01-17', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'AMO IL SIGNORE - TITOLO SPEDITO DIRETTAMENTE DA VELAR', 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 = '13807.50', price_tax_excluded = '13807.50', date_upd = NOW() WHERE id_document = '89986' 17/01/2024 06:00: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 = '89986' 17/01/2024 06:00:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '89986' 17/01/2024 06:00: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 ( '89986' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2400' , '-2400' , '4' , '3.0000' , '3' , '0' , '0' , '7200.00' ) 17/01/2024 06:00: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 ( '89986' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '960' , '-960' , '4' , '2.5000' , '2.5' , '0' , '0' , '2400.00' ) 17/01/2024 06:00: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 ( '89986' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '200' , '-200' , '4' , '2.0000' , '2' , '0' , '0' , '400.00' ) 17/01/2024 06:00: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 ( '89986' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '200' , '-200' , '4' , '2.0000' , '2' , '0' , '0' , '400.00' ) 17/01/2024 06:00: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 ( '89986' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '90' , '-90' , '4' , '10.0000' , '10' , '0' , '0' , '900.00' ) 17/01/2024 06:00: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 ( '89986' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.0000' , '1' , '0' , '0' , '1120.00' ) 17/01/2024 06:00: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 ( '89986' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.00' , '1' , '0' , '0' , '350.00' ) 17/01/2024 06:00: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 ( '89986' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '0' , '37.50' ) 17/01/2024 06:00: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 ( '89986' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '400' , '-400' , '4' , '2.50' , '2.5' , '0' , '0' , '1000.00' ) 17/01/2024 06:35:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6993' 17/01/2024 06:35:53 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6993' , '10' , '149' , 'PARROCCHIA SAN BARTOLOMEO' , 'SCHERINI' , 'GIUSEPPE' , 'Piazza della chiesa , 10' , '' , '22013' , 'DOMASO' , '' , '' , '3388698956' , '' , '' , NOW() , NOW() ) 17/01/2024 06:35:53 pm >> UPDATE ps_customer SET email = 'domaso.vercana@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6993' 17/01/2024 06:38:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 06:38: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' , '6' , '2024-01-17' , '' , '6993' , '0' , '172691779' , 'Piazza della chiesa , 10 22013 DOMASO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '318.15' , '318.15' , NOW() , NOW() ) 17/01/2024 06:38: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 = '14181' 17/01/2024 06:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '14181' 17/01/2024 06:38: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 ( '14181' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '25' , '-25' , '4' , '2.38' , '2.38' , '0' , '' , '59.50' ) 17/01/2024 06:38: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 ( '14181' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '5' , '38.00' ) 17/01/2024 06:38: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 ( '14181' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '5' , '-5' , '4' , '30.00' , '30' , '0' , '5' , '142.50' ) 17/01/2024 06:38: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 ( '14181' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '5' , '71.25' ) 17/01/2024 06:55:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6993' 17/01/2024 06:55:35 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6993' , '10' , '149' , 'PARROCCHIA SAN BARTOLOMEO' , 'SCHERINI' , 'DON GIUSEPPE' , 'Piazza della chiesa , 10' , '' , '22013' , 'DOMASO' , '' , '' , '3388698956' , '' , '' , NOW() , NOW() ) 17/01/2024 06:55:35 pm >> UPDATE ps_customer SET email = 'domaso.vercana@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6993' 17/01/2024 07:45:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '175' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 07:45:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '175' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.90' , '1.90' , NOW() , NOW() ) 17/01/2024 07:45:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89987' 17/01/2024 07:45:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89987' 17/01/2024 07:45:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89987' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 17/01/2024 07:51:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '176' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-17') 17/01/2024 07:51:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '176' , '2024-01-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.41' , NOW() , NOW() ) 17/01/2024 07:51:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89988' 17/01/2024 07:51:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89988' 17/01/2024 07:51:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89988' , '20515' , 'DECINA ULIVO - 04/7-D' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' )