11/08/2023 08:55:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 08:55:52 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' , '2613' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '9.34' , NOW() , NOW() ) 11/08/2023 08:55:52 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 = '87041' 11/08/2023 08:55:52 am >> DELETE FROM ps_document_detail WHERE id_document = '87041' 11/08/2023 08:55:52 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 ( '87041' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 11/08/2023 09:05:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '86936' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-01') 11/08/2023 09:05:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2533', document_date = '2023-08-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '86936' 11/08/2023 09:05: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 = '86936' 11/08/2023 09:05:50 am >> DELETE FROM ps_document_detail WHERE id_document = '86936' 11/08/2023 09:05: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 ( '86936' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 11/08/2023 09:05: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 ( '86936' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '5' , '19.00' ) 11/08/2023 09:07:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 09:07:12 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' , '2614' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '20.21' , NOW() , NOW() ) 11/08/2023 09:07:12 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 = '87042' 11/08/2023 09:07:12 am >> DELETE FROM ps_document_detail WHERE id_document = '87042' 11/08/2023 09:07:12 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 ( '87042' , '18440' , 'SANTA RITA I QUINDICI GIOVEDI E NOVENA - 8036' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 11/08/2023 09:07:12 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 ( '87042' , '13719' , 'CROCE CON BASE CM 28' , '1' , '-1' , '1' , '21' , '17.213114754098' , '22' , '0' , '21.00' ) 11/08/2023 09:11:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884042354' AND id_product != '4836' AND ean13 != '' 11/08/2023 09:11:29 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884042354', date_upd = NOW() WHERE id_product = '4836' 11/08/2023 09:11:29 am >> UPDATE ps_product_lang SET name = 'HO VISTO DIO IN UN UOMO - CURATO D\'ARS - 8415', description = '' WHERE id_product = '4836' 11/08/2023 09:11:29 am >> UPDATE ps_product SET wholesale_price = '4.80', on_sale = '0', price = '9' WHERE id_product = '4836' 11/08/2023 09:11:29 am >> UPDATE ps_product_shop SET wholesale_price = '4.80', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4836' 11/08/2023 09:11:29 am >> DELETE FROM ps_specific_price WHERE id_product = '4836' 11/08/2023 09:19:32 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/08/2023 09:19:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21481' , '1' , '' , 'nuovo-prodotto' ) 11/08/2023 09:19:32 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21481' , '1' , '1' , '2' , NOW() , NOW() ) 11/08/2023 09:19:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21481' , '0' , '1' , '0' , '0' ) 11/08/2023 09:20:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '20/50' AND id_product != '21481' AND ean13 != '' 11/08/2023 09:20:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '20/50', date_upd = NOW() WHERE id_product = '21481' 11/08/2023 09:20:41 am >> UPDATE ps_product_lang SET name = 'CAMICE LINO/POL. GIGLIUCCIO A MANO VIOLA', description = '' WHERE id_product = '21481' 11/08/2023 09:20:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '409.016393442623' WHERE id_product = '21481' 11/08/2023 09:20:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '409.016393442623', id_tax_rules_group = '1', id_category_default = '450', 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 = '21481' 11/08/2023 09:20:41 am >> DELETE FROM ps_specific_price WHERE id_product = '21481' 11/08/2023 09:20:43 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 = '21481' 11/08/2023 09:20:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21482' , '1' , '' , 'nuovo-prodotto' ) 11/08/2023 09:20:43 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 '21482' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21481' 11/08/2023 09:20:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21482' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21481' 11/08/2023 09:22:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '60/345' AND id_product != '21482' AND ean13 != '' 11/08/2023 09:22:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/345', date_upd = NOW() WHERE id_product = '21482' 11/08/2023 09:22:01 am >> UPDATE ps_product_lang SET name = 'CAMICE LINO/POL PIZZO TULLE', description = '' WHERE id_product = '21482' 11/08/2023 09:22:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '811.4754098360656' WHERE id_product = '21482' 11/08/2023 09:22:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '811.4754098360656', id_tax_rules_group = '1', id_category_default = '450', 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 = '21482' 11/08/2023 09:22:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21482' 11/08/2023 09:25:38 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' , '3919/2023' , '2023-08-04' , '2023' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1003.52' , '822.56' , NOW() , NOW() ) 11/08/2023 09:25:38 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 = '87043' 11/08/2023 09:25:38 am >> DELETE FROM ps_document_detail WHERE id_document = '87043' 11/08/2023 09:25:38 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 ( '87043' , '21481' , 'CAMICE LINO/POL. GIGLIUCCIO A MANO VIOLA' , '2' , '2' , '1' , '215' , '176.22950819672' , '22' , '3' , '508.8620' ) 11/08/2023 09:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21481' AND id_supplier = '129' 11/08/2023 09:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21481' , '129' , '1' ) 11/08/2023 09:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87043' , '21482' , 'CAMICE LINO/POL PIZZO TULLE' , '1' , '1' , '1' , '418' , '342.62295081967' , '22' , '3' , '494.6612' ) 11/08/2023 09:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '21482' AND id_supplier = '129' 11/08/2023 09:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21482' , '129' , '1' ) 11/08/2023 10:07:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:07:02 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' , '2615' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '43.63' , NOW() , NOW() ) 11/08/2023 10:07:02 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 = '87044' 11/08/2023 10:07:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87044' 11/08/2023 10:07:02 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 ( '87044' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 11/08/2023 10:07:02 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 ( '87044' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '37.4' , '37.4' , '0' , '0' , '37.40' ) 11/08/2023 10:07:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:07:17 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' , '2616' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 11/08/2023 10:07:17 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 = '87045' 11/08/2023 10:07:17 am >> DELETE FROM ps_document_detail WHERE id_document = '87045' 11/08/2023 10:07:17 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 ( '87045' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 11/08/2023 10:07:17 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 ( '87045' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 11/08/2023 10:24:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:24:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2617' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.60' , '25.60' , NOW() , NOW() ) 11/08/2023 10:24:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87046' 11/08/2023 10:24:36 am >> DELETE FROM ps_document_detail WHERE id_document = '87046' 11/08/2023 10:24:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87046' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 11/08/2023 10:26:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2618' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:26:02 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' , '2618' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.94' , NOW() , NOW() ) 11/08/2023 10:26:02 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 = '87047' 11/08/2023 10:26:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87047' 11/08/2023 10:26:02 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 ( '87047' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 11/08/2023 10:26:02 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 ( '87047' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/08/2023 10:35:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:35:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2619' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '40.11' , NOW() , NOW() ) 11/08/2023 10:35:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87048' 11/08/2023 10:35:58 am >> DELETE FROM ps_document_detail WHERE id_document = '87048' 11/08/2023 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87048' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 11/08/2023 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87048' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '19' , '-19' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '9.50' ) 11/08/2023 10:35:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87048' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 11/08/2023 10:57:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 10:57: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' , '2620' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 11/08/2023 10:57: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 = '87049' 11/08/2023 10:57:20 am >> DELETE FROM ps_document_detail WHERE id_document = '87049' 11/08/2023 10:57: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 ( '87049' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 11/08/2023 10:57: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 ( '87049' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 11/08/2023 10:57: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 ( '87049' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 11/08/2023 11:46:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2610' AND id_document != '87038' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 11/08/2023 11:46:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2610', document_date = '2023-08-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.05', price_tax_excluded = '45.05', date_upd = NOW() WHERE id_document = '87038' 11/08/2023 11:46:29 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 = '87038' 11/08/2023 11:46:29 am >> DELETE FROM ps_document_detail WHERE id_document = '87038' 11/08/2023 11:46:29 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 ( '87038' , '21409' , 'SUBLIMITAS ET MISERIA HOMINIS' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 11/08/2023 11:46:29 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 ( '87038' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 11/08/2023 11:46:29 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 ( '87038' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 11/08/2023 11:46:29 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 ( '87038' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 11/08/2023 11:46:29 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 ( '87038' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 11/08/2023 11:48:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2609' AND id_document != '87037' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 11/08/2023 11:48:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2609', document_date = '2023-08-10', 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 = '30.52', price_tax_excluded = '30.52', date_upd = NOW() WHERE id_document = '87037' 11/08/2023 11:48:02 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 = '87037' 11/08/2023 11:48:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87037' 11/08/2023 11:48:02 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 ( '87037' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 11/08/2023 11:48:02 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 ( '87037' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 11/08/2023 11:48:02 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 ( '87037' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.25' , '1.25' , '0' , '0' , '1.25' ) 11/08/2023 11:48:02 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 ( '87037' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 11/08/2023 12:13:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2621' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 12:13:00 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' , '2621' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 11/08/2023 12:13:00 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 = '87050' 11/08/2023 12:13:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '87050' 11/08/2023 12:13:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87050' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 11/08/2023 12:42:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-11') 11/08/2023 12:42:03 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' , '2622' , '2023-08-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 11/08/2023 12:42:03 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 = '87051' 11/08/2023 12:42:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '87051' 11/08/2023 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87051' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '12' , '-12' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '24.00' ) 11/08/2023 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87051' , '20062' , 'BRACCIALE DECINA - BD018' , '12' , '-12' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '24.00' ) 11/08/2023 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87051' , '20072' , 'BRACCIALE - BC1759N' , '22' , '-22' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '44.00' ) 11/08/2023 12:42:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87051' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '14' , '-14' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '28.00' )