19/02/2024 09:53:17 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/02/2024 09:53:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22154' , '1' , '' , 'nuovo-prodotto' ) 19/02/2024 09:53:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22154' , '1' , '1' , '2' , NOW() , NOW() ) 19/02/2024 09:53:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22154' , '0' , '1' , '0' , '0' ) 19/02/2024 09:54:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846277351' AND id_product != '22154' AND ean13 != '' 19/02/2024 09:54:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846277351', date_upd = NOW() WHERE id_product = '22154' 19/02/2024 09:54:25 am >> UPDATE ps_product_lang SET name = 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR', description = '' WHERE id_product = '22154' 19/02/2024 09:54:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '22154' 19/02/2024 09:54:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '151', 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 = '22154' 19/02/2024 09:54:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22154' 19/02/2024 09:55:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846277351' AND id_product != '22154' AND ean13 != '' 19/02/2024 09:55:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846277351', date_upd = NOW() WHERE id_product = '22154' 19/02/2024 09:55:48 am >> UPDATE ps_product_lang SET name = 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR', description = '' WHERE id_product = '22154' 19/02/2024 09:55:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '22154' 19/02/2024 09:55:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '151', 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 = '22154' 19/02/2024 09:55:48 am >> DELETE FROM ps_specific_price WHERE id_product = '22154' 19/02/2024 09:55:50 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22154' 19/02/2024 09:55:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22155' , '1' , '' , 'nuovo-prodotto' ) 19/02/2024 09:55:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22155' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22154' 19/02/2024 09:55:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22155' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22154' 19/02/2024 10:04:22 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 ( '31' , '297' , '2024-02-19' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.27' , '20.71' , NOW() , NOW() ) 19/02/2024 10:04:22 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 = '90402' 19/02/2024 10:04:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90402' 19/02/2024 10:04:22 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 ( '90402' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '2' , '2' , '1' , '7.62' , '6.2459016393443' , '22' , '10' , '16.7335' ) 19/02/2024 10:04:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22011' AND id_supplier = '43' 19/02/2024 10:04:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22011' , '43' , '1' ) 19/02/2024 10:04:22 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 ( '90402' , '22154' , 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR' , '1' , '1' , '1' , '7.77' , '6.3688524590164' , '22' , '10' , '8.5315' ) 19/02/2024 10:04:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '22154' AND id_supplier = '43' 19/02/2024 10:04:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22154' , '43' , '1' ) 19/02/2024 10:04:33 am >> SELECT document_num FROM ps_document WHERE document_num = '489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 10:04: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' , '489' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.66' , '4.66' , NOW() , NOW() ) 19/02/2024 10:04: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 = '90403' 19/02/2024 10:04:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90403' 19/02/2024 10:04: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 ( '90403' , '21878' , 'CRESIMA INSIEME NELLO SPIRITO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 19/02/2024 10:45:04 am >> SELECT document_num FROM ps_document WHERE document_num = '490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 10:45:04 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' , '490' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.40' , '27.40' , NOW() , NOW() ) 19/02/2024 10:45:04 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 = '90404' 19/02/2024 10:45:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90404' 19/02/2024 10:45:04 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 ( '90404' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 19/02/2024 10:45:04 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 ( '90404' , '20719' , 'CORONA DELL’ADDOLORATA' , '3' , '-3' , '4' , '1.80' , '1.8' , '0' , '0' , '5.40' ) 19/02/2024 10:45:04 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 ( '90404' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 19/02/2024 10:47:20 am >> SELECT document_num FROM ps_document WHERE document_num = '491' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 10:47:20 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' , '491' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '32.05' , NOW() , NOW() ) 19/02/2024 10:47:20 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 = '90405' 19/02/2024 10:47:20 am >> DELETE FROM ps_document_detail WHERE id_document = '90405' 19/02/2024 10:47:20 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 ( '90405' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 19/02/2024 10:47:20 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 ( '90405' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 19/02/2024 10:47:20 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 ( '90405' , '21535' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 19/02/2024 10:47:20 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 ( '90405' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/02/2024 10:47:20 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 ( '90405' , '20026' , 'CANDELA VOTIVA 20X40' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 19/02/2024 10:47:41 am >> SELECT document_num FROM ps_document WHERE document_num = '492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 10:47:41 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' , '492' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 19/02/2024 10:47:41 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 = '90406' 19/02/2024 10:47:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90406' 19/02/2024 10:47:41 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 ( '90406' , '20026' , 'CANDELA VOTIVA 20X40' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 19/02/2024 10:47:41 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 ( '90406' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 19/02/2024 11:10:41 am >> SELECT document_num FROM ps_document WHERE document_num = '493' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:10:41 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' , '493' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.15' , '61.47' , NOW() , NOW() ) 19/02/2024 11:10:41 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 = '90407' 19/02/2024 11:10:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90407' 19/02/2024 11:10:41 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 ( '90407' , '22010' , 'CROCE SAN DAMIANO 40X30 - PG553' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 19/02/2024 11:10:41 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 ( '90407' , '16095' , 'PRETE E LA GIOIA - A. PRONZATO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 19/02/2024 11:10:41 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 ( '90407' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/02/2024 11:10:41 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 ( '90407' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 19/02/2024 11:22:45 am >> SELECT document_num FROM ps_document WHERE document_num = '494' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:22:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '494' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.58' , '12.58' , NOW() , NOW() ) 19/02/2024 11:22:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90408' 19/02/2024 11:22:45 am >> DELETE FROM ps_document_detail WHERE id_document = '90408' 19/02/2024 11:22:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90408' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 19/02/2024 11:22:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90408' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 19/02/2024 11:22:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90408' , '22111' , 'PREGARE OGGI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 19/02/2024 11:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '495' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:36:50 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' , '495' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 19/02/2024 11:36:50 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 = '90409' 19/02/2024 11:36:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90409' 19/02/2024 11:36:50 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 ( '90409' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 19/02/2024 11:46:09 am >> SELECT document_num FROM ps_document WHERE document_num = '496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:46: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' , '496' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.30' , '86.76' , NOW() , NOW() ) 19/02/2024 11:46: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 = '90410' 19/02/2024 11:46:09 am >> DELETE FROM ps_document_detail WHERE id_document = '90410' 19/02/2024 11:46: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 ( '90410' , '15302' , 'BENEDIZIONI - MAGNIFICAT' , '500' , '-500' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '75.00' ) 19/02/2024 11:46: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 ( '90410' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 19/02/2024 11:46: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 ( '90410' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 19/02/2024 11:46: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 ( '90410' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 19/02/2024 11:52:46 am >> SELECT document_num FROM ps_document WHERE document_num = '497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:52:46 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' , '497' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.30' , '86.76' , NOW() , NOW() ) 19/02/2024 11:52:46 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 = '90411' 19/02/2024 11:52:46 am >> DELETE FROM ps_document_detail WHERE id_document = '90411' 19/02/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90411' , '15299' , 'BENEDIZIONI - MADONNA A' , '500' , '-500' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '75.00' ) 19/02/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90411' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 19/02/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90411' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 19/02/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90411' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 19/02/2024 11:57:06 am >> SELECT document_num FROM ps_document WHERE document_num = '498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 11:57:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '498' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 19/02/2024 11:57:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90412' 19/02/2024 11:57:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90412' 19/02/2024 11:57:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90412' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/02/2024 12:05:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 12:05:12 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' , '499' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 19/02/2024 12:05:12 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 = '90413' 19/02/2024 12:05:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90413' 19/02/2024 12:05:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90413' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 19/02/2024 12:08:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '491' AND id_document != '90405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 12:08:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '491', document_date = '2024-02-19', 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 = '32.50', price_tax_excluded = '32.05', date_upd = NOW() WHERE id_document = '90405' 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90405' 19/02/2024 12:08:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '90405' 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90405' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90405' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90405' , '21535' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90405' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 19/02/2024 12:08:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90405' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 19/02/2024 12:08:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '492' AND id_document != '90406' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 12:08:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '492', document_date = '2024-02-19', 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 = '11.00', price_tax_excluded = '9.02', date_upd = NOW() WHERE id_document = '90406' 19/02/2024 12:08: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 = '90406' 19/02/2024 12:08:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90406' 19/02/2024 12:08: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 ( '90406' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 19/02/2024 12:08: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 ( '90406' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 19/02/2024 12:21:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279928' AND id_product != '22155' AND ean13 != '' 19/02/2024 12:21:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279928', date_upd = NOW() WHERE id_product = '22155' 19/02/2024 12:21:21 pm >> UPDATE ps_product_lang SET name = 'croce met. smaltata arg. - cl271', description = '' WHERE id_product = '22155' 19/02/2024 12:21:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '22155' 19/02/2024 12:21:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '151', 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 = '22155' 19/02/2024 12:21:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22155' 19/02/2024 12:21:22 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 = '22155' 19/02/2024 12:21:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22156' , '1' , '' , 'nuovo-prodotto' ) 19/02/2024 12:21:22 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 '22156' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22155' 19/02/2024 12:21:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22156' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22155' 19/02/2024 12:22:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846280047' AND id_product != '22156' AND ean13 != '' 19/02/2024 12:22:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846280047', date_upd = NOW() WHERE id_product = '22156' 19/02/2024 12:22:37 pm >> UPDATE ps_product_lang SET name = 'CROCE MET. SMALTATA DOR. - CL271D', description = '' WHERE id_product = '22156' 19/02/2024 12:22:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.131147540983606' WHERE id_product = '22156' 19/02/2024 12:22:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.131147540983606', id_tax_rules_group = '1', id_category_default = '151', 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 = '22156' 19/02/2024 12:22:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '22156' 19/02/2024 12:22: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 = '22156' 19/02/2024 12:22:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22157' , '1' , '' , 'nuovo-prodotto' ) 19/02/2024 12:22: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 '22157' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22156' 19/02/2024 12:22:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22157' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22156' 19/02/2024 12:23:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279928' AND id_product != '22155' AND ean13 != '' 19/02/2024 12:23:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279928', date_upd = NOW() WHERE id_product = '22155' 19/02/2024 12:23:05 pm >> UPDATE ps_product_lang SET name = 'CROCE MET. SMALTATA ARG. - CL271', description = '' WHERE id_product = '22155' 19/02/2024 12:23:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.1475' WHERE id_product = '22155' 19/02/2024 12:23:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.1475', id_tax_rules_group = '1', id_category_default = '151', 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 = '22155' 19/02/2024 12:23:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22155' 19/02/2024 12:24:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279959' AND id_product != '22157' AND ean13 != '' 19/02/2024 12:24:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279959', date_upd = NOW() WHERE id_product = '22157' 19/02/2024 12:24:01 pm >> UPDATE ps_product_lang SET name = 'CROCE MET. SMALTATA - CL272', description = '' WHERE id_product = '22157' 19/02/2024 12:24:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.213114754098362' WHERE id_product = '22157' 19/02/2024 12:24:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.213114754098362', id_tax_rules_group = '1', id_category_default = '151', 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 = '22157' 19/02/2024 12:24:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '22157' 19/02/2024 12:24:02 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 = '22157' 19/02/2024 12:24:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22158' , '1' , '' , 'nuovo-prodotto' ) 19/02/2024 12:24:02 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 '22158' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22157' 19/02/2024 12:24:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22158' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22157' 19/02/2024 12:24:32 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '297', document_date = '2024-02-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', 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 = '67.42', price_tax_excluded = '55.26', date_upd = NOW() WHERE id_document = '90402' 19/02/2024 12:24: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 = '90402' 19/02/2024 12:24:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90402' 19/02/2024 12:24: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 ( '90402' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '2' , '2' , '1' , '7.6200' , '6.2459016393443' , '22' , '10' , '16.73' ) 19/02/2024 12:24: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 ( '90402' , '22154' , 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR' , '1' , '1' , '1' , '7.7700' , '6.3688524590164' , '22' , '10' , '8.53' ) 19/02/2024 12:24: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 ( '90402' , '22156' , 'CROCE MET. SMALTATA DOR. - CL271D' , '4' , '4' , '1' , '3.55' , '2.9098360655738' , '22' , '10' , '15.5916' ) 19/02/2024 12:24: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 ( '90402' , '22155' , 'CROCE MET. SMALTATA ARG. - CL271' , '4' , '4' , '1' , '3' , '2.4590163934426' , '22' , '10' , '13.1760' ) 19/02/2024 12:24: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 ( '90402' , '22157' , 'CROCE MET. SMALTATA - CL272' , '2' , '2' , '1' , '6.1' , '5' , '22' , '10' , '13.3956' ) 19/02/2024 12:51:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 12:51: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' , '500' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.62' , '21.96' , NOW() , NOW() ) 19/02/2024 12:51: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 = '90414' 19/02/2024 12:51:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90414' 19/02/2024 12:51: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 ( '90414' , '14684' , 'RITI E PREGHIERE DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '5' , '3.04' ) 19/02/2024 12:51: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 ( '90414' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 19/02/2024 12:51: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 ( '90414' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '17.20' ) 19/02/2024 03:04:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '89869' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-09') 19/02/2024 03:04:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2024-01-09', document_letter = 'A', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', 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 = '501.65', price_tax_excluded = '501.65', date_upd = NOW() WHERE id_document = '89869' 19/02/2024 03:04: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 = '89869' 19/02/2024 03:04:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89869' 19/02/2024 03:04: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 ( '89869' , '15020' , 'PREGARE OGNI GIORNO' , '500' , '-500' , '4' , '1.0000' , '1' , '0' , '25' , '375.00' ) 19/02/2024 03:04: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 ( '89869' , '15293' , 'BENEDIZIONI - RISURREZIONE A' , '200' , '-200' , '4' , '0.1500' , '0.15' , '0' , '0' , '30.00' ) 19/02/2024 03:04: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 ( '89869' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '15' , '42.50' ) 19/02/2024 03:04: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 ( '89869' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '19' , '-19' , '4' , '3.00' , '3' , '0' , '5' , '54.15' ) 19/02/2024 04:02:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 04:02:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '501' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.40' , '6.07' , NOW() , NOW() ) 19/02/2024 04:02:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90415' 19/02/2024 04:02:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90415' 19/02/2024 04:02:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90415' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 19/02/2024 04:02:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90415' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 19/02/2024 06:00:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '90082' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-25') 19/02/2024 06:00:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '245', document_date = '2024-01-25', 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 = '23.85', price_tax_excluded = '23.85', date_upd = NOW() WHERE id_document = '90082' 19/02/2024 06:00: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 = '90082' 19/02/2024 06:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90082' 19/02/2024 06:00: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 ( '90082' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 19/02/2024 06:00: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 ( '90082' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 19/02/2024 06:00: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 ( '90082' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/02/2024 06:00: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 ( '90082' , '22093' , 'VIA CRUCIS DEI BAMBINI - M. GATTAFONI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 19/02/2024 06:01:17 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '21037' 19/02/2024 06:01:17 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '21037' 19/02/2024 06:02:15 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '20795' 19/02/2024 06:02:15 pm >> UPDATE ps_stock_available SET quantity = quantity + '-4' WHERE id_product = '20795' 19/02/2024 06:02:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '278' AND id_document != '90122' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-27') 19/02/2024 06:02:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '278', document_date = '2024-01-27', 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 = '9.50', price_tax_excluded = '9.50', date_upd = NOW() WHERE id_document = '90122' 19/02/2024 06:02: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 = '90122' 19/02/2024 06:02:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '90122' 19/02/2024 06:02: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 ( '90122' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 19/02/2024 06:02: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 ( '90122' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '4.75' , '4.75' , '0' , '0' , '4.75' ) 19/02/2024 06:02:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '90161' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 19/02/2024 06:02:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '310', document_date = '2024-01-30', 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 = '4.50', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '90161' 19/02/2024 06:02: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 = '90161' 19/02/2024 06:02:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90161' 19/02/2024 06:02: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 ( '90161' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 19/02/2024 07:27:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 07:27:18 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' , '502' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 19/02/2024 07:27:18 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 = '90416' 19/02/2024 07:27:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '90416' 19/02/2024 07:27:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90416' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 19/02/2024 07:33:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 07:33: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' , '503' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.10' , '5.82' , NOW() , NOW() ) 19/02/2024 07:33: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 = '90417' 19/02/2024 07:33:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90417' 19/02/2024 07:33: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 ( '90417' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 19/02/2024 07:33: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 ( '90417' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 19/02/2024 08:00:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/02/2024 08:00:41 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' , '504' , '2024-02-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.70' , '18.87' , NOW() , NOW() ) 19/02/2024 08:00:41 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 = '90418' 19/02/2024 08:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '90418' 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6' , '6' , '0' , '0' , '6.00' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '19561' , 'CARD SAN GIUDA TADDEO' , '3' , '-3' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '4.80' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/02/2024 08:00:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '19561' , 'CARD SAN GIUDA TADDEO' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' )