09/03/2024 08:19:23 am >> SELECT document_num FROM ps_document WHERE document_num = '593' AND id_document != '90544' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-28') 09/03/2024 08:19:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '593', document_date = '2024-02-28', 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 = '375.00', price_tax_excluded = '307.38', date_upd = NOW() WHERE id_document = '90544' 09/03/2024 08:19: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 = '90544' 09/03/2024 08:19:23 am >> DELETE FROM ps_document_detail WHERE id_document = '90544' 09/03/2024 08:19: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 ( '90544' , '19444' , 'coppia ampolle - 871' , '1' , '-1' , '1' , '105.0000' , '86.065573770492' , '22' , '0' , '105.00' ) 09/03/2024 08:19: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 ( '90544' , '22217' , 'CALICE MALTA SATINATO - 345' , '1' , '-1' , '1' , '270' , '221.31147540984' , '22' , '0' , '270.00' ) 09/03/2024 09:41:58 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/03/2024 09:41:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22248' , '1' , '' , 'nuovo-prodotto' ) 09/03/2024 09:41:58 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22248' , '1' , '1' , '2' , NOW() , NOW() ) 09/03/2024 09:41:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22248' , '0' , '1' , '0' , '0' ) 09/03/2024 09:43:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002237' AND id_product != '22248' AND ean13 != '' 09/03/2024 09:43:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002237', date_upd = NOW() WHERE id_product = '22248' 09/03/2024 09:43:38 am >> UPDATE ps_product_lang SET name = 'STOLA - STOM18', description = '' WHERE id_product = '22248' 09/03/2024 09:43:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '184.4262295081967' WHERE id_product = '22248' 09/03/2024 09:43:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '184.4262295081967', id_tax_rules_group = '1', id_category_default = '494', 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 = '22248' 09/03/2024 09:43:38 am >> DELETE FROM ps_specific_price WHERE id_product = '22248' 09/03/2024 09:43:39 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 = '22248' 09/03/2024 09:43:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22249' , '1' , '' , 'nuovo-prodotto' ) 09/03/2024 09:43:39 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 '22249' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22248' 09/03/2024 09:43:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22249' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22248' 09/03/2024 09:44:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0022838' AND id_product != '22249' AND ean13 != '' 09/03/2024 09:44:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '0022838', date_upd = NOW() WHERE id_product = '22249' 09/03/2024 09:44:36 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - CASOM77', description = '' WHERE id_product = '22249' 09/03/2024 09:44:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '422.1311475409836' WHERE id_product = '22249' 09/03/2024 09:44:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '422.1311475409836', id_tax_rules_group = '1', id_category_default = '494', 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 = '22249' 09/03/2024 09:44:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22249' 09/03/2024 09:44:37 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 = '22249' 09/03/2024 09:44:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22250' , '1' , '' , 'nuovo-prodotto' ) 09/03/2024 09:44:37 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 '22250' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22249' 09/03/2024 09:44:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22250' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22249' 09/03/2024 09:45:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002238' AND id_product != '22249' AND ean13 != '' 09/03/2024 09:45:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002238', date_upd = NOW() WHERE id_product = '22249' 09/03/2024 09:45:22 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - CASOM77', description = '' WHERE id_product = '22249' 09/03/2024 09:45:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '422.1311' WHERE id_product = '22249' 09/03/2024 09:45:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '422.1311', id_tax_rules_group = '1', id_category_default = '494', 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 = '22249' 09/03/2024 09:45:22 am >> DELETE FROM ps_specific_price WHERE id_product = '22249' 09/03/2024 09:47:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002239' AND id_product != '22250' AND ean13 != '' 09/03/2024 09:47:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002239', date_upd = NOW() WHERE id_product = '22250' 09/03/2024 09:47:18 am >> UPDATE ps_product_lang SET name = 'STOLA RICAMO ORO - STOM16', description = '' WHERE id_product = '22250' 09/03/2024 09:47:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '610.655737704918' WHERE id_product = '22250' 09/03/2024 09:47:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '610.655737704918', id_tax_rules_group = '1', id_category_default = '494', 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 = '22250' 09/03/2024 09:47:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22250' 09/03/2024 09:47:19 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 = '22250' 09/03/2024 09:47:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22251' , '1' , '' , 'nuovo-prodotto' ) 09/03/2024 09:47:19 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 '22251' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22250' 09/03/2024 09:47:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22251' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22250' 09/03/2024 09:50:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '34' , '2024-03-07' , '' , '0' , '160' , '4673832' , 'VIA TIRABOSCHI 13 24017 SERINA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1138.19' , '932.94' , NOW() , NOW() ) 09/03/2024 09:50:05 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 = '90694' 09/03/2024 09:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '90694' 09/03/2024 09:50:05 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 ( '90694' , '22248' , 'STOLA - STOM18' , '4' , '4' , '1' , '97.36' , '79.803278688525' , '22' , '0' , '475.1168' ) 09/03/2024 09:50:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '22248' AND id_supplier = '160' 09/03/2024 09:50:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22248' , '160' , '1' ) 09/03/2024 09:50:05 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 ( '90694' , '22250' , 'STOLA RICAMO ORO - STOM16' , '1' , '1' , '1' , '324.22' , '265.75409836066' , '22' , '0' , '395.5484' ) 09/03/2024 09:50:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '22250' AND id_supplier = '160' 09/03/2024 09:50:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22250' , '160' , '1' ) 09/03/2024 09:50:05 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 ( '90694' , '19435' , 'STOLA - STO0M05' , '1' , '1' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 09/03/2024 09:50:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '19435' AND id_supplier = '160' 09/03/2024 09:50:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19435' , '160' , '1' ) 09/03/2024 09:50:05 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 ( '90694' , '22249' , 'CASULA MARIANA - CASOM77' , '1' , '1' , '1' , '219.28' , '179.73770491803' , '22' , '0' , '267.5216' ) 09/03/2024 09:50:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '22249' AND id_supplier = '160' 09/03/2024 09:50:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22249' , '160' , '1' ) 09/03/2024 10:13:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4/A' AND id_document != '89857' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 09/03/2024 10:13:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '4/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'osp. battipaglia', 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 = '122.10', price_tax_excluded = '108.58', date_upd = NOW() WHERE id_document = '89857' 09/03/2024 10:13: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 = '89857' 09/03/2024 10:13:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89857' 09/03/2024 10:13: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 ( '89857' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '24' , '-24' , '4' , '0.7000' , '0.7' , '0' , '0' , '16.80' ) 09/03/2024 10:13: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 ( '89857' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 09/03/2024 10:13: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 ( '89857' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '75.00' ) 09/03/2024 10:13: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 ( '89857' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 09/03/2024 10:13: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 ( '89857' , '22189' , 'VIA CRUCIS VIA DI SPERANZA - R. LUPI' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '0' , '7.80' ) 09/03/2024 10:29:56 am >> SELECT document_num FROM ps_document WHERE document_num = '701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 10:29:56 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' , '701' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 09/03/2024 10:29:56 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 = '90695' 09/03/2024 10:29:56 am >> DELETE FROM ps_document_detail WHERE id_document = '90695' 09/03/2024 10:29:56 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 ( '90695' , '10687' , 'TORCIA A VENTO ' , '10' , '-10' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '29.00' ) 09/03/2024 10:50:53 am >> SELECT document_num FROM ps_document WHERE document_num = '702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 10:50:53 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' , '702' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.58' , '28.58' , NOW() , NOW() ) 09/03/2024 10:50:53 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 = '90696' 09/03/2024 10:50:53 am >> DELETE FROM ps_document_detail WHERE id_document = '90696' 09/03/2024 10:50:53 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 ( '90696' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 09/03/2024 10:50:53 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 ( '90696' , '5823' , 'LIBRO DORO' , '44' , '-44' , '4' , '0.60' , '0.6' , '0' , '5' , '25.08' ) 09/03/2024 10:56:54 am >> SELECT document_num FROM ps_document WHERE document_num = '703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 10:56:54 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' , '703' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.30' , '17.30' , NOW() , NOW() ) 09/03/2024 10:56:54 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 = '90697' 09/03/2024 10:56:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90697' 09/03/2024 10:56:54 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 ( '90697' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/03/2024 10:56:54 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 ( '90697' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/03/2024 10:56:54 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 ( '90697' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/03/2024 10:56:54 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 ( '90697' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2024 10:56:54 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 ( '90697' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2024 11:13:14 am >> SELECT document_num FROM ps_document WHERE document_num = '704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 11:13:14 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' , '704' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.12' , '32.12' , NOW() , NOW() ) 09/03/2024 11:13:14 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 = '90698' 09/03/2024 11:13:14 am >> DELETE FROM ps_document_detail WHERE id_document = '90698' 09/03/2024 11:13:14 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 ( '90698' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 09/03/2024 11:13:14 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 ( '90698' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 09/03/2024 11:22:24 am >> SELECT document_num FROM ps_document WHERE document_num = '705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 11:22:24 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' , '705' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.01' , '17.01' , NOW() , NOW() ) 09/03/2024 11:22:24 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 = '90699' 09/03/2024 11:22:24 am >> DELETE FROM ps_document_detail WHERE id_document = '90699' 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '18116' , 'HO INCONTRATO GESU - POSTER' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '9742' , 'SCHEMA DEI VANGELI ' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '19421' , 'DIO CON NOI - POSTER' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '6228' , 'MARIA DI NAZARET - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '12868' , 'GIOCANDO SCOPRIAMO LANNO LITURGICO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 09/03/2024 11:22:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90699' , '20747' , 'VIA CRUCIS PER I PICCOLI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 09/03/2024 11:25:09 am >> SELECT document_num FROM ps_document WHERE document_num = '706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-09') 09/03/2024 11:25: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' , '706' , '2024-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.79' , '40.99' , NOW() , NOW() ) 09/03/2024 11:25: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 = '90700' 09/03/2024 11:25:09 am >> DELETE FROM ps_document_detail WHERE id_document = '90700' 09/03/2024 11:25: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 ( '90700' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/03/2024 11:25: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 ( '90700' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 09/03/2024 11:25: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 ( '90700' , '18626' , 'NUOVO MESSALINO DEI BAMBINI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 09/03/2024 11:25: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 ( '90700' , '9530' , 'SANTAGOSTINO - R.PICCOLOMINI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 09/03/2024 11:25: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 ( '90700' , '14930' , 'MARIA LA MAMMA DI GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/03/2024 11:25: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 ( '90700' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 09/03/2024 11:25: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 ( '90700' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 09/03/2024 11:25: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 ( '90700' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' )