07/06/2024 08:29:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019308' AND id_product != '8302' AND ean13 != '' 07/06/2024 08:29:11 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788825019308', date_upd = NOW() WHERE id_product = '8302' 07/06/2024 08:29:11 am >> UPDATE ps_product_lang SET name = 'PREGHIERA E CONTEMPLAZIONE - A. GRUN', description = '' WHERE id_product = '8302' 07/06/2024 08:29:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.0000' WHERE id_product = '8302' 07/06/2024 08:29:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '41', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8302' 07/06/2024 08:29:11 am >> DELETE FROM ps_specific_price WHERE id_product = '8302' 07/06/2024 08:29:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019308' AND id_product != '8302' AND ean13 != '' 07/06/2024 08:29:15 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788825019308', date_upd = NOW() WHERE id_product = '8302' 07/06/2024 08:29:15 am >> UPDATE ps_product_lang SET name = 'PREGHIERA E CONTEMPLAZIONE - A. GRUN', description = '' WHERE id_product = '8302' 07/06/2024 08:29:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.0000' WHERE id_product = '8302' 07/06/2024 08:29:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8302' 07/06/2024 08:29:15 am >> DELETE FROM ps_specific_price WHERE id_product = '8302' 07/06/2024 09:04:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 09:04:08 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' , '1911' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '41.44' , NOW() , NOW() ) 07/06/2024 09:04:08 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 = '92203' 07/06/2024 09:04:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92203' 07/06/2024 09:04:08 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 ( '92203' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '16' , '-16' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '40.00' ) 07/06/2024 09:04:08 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 ( '92203' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 07/06/2024 09:04:08 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 ( '92203' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 07/06/2024 09:27:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1778' AND id_document != '92039' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 07/06/2024 09:27:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1778', document_date = '2024-05-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '29.00', price_tax_excluded = '23.77', date_upd = NOW() WHERE id_document = '92039' 07/06/2024 09:27:37 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 = '92039' 07/06/2024 09:27:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92039' 07/06/2024 09:27:37 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 ( '92039' , '7926' , 'PERGAMENE - BATTESIMO MOD. B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 07/06/2024 09:27:37 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 ( '92039' , '22542' , 'BRACCIALE DECINA COLORATA - BC507' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 07/06/2024 09:50:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 09:50:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1912' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 07/06/2024 09:50:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92204' 07/06/2024 09:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '92204' 07/06/2024 09:50:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92204' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 07/06/2024 09:53:33 am >> SELECT document_num FROM ps_document WHERE document_num = '13/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 09:53: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 ( '23' , '13/L' , '2024-06-07' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '575.50' , '471.72' , NOW() , NOW() ) 07/06/2024 09:53: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 = '92205' 07/06/2024 09:53:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92205' 07/06/2024 09:53: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 ( '92205' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967' , '22' , '0' , '20.00' ) 07/06/2024 09:53: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 ( '92205' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377' , '22' , '0' , '70.00' ) 07/06/2024 09:53:34 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 ( '92205' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.9836' , '22' , '0' , '100.00' ) 07/06/2024 09:53:34 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 ( '92205' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.0000' , '0.8197' , '22' , '0' , '4.00' ) 07/06/2024 09:53:34 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 ( '92205' , '22569' , 'MITRIA AVORIO - 86/000890' , '1' , '-1' , '1' , '329.0000' , '269.6721' , '22' , '0' , '329.00' ) 07/06/2024 09:53:34 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 ( '92205' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '3' , '-3' , '1' , '17.5000' , '14.3443' , '22' , '0' , '52.50' ) 07/06/2024 09:53:49 am >> DELETE FROM ps_document WHERE id_document = '91773' 07/06/2024 09:53:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91773' 07/06/2024 10:07:24 am >> SELECT document_num FROM ps_document WHERE document_num = '13/L' AND id_document != '92205' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 10:07:24 am >> UPDATE ps_document SET id_document_type = '23', document_num = '13/L', document_date = '2024-06-07', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4678843', 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 = '3', id_causal = '0', price_tax_included = '575.50', price_tax_excluded = '471.72', date_upd = NOW() WHERE id_document = '92205' 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92205' 07/06/2024 10:07:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92205' 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '4.00' ) 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '22569' , 'MITRIA AVORIO - 86/000890' , '1' , '-1' , '1' , '329.0000' , '269.67213114754' , '22' , '0' , '329.00' ) 07/06/2024 10:07:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92205' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '3' , '-3' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '52.50' ) 07/06/2024 10:44:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 10:44:49 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' , '1913' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '14.01' , NOW() , NOW() ) 07/06/2024 10:44: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 = '92206' 07/06/2024 10:44:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92206' 07/06/2024 10:44: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 ( '92206' , '22502' , 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 07/06/2024 10:44: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 ( '92206' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 07/06/2024 10:44: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 ( '92206' , '22145' , 'UN GIORNO DA RICORDARE - PRIMA COMUNIONE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 07/06/2024 10:44: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 ( '92206' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 07/06/2024 10:59:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552219' AND id_product != '22145' AND ean13 != '' 07/06/2024 10:59:30 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/6', ean13 = '9788831552219', date_upd = NOW() WHERE id_product = '22145' 07/06/2024 10:59:30 am >> UPDATE ps_product_lang SET name = 'UN GIORNO DA RICORDARE - PRIMA COMUNIONE', description = '' WHERE id_product = '22145' 07/06/2024 10:59:30 am >> UPDATE ps_product SET wholesale_price = '4.55', on_sale = '0', price = '7.0000' WHERE id_product = '22145' 07/06/2024 10:59:30 am >> UPDATE ps_product_shop SET wholesale_price = '4.55', price = '7.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22145' 07/06/2024 10:59:30 am >> DELETE FROM ps_specific_price WHERE id_product = '22145' 07/06/2024 11:32:05 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 11:32: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 ( '24' , '74/A' , '2024-06-07' , 'A' , '246' , '0' , '4676205' , 'VIA NAZIONALE DELLE CALABRIE, 3 84131 FUORNI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.15' , '86.37' , NOW() , NOW() ) 07/06/2024 11:32: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 = '92207' 07/06/2024 11:32:05 am >> DELETE FROM ps_document_detail WHERE id_document = '92207' 07/06/2024 11:32: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 ( '92207' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 07/06/2024 11:32: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 ( '92207' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '47' , '38.524590163934' , '22' , '0' , '47.00' ) 07/06/2024 11:32: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 ( '92207' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 07/06/2024 11:32: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 ( '92207' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 07/06/2024 11:32: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 ( '92207' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 07/06/2024 11:46:26 am >> SELECT document_num FROM ps_document WHERE document_num = '93' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 11:46:26 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 ( '21' , '93' , '2024-06-07' , '' , '203' , '0' , '2703' , 'VIA F. MANCUSI 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '83.30' , '83.30' , NOW() , NOW() ) 07/06/2024 11:46:26 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 = '92208' 07/06/2024 11:46:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92208' 07/06/2024 11:46:26 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 ( '92208' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '35' , '-35' , '4' , '2.80' , '2.8' , '0' , '15' , '83.30' ) 07/06/2024 11:48:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 11:48: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' , '1914' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.80' , '66.02' , NOW() , NOW() ) 07/06/2024 11:48: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 = '92209' 07/06/2024 11:48:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92209' 07/06/2024 11:48: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 ( '92209' , '20470' , 'CINGOLO LEGATO FILO ORO MEZZO FINO - CING37' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 07/06/2024 11:48: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 ( '92209' , '19097' , 'CINGOLO - CING04' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 07/06/2024 11:48: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 ( '92209' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '35' , '-35' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '24.50' ) 07/06/2024 11:48: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 ( '92209' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 07/06/2024 03:30:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 03:30:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1915' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 07/06/2024 03:30:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92210' 07/06/2024 03:30:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92210' 07/06/2024 03:30:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92210' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 07/06/2024 03:46:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2202403044' , '2024-04-30' , '' , '0' , '184' , '4679196' , 'VIALE NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '3056.10' , '2938.56' , NOW() , NOW() ) 07/06/2024 03:46:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92211' 07/06/2024 03:46:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92211' 07/06/2024 03:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92211' , '21899' , 'SACRA BIBBIA cei/uelci ' , '480' , '0' , '3' , '6.083' , '5.8490384615385' , '4' , '0' , '3036.6336' ) 07/06/2024 03:46:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21899' AND id_supplier = '184' 07/06/2024 03:46:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21899' , '184' , '1' ) 07/06/2024 03:46:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92211' , '' , 'parcheggio' , '1' , '0' , '3' , '18.72' , '18' , '4' , '0' , '19.4688' ) 07/06/2024 03:46:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '184' 07/06/2024 03:46:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '184' , '1' ) 07/06/2024 03:48:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '34' , '2002403529' , '2024-05-20' , '' , '0' , '184' , '4679196' , 'VIALE NAVIGAZIONE INTERNA 89 35027 NOVENTA PADOVANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.47' , '18.72' , NOW() , NOW() ) 07/06/2024 03:48:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92212' 07/06/2024 03:48:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92212' 07/06/2024 03:48:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92212' , '' , 'parcheggio' , '1' , '0' , '3' , '18.72' , '18' , '4' , '0' , '19.4688' ) 07/06/2024 03:48:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '184' 07/06/2024 03:48:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '184' , '1' ) 07/06/2024 03:55:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 03:55:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1916' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '2.16' , NOW() , NOW() ) 07/06/2024 03:55: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 = '92213' 07/06/2024 03:55:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92213' 07/06/2024 03:55: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 ( '92213' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/06/2024 03:55: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 ( '92213' , '5538' , 'LACCIO MARRONE' , '4' , '-4' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.20' ) 07/06/2024 05:31:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 05:31:56 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' , '1917' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '14.28' , NOW() , NOW() ) 07/06/2024 05:31:56 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 = '92214' 07/06/2024 05:31:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92214' 07/06/2024 05:31:56 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 ( '92214' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 07/06/2024 05:31:56 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 ( '92214' , '22452' , 'STORIA DI SANTA RITA DA CASCIA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 07/06/2024 05:31:56 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 ( '92214' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 07/06/2024 05:41:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 05:41:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1918' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 07/06/2024 05:41:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92215' 07/06/2024 05:41:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '92215' 07/06/2024 05:41:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92215' , '22530' , 'ANGELO ALI TORTORA - 4232' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/06/2024 07:02:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 07:02:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1919' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 07/06/2024 07:02:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92216' 07/06/2024 07:02:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92216' 07/06/2024 07:02:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92216' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '73.00' ) 07/06/2024 07:02:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92216' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 07/06/2024 07:46:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-07') 07/06/2024 07:46: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' , '1920' , '2024-06-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.80' , NOW() , NOW() ) 07/06/2024 07:46: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 = '92217' 07/06/2024 07:46:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92217' 07/06/2024 07:46: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 ( '92217' , '17349' , 'CROCE TRILOBATA H21 - CL56' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 07/06/2024 07:46: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 ( '92217' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 07/06/2024 07:46: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 ( '92217' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' )