30/01/2025 08:40:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'OGGETTI' AND id_product != '7202' AND ean13 != '' 30/01/2025 08:40:33 am >> UPDATE ps_product SET id_supplier = '20', reference = '', ean13 = 'OGGETTI', date_upd = NOW() WHERE id_product = '7202' 30/01/2025 08:40:33 am >> UPDATE ps_product_lang SET name = 'ARTICOLI RELIGIOSI', description = '' WHERE id_product = '7202' 30/01/2025 08:40:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '7202' 30/01/2025 08:40:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '', 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 = '7202' 30/01/2025 08:40:33 am >> DELETE FROM ps_specific_price WHERE id_product = '7202' 30/01/2025 10:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:34:27 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' , '297' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.20' , '63.74' , NOW() , NOW() ) 30/01/2025 10:34:27 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 = '95485' 30/01/2025 10:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '95485' 30/01/2025 10:34:27 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 ( '95485' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 30/01/2025 10:34:27 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 ( '95485' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 30/01/2025 10:34:27 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 ( '95485' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '5' , '-5' , '4' , '2.7' , '2.7' , '0' , '' , '13.50' ) 30/01/2025 10:37:00 am >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:37:00 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' , '298' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.83' , '90.37' , NOW() , NOW() ) 30/01/2025 10:37:00 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 = '95486' 30/01/2025 10:37:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95486' 30/01/2025 10:37:00 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 ( '95486' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 30/01/2025 10:37:00 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 ( '95486' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 30/01/2025 10:37:00 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 ( '95486' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21.6' , '21.6' , '0' , '0' , '21.60' ) 30/01/2025 10:37:00 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 ( '95486' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 30/01/2025 10:37:22 am >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:37: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 ( '11' , '299' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.60' , '21.60' , NOW() , NOW() ) 30/01/2025 10:37: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 = '95487' 30/01/2025 10:37:22 am >> DELETE FROM ps_document_detail WHERE id_document = '95487' 30/01/2025 10:37: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 ( '95487' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '3' , '-3' , '4' , '7.2' , '7.2' , '0' , '0' , '21.60' ) 30/01/2025 10:38:01 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:38:01 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' , '300' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.01' , '17.01' , NOW() , NOW() ) 30/01/2025 10:38:01 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 = '95488' 30/01/2025 10:38:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95488' 30/01/2025 10:38:01 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 ( '95488' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 30/01/2025 10:40:39 am >> SELECT document_num FROM ps_document WHERE document_num = '301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:40:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '301' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 30/01/2025 10:40:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95489' 30/01/2025 10:40:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95489' 30/01/2025 10:40:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95489' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 30/01/2025 10:43:48 am >> SELECT document_num FROM ps_document WHERE document_num = '302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:43:48 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' , '302' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 30/01/2025 10:43:48 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 = '95490' 30/01/2025 10:43:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95490' 30/01/2025 10:43:48 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 ( '95490' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 30/01/2025 10:45:30 am >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '95486' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 10:45:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '298', document_date = '2025-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 = '96.83', price_tax_excluded = '90.37', date_upd = NOW() WHERE id_document = '95486' 30/01/2025 10:45:30 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 = '95486' 30/01/2025 10:45:30 am >> DELETE FROM ps_document_detail WHERE id_document = '95486' 30/01/2025 10:45:30 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 ( '95486' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '5' , '18.53' ) 30/01/2025 10:45:30 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 ( '95486' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 30/01/2025 10:45:30 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 ( '95486' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.65' , '1.65' , '0' , '0' , '1.65' ) 30/01/2025 10:45:30 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 ( '95486' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 30/01/2025 10:45:30 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 ( '95486' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 30/01/2025 11:10:00 am >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '95476' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-29') 30/01/2025 11:10:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '30/A', document_date = '2025-01-29', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'francesco', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '95476' 30/01/2025 11:10:00 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 = '95476' 30/01/2025 11:10:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95476' 30/01/2025 11:10:00 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 ( '95476' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 30/01/2025 11:13:53 am >> SELECT document_num FROM ps_document WHERE document_num = '14/A' AND id_document != '94924' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 30/01/2025 11:13:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '14/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '4150', id_supplier = '', id_address = '4679449', address1 = 'VIA LUIGI ANGRISANI 36 84100 SALERNO', address2 = '', note = 'E C 268 - acconto 30/1/25 € 70,00', 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 = '300.00', price_tax_excluded = '245.90', date_upd = NOW() WHERE id_document = '94924' 30/01/2025 11:13: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 = '94924' 30/01/2025 11:13:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94924' 30/01/2025 11:13: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 ( '94924' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 30/01/2025 11:16:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892221567' AND id_product != '16856' AND ean13 != '' 30/01/2025 11:16:29 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/3', ean13 = '9788892221567', date_upd = NOW() WHERE id_product = '16856' 30/01/2025 11:16:29 am >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO', description = '' WHERE id_product = '16856' 30/01/2025 11:16:29 am >> UPDATE ps_product SET wholesale_price = '3.19', on_sale = '0', price = '4.9000' WHERE id_product = '16856' 30/01/2025 11:16:29 am >> UPDATE ps_product_shop SET wholesale_price = '3.19', price = '4.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16856' 30/01/2025 11:16:29 am >> DELETE FROM ps_specific_price WHERE id_product = '16856' 30/01/2025 11:21:04 am >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 11:21: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' , '303' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 30/01/2025 11:21: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 = '95491' 30/01/2025 11:21:04 am >> DELETE FROM ps_document_detail WHERE id_document = '95491' 30/01/2025 11:21: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 ( '95491' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/01/2025 11:33:33 am >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 11:33: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' , '304' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 30/01/2025 11:33: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 = '95492' 30/01/2025 11:33:33 am >> DELETE FROM ps_document_detail WHERE id_document = '95492' 30/01/2025 11:33: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 ( '95492' , '23336' , 'DALMATICA - PDA004' , '1' , '-1' , '1' , '100.00' , '81.967213114754' , '22' , '0' , '100.00' ) 30/01/2025 11:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '95476' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-29') 30/01/2025 11:36:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '30/A', document_date = '2025-01-29', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'francesco MARIANI', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '95476' 30/01/2025 11:36:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95476' 30/01/2025 11:36:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95476' 30/01/2025 11:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95476' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 30/01/2025 11:43:50 am >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 11:43: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' , '305' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.48' , '157.77' , NOW() , NOW() ) 30/01/2025 11:43: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 = '95493' 30/01/2025 11:43:50 am >> DELETE FROM ps_document_detail WHERE id_document = '95493' 30/01/2025 11:43:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95493' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '3' , '-3' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '82.50' ) 30/01/2025 11:43:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95493' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 30/01/2025 11:43:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95493' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '19.98' ) 30/01/2025 11:47:05 am >> SELECT document_num FROM ps_document WHERE document_num = '306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 11:47: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 ( '11' , '306' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.34' , '20.34' , NOW() , NOW() ) 30/01/2025 11:47: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 = '95494' 30/01/2025 11:47:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95494' 30/01/2025 11:47: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 ( '95494' , '16856' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 30/01/2025 11:47: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 ( '95494' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 30/01/2025 11:47:29 am >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 11:47:29 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' , '307' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 30/01/2025 11:47: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 = '95495' 30/01/2025 11:47:29 am >> DELETE FROM ps_document_detail WHERE id_document = '95495' 30/01/2025 11:47: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 ( '95495' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 30/01/2025 12:16:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 12:16:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '308' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 30/01/2025 12:16:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95496' 30/01/2025 12:16:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '95496' 30/01/2025 12:16:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95496' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 30/01/2025 12:18:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 12:18:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '309' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 30/01/2025 12:18:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95497' 30/01/2025 12:18:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95497' 30/01/2025 12:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95497' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 30/01/2025 12:18:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 12:18:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '310' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '65.57' , NOW() , NOW() ) 30/01/2025 12:18:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95498' 30/01/2025 12:18:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95498' 30/01/2025 12:18:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95498' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/01/2025 12:18:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95498' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 30/01/2025 12:27:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '95491' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 12:27:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '303', document_date = '2025-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.00', price_tax_excluded = '3.85', date_upd = NOW() WHERE id_document = '95491' 30/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95491' 30/01/2025 12:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95491' 30/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95491' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/01/2025 12:27:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95491' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/01/2025 12:31:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829101915' AND id_product != '16163' AND ean13 != '' 30/01/2025 12:31:16 pm >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '8057829101915', date_upd = NOW() WHERE id_product = '16163' 30/01/2025 12:31:16 pm >> UPDATE ps_product_lang SET name = 'PARTICOLE DOMUS - PAN DI CENA', description = '' WHERE id_product = '16163' 30/01/2025 12:31:16 pm >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '3.3654' WHERE id_product = '16163' 30/01/2025 12:31:16 pm >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '3.3654', id_tax_rules_group = '3', id_category_default = '342', 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 = '16163' 30/01/2025 12:31:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '16163' 30/01/2025 12:34:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100093' AND id_product != '16164' AND ean13 != '' 30/01/2025 12:34:28 pm >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '8057829100093', date_upd = NOW() WHERE id_product = '16164' 30/01/2025 12:34:28 pm >> UPDATE ps_product_lang SET name = 'OSTIA TAGLIO CHIUSO - 72 - OTC25', description = '' WHERE id_product = '16164' 30/01/2025 12:34:28 pm >> UPDATE ps_product SET wholesale_price = '1.07', on_sale = '0', price = '1.923076923076923' WHERE id_product = '16164' 30/01/2025 12:34:28 pm >> UPDATE ps_product_shop SET wholesale_price = '1.07', price = '1.923076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '16164' 30/01/2025 12:34:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '16164' 30/01/2025 12:35:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '262/25' , '2025-01-27' , '25' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '848.85' , '816.21' , NOW() , NOW() ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95499' 30/01/2025 12:35:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95499' 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '7311' , 'OSTIA SOTTILE 74MM' , '200' , '200' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '223.9536' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '16689' , 'OSTIA PAN DI CENA mm80' , '200' , '200' , '3' , '1.2' , '1.1538461538462' , '4' , '3' , '242.1120' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '80' , '80' , '3' , '2' , '1.9230769230769' , '4' , '0' , '166.4000' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '100' , '100' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '111.9768' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20429' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20429' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '5' , '5' , '3' , '4' , '3.8461538461538' , '4' , '3' , '20.1760' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17711' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17711' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '5' , '5' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '10.5924' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '3' , '3' , '3' , '2.5' , '2.4038461538462' , '4' , '3' , '7.5660' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '5' , '5' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '10.5924' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '22' , '1' ) 30/01/2025 12:35:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95499' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '50' , '50' , '3' , '1.1' , '1.0576923076923' , '4' , '3' , '55.4840' ) 30/01/2025 12:35:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16164' AND id_supplier = '22' 30/01/2025 12:35:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16164' , '22' , '1' ) 30/01/2025 12:36:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '95491' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 12:36:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '303', document_date = '2025-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.00', price_tax_excluded = '3.85', date_upd = NOW() WHERE id_document = '95491' 30/01/2025 12:36:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95491' 30/01/2025 12:36:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '95491' 30/01/2025 12:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95491' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/01/2025 12:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95491' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 30/01/2025 03:04:32 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 't1AGdXZrbCQFbntN' , NOW() , NOW() ) 30/01/2025 03:04:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7122' , '1' ) 30/01/2025 03:04:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7122' , '2' ) 30/01/2025 03:04:32 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7122' , '3' ) 30/01/2025 03:09:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7122' 30/01/2025 03:09:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7122' , '10' , '171' , '' , 'LOTTI' , 'LEONARDO' , 'P. ZZA S. ANDREA 12' , '' , '57023' , 'CECINA' , '' , '' , '3313153966' , '' , '' , NOW() , NOW() ) 30/01/2025 03:09:19 pm >> UPDATE ps_customer SET email = 'parr.cecinaduomo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7122' 30/01/2025 03:10:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 03:10: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 ( '21' , '2' , '2025-01-30' , '' , '7122' , '0' , '177359069' , 'P. ZZA S. ANDREA 12 57023 CECINA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '124.16' , '124.16' , NOW() , NOW() ) 30/01/2025 03:10: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 = '14784' 30/01/2025 03:10:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '14784' 30/01/2025 03:10: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 ( '14784' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '82' , '-82' , '4' , '1.43' , '1.43' , '0' , '0' , '117.26' ) 30/01/2025 03:56:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 03:56:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '311' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 30/01/2025 03:56:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95500' 30/01/2025 03:56:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95500' 30/01/2025 03:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95500' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/01/2025 03:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95500' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 30/01/2025 04:03:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 04:03:13 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' , '312' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 30/01/2025 04:03:13 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 = '95501' 30/01/2025 04:03:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '95501' 30/01/2025 04:03:13 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 ( '95501' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 30/01/2025 04:12:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 04:12: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 ( '21' , '17' , '2025-01-30' , '' , '344' , '0' , '4679249' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.50' , '59.50' , NOW() , NOW() ) 30/01/2025 04:12: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 = '95502' 30/01/2025 04:12:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95502' 30/01/2025 04:12: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 ( '95502' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '25' , '-25' , '4' , '2.80' , '2.8' , '0' , '15' , '59.50' ) 30/01/2025 04:12:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1238' 30/01/2025 04:12:51 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1238' , '10' , '210' , 'PARR. S PIETRO, NICOLA E MARIA ASS.' , 'MONGIELLO' , 'DON FRANCESCO' , 'P.ZZA DUOMO, 1' , '' , '84096' , 'MONTECORVINO ROVELLA' , '' , '' , '' , '' , '80045670652' , NOW() , NOW() ) 30/01/2025 04:12:51 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1238' 30/01/2025 04:47:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 04:47:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '313' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 30/01/2025 04:47:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95503' 30/01/2025 04:47:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95503' 30/01/2025 04:47:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95503' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 30/01/2025 05:05:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 05:05:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '31/A' , '2025-01-30' , 'A' , '178' , '0' , '4679446' , 'VIA S. MARGHERITA 1 84129 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '165.00' , '135.25' , NOW() , NOW() ) 30/01/2025 05:05:11 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 = '95504' 30/01/2025 05:05:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '95504' 30/01/2025 05:05:11 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 ( '95504' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '6' , '-6' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '165.00' ) 30/01/2025 05:05:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '94983' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 30/01/2025 05:05:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '15/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4679440', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '284.80', price_tax_excluded = '252.56', date_upd = NOW() WHERE id_document = '94983' 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94983' 30/01/2025 05:05:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94983' 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '20758' , 'SEGNALIBRO 5X15' , '35' , '-35' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '7.00' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.8000' , '0.8' , '0' , '0' , '1.60' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '20629' , 'VITA FRATERNA IN COMUNITA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 30/01/2025 05:05:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94983' , '23257' , 'CON UN PIEDE IN PARADISO' , '6' , '-6' , '4' , '12.00' , '12' , '0' , '5' , '68.40' ) 30/01/2025 05:07:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 05:07: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' , '314' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.60' , NOW() , NOW() ) 30/01/2025 05:07: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 = '95505' 30/01/2025 05:07:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95505' 30/01/2025 05:07: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 ( '95505' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 30/01/2025 05:29:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 05:29:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '18' , '2025-01-30' , '' , '979' , '0' , '4671729' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 30/01/2025 05:29:23 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 = '95506' 30/01/2025 05:29:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '95506' 30/01/2025 05:29:23 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 ( '95506' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 30/01/2025 05:29:23 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 ( '95506' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '-6' , '4' , '2.4' , '2.4' , '0' , '15' , '12.24' ) 30/01/2025 05:29:23 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 ( '95506' , '' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.04' , '-0.04' , '0' , '0' , '-0.04' ) 30/01/2025 05:38:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 05:38:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '315' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '79.62' , NOW() , NOW() ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95507' 30/01/2025 05:38:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '95507' 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '18136' , 'CROCE - CC3' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '23155' , 'VITA CRISTIANA 2025' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '20949' , 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '21656' , 'SACRAMENTO DELL\'UNZIONE E CURA PASTORALE N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 30/01/2025 05:38:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95507' , '11154' , 'VASETTO BASSO CON ANELLO - 820' , '1' , '-1' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '18.50' ) 30/01/2025 05:43:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '235' AND id_document != '95403' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 30/01/2025 05:43:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '235', document_date = '2025-01-23', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '95403' 30/01/2025 05:43: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 = '95403' 30/01/2025 05:43:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95403' 30/01/2025 05:43: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 ( '95403' , '20901' , 'CASULA P/LANA AGNUS DEI - 8219-8249L' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 30/01/2025 05:47:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 05:47:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '316' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 30/01/2025 05:47:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95508' 30/01/2025 05:47:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95508' 30/01/2025 05:47:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95508' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/01/2025 05:47:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95508' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/01/2025 06:02:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '95502' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 06:02:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '17', document_date = '2025-01-30', document_letter = '', 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 = '15', id_causal = '0', price_tax_included = '59.50', price_tax_excluded = '59.50', date_upd = NOW() WHERE id_document = '95502' 30/01/2025 06:02: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 = '95502' 30/01/2025 06:02:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95502' 30/01/2025 06:02: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 ( '95502' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '25' , '-25' , '4' , '2.8000' , '2.8' , '0' , '15' , '59.50' ) 30/01/2025 07:03:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 07:03:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '317' , '2025-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '5.90' , NOW() , NOW() ) 30/01/2025 07:03:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95509' 30/01/2025 07:03:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '95509' 30/01/2025 07:03:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95509' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.9' , '5.9' , '0' , '0' , '5.90' ) 30/01/2025 07:07:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '255' AND id_document != '95429' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-25') 30/01/2025 07:07:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '255', document_date = '2025-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '95429' 30/01/2025 07:07:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95429' 30/01/2025 07:07:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95429' 30/01/2025 07:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95429' , '3807' , 'ELETTRICO LUMINI 10/EA 150 GG' , '2' , '-2' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '9.00' ) 30/01/2025 07:20:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-30') 30/01/2025 07:20:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '19' , '2025-01-30' , '' , '905' , '0' , '4679450' , 'VIA MAGGIORE, 1 84081 SAVA DI BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '88.06' , '88.06' , NOW() , NOW() ) 30/01/2025 07:20:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95510' 30/01/2025 07:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95510' 30/01/2025 07:20:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95510' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '37' , '-37' , '4' , '2.80' , '2.8' , '0' , '15' , '88.06' )