21/11/2022 08:36:37 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1632' 21/11/2022 08:36:37 am >> 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 ( '1632' , '10' , '210' , '' , 'SPINELLI ' , 'DON GIUSEPPE' , 'P.ZZA PLEBISCITO, 11' , '' , '84030' , 'SANZA' , '' , '0975 322018' , '3476032958' , '' , '' , NOW() , NOW() ) 21/11/2022 08:36:37 am >> UPDATE ps_customer SET email = 'giuspi@tim.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1632' 21/11/2022 08:36:46 am >> SELECT document_num FROM ps_document WHERE document_num = '295' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 08:36:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '295' , '2022-11-21' , '' , '1632' , '0' , '4677361' , 'P.ZZA PLEBISCITO, 11 84030 SANZA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.25' , '39.25' , NOW() , NOW() ) 21/11/2022 08:36:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74242' 21/11/2022 08:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '74242' 21/11/2022 08:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74242' , '4154' , 'FESTA DEL PERDONO' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '5' , '31.35' ) 21/11/2022 08:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74242' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 21/11/2022 08:48:40 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/11/2022 08:48:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20435' , '1' , '' , 'nuovo-prodotto' ) 21/11/2022 08:48:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20435' , '1' , '1' , '2' , NOW() , NOW() ) 21/11/2022 08:48:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20435' , '0' , '1' , '0' , '0' ) 21/11/2022 08:49:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570645' AND id_product != '20435' AND ean13 != '' 21/11/2022 08:49:37 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788867570645', date_upd = NOW() WHERE id_product = '20435' 21/11/2022 08:49:37 am >> UPDATE ps_product_lang SET name = 'BIBBIA E IL TESORO NASCOSTO', description = '' WHERE id_product = '20435' 21/11/2022 08:49:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '20435' 21/11/2022 08:49:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20435' 21/11/2022 08:49:37 am >> DELETE FROM ps_specific_price WHERE id_product = '20435' 21/11/2022 08:50:35 am >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 08:50:35 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' , '296' , '2022-11-21' , '' , '260' , '0' , '4670956' , 'PIAZZA UMBERTO I, 2 03032 ARCE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '391.95' , '389.65' , NOW() , NOW() ) 21/11/2022 08:50:35 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 = '74243' 21/11/2022 08:50:35 am >> DELETE FROM ps_document_detail WHERE id_document = '74243' 21/11/2022 08:50:35 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 ( '74243' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '66' , '-66' , '4' , '3.50' , '3.5' , '0' , '15' , '196.35' ) 21/11/2022 08:50:35 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 ( '74243' , '20435' , 'BIBBIA E IL TESORO NASCOSTO' , '25' , '-25' , '4' , '4.50' , '4.5' , '0' , '10' , '101.25' ) 21/11/2022 08:50:35 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 ( '74243' , '13506' , 'SANTO ROSARIO' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '15' , '12.75' ) 21/11/2022 08:50:35 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 ( '74243' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '40' , '-40' , '4' , '2.40' , '2.4' , '0' , '15' , '81.60' ) 21/11/2022 09:19:53 am >> SELECT document_num FROM ps_document WHERE document_num = '297' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 09:19:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '297' , '2022-11-21' , '' , '3978' , '0' , '4677190' , 'VIA MALTA 3 83100 AVELLINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '76.50' , '76.50' , NOW() , NOW() ) 21/11/2022 09:19: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 = '74244' 21/11/2022 09:19:53 am >> DELETE FROM ps_document_detail WHERE id_document = '74244' 21/11/2022 09:19: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 ( '74244' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '15' , '76.50' ) 21/11/2022 09:29:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3978' 21/11/2022 09:29:54 am >> 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 ( '3978' , '10' , '130' , 'PARROCCHIA DEL ROSARIO' , 'MATERA' , 'PADRE GIOVANNI' , 'VIA MALTA 3' , '' , '83100' , 'AVELLINO' , '' , '082532012' , '3491341929' , '' , '80016810642' , NOW() , NOW() ) 21/11/2022 09:29:54 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3978' 21/11/2022 09:38:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 09:38: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' , '3527' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.25' , '18.25' , NOW() , NOW() ) 21/11/2022 09:38: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 = '74245' 21/11/2022 09:38:08 am >> DELETE FROM ps_document_detail WHERE id_document = '74245' 21/11/2022 09:38: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 ( '74245' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.25' , '18.25' , '0' , '0' , '18.25' ) 21/11/2022 09:38:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 21/11/2022 09:38:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 21/11/2022 09:55:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884046994' AND id_product != '18009' AND ean13 != '' 21/11/2022 09:55:11 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884046994', date_upd = NOW() WHERE id_product = '18009' 21/11/2022 09:55:11 am >> UPDATE ps_product_lang SET name = 'SCALA PIU\' CORTA PER SALIRE IN CIELO - 8011', description = '' WHERE id_product = '18009' 21/11/2022 09:55:11 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '18009' 21/11/2022 09:55:11 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18009' 21/11/2022 09:55:11 am >> DELETE FROM ps_specific_price WHERE id_product = '18009' 21/11/2022 10:02:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2085' 21/11/2022 10:02:44 am >> 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 ( '2085' , '10' , '210' , 'PARR. S. MARIA MAGGIORE' , 'FERRARESE ' , 'DON LORETO' , 'VIA COLLEGIATA' , '' , '84057' , 'LAURINO' , '' , '0974/941475' , '3398107111' , '' , '' , NOW() , NOW() ) 21/11/2022 10:02:44 am >> UPDATE ps_customer SET email = 'loreto.ferrarese@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2085' 21/11/2022 10:03:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2085' 21/11/2022 10:03:14 am >> 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 ( '2085' , '10' , '210' , 'PARR. S. MARIA MAGGIORE' , 'FERRARESE ' , 'DON LORETO' , 'VIA COLLEGIATA' , '' , '84057' , 'LAURINO' , '' , '0974/941475' , '3398107111' , '' , '93010520653' , NOW() , NOW() ) 21/11/2022 10:03:14 am >> UPDATE ps_customer SET email = 'loreto.ferrarese@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2085' 21/11/2022 10:11:17 am >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 10:11:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '298' , '2022-11-21' , '' , '2085' , '0' , '4677364' , 'VIA COLLEGIATA 84057 LAURINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '95.89' , '95.08' , NOW() , NOW() ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74246' 21/11/2022 10:11:17 am >> DELETE FROM ps_document_detail WHERE id_document = '74246' 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '15' , '32.73' ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '15' , '23.80' ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '15' , '14.88' ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '15' , '17.00' ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 21/11/2022 10:11:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74246' , '8855' , 'REGISTRO DEL CATECHISTA' , '6' , '-6' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '4.50' ) 21/11/2022 10:18:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3063' AND id_document != '66370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 21/11/2022 10:18:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3063', document_date = '2022-10-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.80', price_tax_excluded = '9.67', date_upd = NOW() WHERE id_document = '66370' 21/11/2022 10:18:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66370' 21/11/2022 10:18:09 am >> DELETE FROM ps_document_detail WHERE id_document = '66370' 21/11/2022 10:18:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66370' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '4' , '-4' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.80' ) 21/11/2022 10:18:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 21/11/2022 10:18:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 21/11/2022 10:18:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66370' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 21/11/2022 10:18:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13142' AND id_supplier = '' 21/11/2022 10:18:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13142' , '' , '1' ) 21/11/2022 10:20:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/11/2022 10:20:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20436' , '1' , '' , 'nuovo-prodotto' ) 21/11/2022 10:20:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20436' , '1' , '1' , '2' , NOW() , NOW() ) 21/11/2022 10:20:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20436' , '0' , '1' , '0' , '0' ) 21/11/2022 10:42:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 10:42:30 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' , '3528' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 21/11/2022 10:42: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 = '74247' 21/11/2022 10:42:30 am >> DELETE FROM ps_document_detail WHERE id_document = '74247' 21/11/2022 10:42: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 ( '74247' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '43' , '35.245901639344' , '22' , '0' , '43.00' ) 21/11/2022 10:42:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 21/11/2022 10:42:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 21/11/2022 10:47:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 10:47:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3529' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 21/11/2022 10:47:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74248' 21/11/2022 10:47:38 am >> DELETE FROM ps_document_detail WHERE id_document = '74248' 21/11/2022 10:47:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74248' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 21/11/2022 10:47:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 21/11/2022 10:47:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 21/11/2022 10:51:22 am >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 10:51: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 ( '21' , '299' , '2022-11-21' , '' , '2320' , '0' , '4671036' , 'VIA CONVENTO, 12 75011 ACCETTURA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '195.50' , '195.50' , NOW() , NOW() ) 21/11/2022 10:51: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 = '74249' 21/11/2022 10:51:22 am >> DELETE FROM ps_document_detail WHERE id_document = '74249' 21/11/2022 10:51: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 ( '74249' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '100' , '-100' , '4' , '1.90' , '1.9' , '0' , '15' , '161.50' ) 21/11/2022 10:51: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 ( '74249' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '15' , '34.00' ) 21/11/2022 11:07:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555272' AND id_product != '20436' AND ean13 != '' 21/11/2022 11:07:42 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788831555272', date_upd = NOW() WHERE id_product = '20436' 21/11/2022 11:07:42 am >> UPDATE ps_product_lang SET name = 'MARIA GREMBO DI DIO', description = '' WHERE id_product = '20436' 21/11/2022 11:07:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20436' 21/11/2022 11:07:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', 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 = '20436' 21/11/2022 11:07:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20436' 21/11/2022 11:07:44 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20436' 21/11/2022 11:07:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20437' , '1' , '' , 'nuovo-prodotto' ) 21/11/2022 11:07:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20437' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20436' 21/11/2022 11:07:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20437' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20436' 21/11/2022 11:09:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '615683' , '2022-11-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.14' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '182.44' , '182.44' , NOW() , NOW() ) 21/11/2022 11:09:03 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 = '74250' 21/11/2022 11:09:03 am >> DELETE FROM ps_document_detail WHERE id_document = '74250' 21/11/2022 11:09:03 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 ( '74250' , '3657' , 'DON PEPPINO DIANA' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '3657' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3657' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '20199' , 'PAROLA DI DIO OGNI GIORNO 2023 - V. PAGLIA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '20199' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20199' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '17072' , 'S. ALFONSO M. DE LIGUORI E LE MISSIONI POPOLARI - R. DADDIO' , '1' , '1' , '4' , '11.00' , '11' , '0' , '30' , '7.7000' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17072' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17072' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '1103' , 'BIBBIA COME PAROLA DI DIO - MANNUCCI/MAZZINGHI' , '1' , '1' , '4' , '38.00' , '38' , '0' , '30' , '26.6000' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1103' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1103' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '17393' , 'BREVE STORIA DELLA CHIESA - A. FRANZEN' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17393' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17393' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '20435' , 'BIBBIA E IL TESORO NASCOSTO' , '24' , '24' , '4' , '4.50' , '4.5' , '0' , '30' , '75.6000' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '20435' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20435' , '7' , '1' ) 21/11/2022 11:09:03 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 ( '74250' , '20435' , 'BIBBIA E IL TESORO NASCOSTO' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '100' , '0.0000' ) 21/11/2022 11:09:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '20435' AND id_supplier = '7' 21/11/2022 11:09:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20435' , '7' , '1' ) 21/11/2022 11:09: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 ( '74250' , '20436' , 'MARIA GREMBO DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 21/11/2022 11:09:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '20436' AND id_supplier = '7' 21/11/2022 11:09:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20436' , '7' , '1' ) 21/11/2022 11:09: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 ( '74250' , '13002' , 'ECCOMI TI ASCOLTO! - ANNO B - G. CALABRESE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 21/11/2022 11:09:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '13002' AND id_supplier = '7' 21/11/2022 11:09:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13002' , '7' , '1' ) 21/11/2022 11:09: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 ( '74250' , '14640' , 'ECCOMI TI ASCOLTO! - ANNO C - G. CALABRESE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 21/11/2022 11:09:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '14640' AND id_supplier = '7' 21/11/2022 11:09:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14640' , '7' , '1' ) 21/11/2022 11:09: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 ( '74250' , '9307' , 'SACRAMENTI SPIEGATI AI BAMBINI' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 21/11/2022 11:09:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9307' AND id_supplier = '7' 21/11/2022 11:09:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9307' , '7' , '1' ) 21/11/2022 11:43:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 11:43: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' , '3530' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.40' , '63.33' , NOW() , NOW() ) 21/11/2022 11:43: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 = '74251' 21/11/2022 11:43:27 am >> DELETE FROM ps_document_detail WHERE id_document = '74251' 21/11/2022 11:43: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 ( '74251' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/11/2022 11:43:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 21/11/2022 11:43:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 21/11/2022 11:43: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 ( '74251' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 21/11/2022 11:43:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 21/11/2022 11:43:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 21/11/2022 11:43: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 ( '74251' , '8420' , 'PREPARIAMO IL NATALE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 21/11/2022 11:43:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '8420' AND id_supplier = '' 21/11/2022 11:43:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8420' , '' , '1' ) 21/11/2022 11:43: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 ( '74251' , '20089' , 'CALENDARIO DA TAVOLO 2023 - 40806' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 21/11/2022 11:43:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20089' AND id_supplier = '' 21/11/2022 11:43:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20089' , '' , '1' ) 21/11/2022 11:43:37 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 11:43:37 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' , '300' , '2022-11-21' , '' , '6' , '0' , '4670981' , 'VIA ROMOLO BALZANO, 74 00177 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 21/11/2022 11:43: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 = '74252' 21/11/2022 11:43:37 am >> DELETE FROM ps_document_detail WHERE id_document = '74252' 21/11/2022 11:43: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 ( '74252' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '35' , '-35' , '4' , '1.60' , '1.6' , '0' , '15' , '47.60' ) 21/11/2022 11:44:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 11:44:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3531' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 21/11/2022 11:44:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74253' 21/11/2022 11:44:58 am >> DELETE FROM ps_document_detail WHERE id_document = '74253' 21/11/2022 11:44:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74253' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 21/11/2022 11:44:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20247' AND id_supplier = '' 21/11/2022 11:44:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20247' , '' , '1' ) 21/11/2022 11:48:29 am >> SELECT document_num FROM ps_document WHERE document_num = '301' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 11:48: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 ( '21' , '301' , '2022-11-21' , '' , '2630' , '0' , '4673397' , 'VIA LOMBARDA, 189 55013 LAMMARI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '106.25' , '106.25' , NOW() , NOW() ) 21/11/2022 11:48: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 = '74254' 21/11/2022 11:48:29 am >> DELETE FROM ps_document_detail WHERE id_document = '74254' 21/11/2022 11:48: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 ( '74254' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '15' , '106.25' ) 21/11/2022 12:17:14 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '353' 21/11/2022 12:17:14 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 ( '353' , '10' , '134' , 'PARROCCHIA S. ANNA E S. ANTONIO' , 'RAVIELE ' , 'MONS. ANTONIO' , 'C.DA EPITAFFIO' , '' , '82100' , 'BENEVENTO' , 'ORDINA: CARMELA ALBANO 3404991624/ DA SPEDIRE: LUDOTECA PAESE DEI BALOCCHI - VIA EPITAFFIO 104 LUN VEN 8,00/16,00\r\nPIZZO MAURO FERRAMENTA - VIA EPITAFFIO 161 - 82100 BENEVENTO' , '3381240462' , '' , '' , '92025620623' , NOW() , NOW() ) 21/11/2022 12:17:14 pm >> UPDATE ps_customer SET email = 'antonioraviele@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '353' 21/11/2022 12:19:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '302' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 12:19:04 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' , '302' , '2022-11-21' , '' , '353' , '0' , '4677365' , 'C.DA EPITAFFIO 82100 BENEVENTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '84.84' , '84.84' , NOW() , NOW() ) 21/11/2022 12:19:04 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 = '74255' 21/11/2022 12:19:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '74255' 21/11/2022 12:19:04 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 ( '74255' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '11' , '-11' , '4' , '2.40' , '2.4' , '0' , '15' , '22.44' ) 21/11/2022 12:19:04 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 ( '74255' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 12:19:04 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 ( '74255' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 21/11/2022 12:20:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 12:20:33 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' , '3532' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.20' , '148.20' , NOW() , NOW() ) 21/11/2022 12:20:33 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 = '74256' 21/11/2022 12:20:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '74256' 21/11/2022 12:20:33 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 ( '74256' , '1103' , 'BIBBIA COME PAROLA DI DIO - MANNUCCI/MAZZINGHI' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 21/11/2022 12:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1103' AND id_supplier = '' 21/11/2022 12:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1103' , '' , '1' ) 21/11/2022 12:20:34 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 ( '74256' , '17393' , 'BREVE STORIA DELLA CHIESA - A. FRANZEN' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 21/11/2022 12:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17393' AND id_supplier = '' 21/11/2022 12:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17393' , '' , '1' ) 21/11/2022 12:20:34 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 ( '74256' , '13031' , 'METAFISICA DEL CONCRETO - T. MELENDO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 21/11/2022 12:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13031' AND id_supplier = '' 21/11/2022 12:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13031' , '' , '1' ) 21/11/2022 12:20:34 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 ( '74256' , '18183' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - G. DE VIRGILIO' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 21/11/2022 12:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18183' AND id_supplier = '' 21/11/2022 12:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18183' , '' , '1' ) 21/11/2022 12:20:34 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 ( '74256' , '18808' , 'INTRODUZIONE AL PENTATEUCO - M. TABET' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 21/11/2022 12:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18808' AND id_supplier = '' 21/11/2022 12:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18808' , '' , '1' ) 21/11/2022 12:35:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '353' 21/11/2022 12:35:04 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 ( '353' , '10' , '134' , 'PARROCCHIA S. ANNA E S. ANTONIO' , 'RAVIELE ' , 'MONS. ANTONIO' , 'C.DA EPITAFFIO' , '' , '82100' , 'BENEVENTO' , 'ORDINA: CARMELA ALBANO 3404991624/ DA SPEDIRE: LUDOTECA PAESE DEI BALOCCHI - VIA EPITAFFIO 104 LUN VEN 8,00/16,00\r\nPIZZO MAURO FERRAMENTA - VIA EPITAFFIO 161 - 82100 BENEVENTO' , '3381240462' , '' , '' , '92025620623' , NOW() , NOW() ) 21/11/2022 12:35:04 pm >> UPDATE ps_customer SET email = 'antonioraviele@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '353' 21/11/2022 12:48:21 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '398/2022', document_date = '2022-10-24', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '4670548', address1 = 'VIA CARRAIA,4/6/8 55025 COREGLIA ANTELMINELLI', address2 = '', note = '', price_shipping = '14.99', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '321.12', price_tax_excluded = '263.21', date_upd = NOW() WHERE id_document = '68082' 21/11/2022 12:48:21 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 = '68082' 21/11/2022 12:48:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '68082' 21/11/2022 12:48:21 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 ( '68082' , '3179' , 'CROCIFISSO - CM 40 - 1003' , '1' , '1' , '1' , '17.7600' , '14.55737704918' , '22' , '5' , '20.58' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3179' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3179' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '17077' , 'IMMACOLATA DEL MURILLO CM 33 - 610' , '1' , '1' , '1' , '24.0000' , '19.672131147541' , '22' , '5' , '27.82' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17077' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17077' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '20232' , 'STATUA ADDOLORATA CM 28 - 608' , '1' , '1' , '1' , '24.0000' , '19.672131147541' , '22' , '5' , '27.82' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20232' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20232' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '18615' , 'SAN ROCCO CM 20 - 340' , '1' , '1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '13.91' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18615' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18615' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '17078' , 'MIRACOLOSA CM 40 - 803' , '1' , '1' , '1' , '32.4000' , '26.55737704918' , '22' , '5' , '37.55' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17078' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17078' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '19625' , 'CROCIFISSO CM 30 - 1004' , '1' , '1' , '1' , '14.5200' , '11.901639344262' , '22' , '5' , '16.83' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19625' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19625' , '' , '1' ) 21/11/2022 12:48:21 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 ( '68082' , '18080' , 'BAMBINO DI PRAGA CM 20 - 311' , '1' , '1' , '1' , '12.6000' , '10.327868852459' , '22' , '5' , '14.60' ) 21/11/2022 12:48:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18080' AND id_supplier = '' 21/11/2022 12:48:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18080' , '' , '1' ) 21/11/2022 12:48:22 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 ( '68082' , '20233' , 'STATUA BEATO CARLO ACUTIS CM 28 - 425' , '1' , '1' , '1' , '22.0000' , '18.032786885246' , '22' , '5' , '25.50' ) 21/11/2022 12:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20233' AND id_supplier = '' 21/11/2022 12:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20233' , '' , '1' ) 21/11/2022 12:48:22 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 ( '68082' , '20234' , 'STATUA MADONNA DEL ROSARIO CM 30 - 631 ' , '1' , '1' , '1' , '22.8000' , '18.688524590164' , '22' , '5' , '26.43' ) 21/11/2022 12:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20234' AND id_supplier = '' 21/11/2022 12:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20234' , '' , '1' ) 21/11/2022 12:48:22 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 ( '68082' , '16516' , 'SANTANNA CM 30 - 626' , '3' , '3' , '1' , '26.4000' , '21.639344262295' , '22' , '5' , '91.79' ) 21/11/2022 12:48:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16516' AND id_supplier = '' 21/11/2022 12:48:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16516' , '' , '1' ) 21/11/2022 01:05:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '559' 21/11/2022 01:05:50 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 ( '559' , '10' , '210' , 'PARROCCHIA SANTA TERESA DEL BAMBINO GESU\'' , 'PICCOLO' , 'DON LUIGI' , 'VIA TAVERNA DELLE ROSE' , '' , '84091' , 'BATTIPAGLIA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 21/11/2022 01:05:50 pm >> UPDATE ps_customer SET email = 'parrocchia.steresa@tin.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '559' 21/11/2022 01:06:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '559' 21/11/2022 01:06:58 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 ( '559' , '10' , '210' , 'PARROCCHIA SANTA TERESA DEL BAMBINO GESU\'' , 'PICCOLO' , 'DON LUIGI' , 'VIA TAVERNA DELLE ROSE' , '' , '84091' , 'BATTIPAGLIA' , '' , '' , '' , '' , '91001560654' , NOW() , NOW() ) 21/11/2022 01:06:58 pm >> UPDATE ps_customer SET email = 'parrocchia.steresa@tin.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '559' 21/11/2022 01:09:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 01:09:19 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' , '303' , '2022-11-21' , '' , '559' , '0' , '4677368' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '366.35' , '366.35' , NOW() , NOW() ) 21/11/2022 01:09:19 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 = '74257' 21/11/2022 01:09:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '74257' 21/11/2022 01:09:19 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 ( '74257' , '2679' , 'CONOSCERE GESU\'' , '19' , '-19' , '4' , '3.50' , '3.5' , '0' , '15' , '56.52' ) 21/11/2022 01:09:19 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 ( '74257' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '22' , '-22' , '4' , '3.50' , '3.5' , '0' , '15' , '65.45' ) 21/11/2022 01:09:19 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 ( '74257' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 21/11/2022 01:09:20 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 ( '74257' , '9675' , 'SARETE MIEI TESTIMONI' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 21/11/2022 01:09:20 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 ( '74257' , '4120' , 'FEDE NELLO ZAINETTO' , '32' , '-32' , '4' , '5.00' , '5' , '0' , '15' , '136.00' ) 21/11/2022 01:10:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 01:10:40 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' , '3533' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '175.00' , NOW() , NOW() ) 21/11/2022 01:10:40 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 = '74258' 21/11/2022 01:10:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '74258' 21/11/2022 01:10:40 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 ( '74258' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '35' , '-35' , '4' , '5' , '5' , '0' , '0' , '175.00' ) 21/11/2022 01:10:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 21/11/2022 01:10:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 21/11/2022 01:12:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 01:12:20 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' , '3534' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 21/11/2022 01:12:20 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 = '74259' 21/11/2022 01:12:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '74259' 21/11/2022 01:12:20 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 ( '74259' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 21/11/2022 01:12:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 21/11/2022 01:12:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 21/11/2022 01:12:20 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 ( '74259' , '6810' , 'MOCCOLO 80X150' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 21/11/2022 01:12:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6810' AND id_supplier = '' 21/11/2022 01:12:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6810' , '' , '1' ) 21/11/2022 01:12:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 01:12:47 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' , '3535' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.55' , '19.55' , NOW() , NOW() ) 21/11/2022 01:12:47 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 = '74260' 21/11/2022 01:12:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '74260' 21/11/2022 01:12:47 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 ( '74260' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/11/2022 01:12:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 21/11/2022 01:12:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 21/11/2022 01:12:47 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 ( '74260' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 21/11/2022 01:12:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 21/11/2022 01:12:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 21/11/2022 03:18:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:18:10 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' , '304' , '2022-11-21' , '' , '2441' , '0' , '4673030' , 'VIA GIULIANI, 136 84069 ROCCADASPIDE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.23' , '109.23' , NOW() , NOW() ) 21/11/2022 03:18:10 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 = '74261' 21/11/2022 03:18:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '74261' 21/11/2022 03:18:10 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 ( '74261' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 21/11/2022 03:18:10 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 ( '74261' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 21/11/2022 03:18:10 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 ( '74261' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 21/11/2022 03:19:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:19:44 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' , '3536' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 21/11/2022 03:19:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74262' 21/11/2022 03:19:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '74262' 21/11/2022 03:19:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74262' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 21/11/2022 03:19:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 21/11/2022 03:19:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 21/11/2022 03:28:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:28:01 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' , '3537' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 21/11/2022 03:28:01 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 = '74263' 21/11/2022 03:28:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '74263' 21/11/2022 03:28:01 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 ( '74263' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 21/11/2022 03:28:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2164' AND id_supplier = '' 21/11/2022 03:28:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2164' , '' , '1' ) 21/11/2022 03:33:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:33:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3538' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.40' , '2.79' , NOW() , NOW() ) 21/11/2022 03:33:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74264' 21/11/2022 03:33:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '74264' 21/11/2022 03:33:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74264' , '16314' , 'BAMBINO CM 6' , '2' , '-2' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '3.40' ) 21/11/2022 03:33:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 21/11/2022 03:33:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 21/11/2022 03:33:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '74261' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:33:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '304', document_date = '2022-11-21', document_letter = '', id_customer = '2441', id_supplier = '', id_address = '4673030', address1 = 'VIA GIULIANI, 136 84069 ROCCADASPIDE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '109.23', price_tax_excluded = '109.23', date_upd = NOW() WHERE id_document = '74261' 21/11/2022 03:33:39 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 = '74261' 21/11/2022 03:33:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '74261' 21/11/2022 03:33:39 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 ( '74261' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 21/11/2022 03:33:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 21/11/2022 03:33:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 21/11/2022 03:33:39 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 ( '74261' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 21/11/2022 03:33:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 21/11/2022 03:33:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 21/11/2022 03:33:39 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 ( '74261' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 21/11/2022 03:33:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 21/11/2022 03:33:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 21/11/2022 03:43:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 21/11/2022 03:43:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '111.90', price_tax_excluded = '109.70', date_upd = NOW() WHERE id_document = '61794' 21/11/2022 03:43:52 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 = '61794' 21/11/2022 03:43:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 21/11/2022 03:43:52 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 ( '61794' , '20036' , 'PAROLA E PREGHIERA - DIC 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20036' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20036' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '20248' , 'FORZA DELLO SPIRITO - C. MIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20248' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20248' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '20313' , 'TERRA DI DIO - M.S. MOSTAJO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20313' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20313' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '18951' , 'ECCO TUA MADRE - A. PIGNA' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '0' , '24.00' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18951' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18951' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '20329' , 'GIOCARE CON DIO - ALBINO LUCIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20329' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20329' , '' , '1' ) 21/11/2022 03:43:52 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 ( '61794' , '20426' , 'PERCHE CREDERE? - F. SHEEN' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 21/11/2022 03:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20426' AND id_supplier = '' 21/11/2022 03:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20426' , '' , '1' ) 21/11/2022 03:54:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:54: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 ( '21' , '305' , '2022-11-21' , '' , '3971' , '0' , '4677010' , 'CORSO GIOVE 88837 PETILIA POLICASTRO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.40' , '181.40' , NOW() , NOW() ) 21/11/2022 03:54: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 = '74265' 21/11/2022 03:54:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '74265' 21/11/2022 03:54: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 ( '74265' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:54: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 ( '74265' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:54: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 ( '74265' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:54: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 ( '74265' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 21/11/2022 03:55:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '74265' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 03:55:43 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '305', document_date = '2022-11-21', document_letter = '', id_customer = '3971', id_supplier = '', id_address = '4677010', address1 = 'CORSO GIOVE 88837 PETILIA POLICASTRO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '181.40', price_tax_excluded = '181.40', date_upd = NOW() WHERE id_document = '74265' 21/11/2022 03:55: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 = '74265' 21/11/2022 03:55:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '74265' 21/11/2022 03:55: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 ( '74265' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 21/11/2022 03:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 21/11/2022 03:55: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 ( '74265' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 21/11/2022 03:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 21/11/2022 03:55: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 ( '74265' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 21/11/2022 03:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 21/11/2022 03:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 21/11/2022 03:55: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 ( '74265' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 21/11/2022 03:55:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 21/11/2022 03:55:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 21/11/2022 04:08:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 04:08: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' , '3539' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.61' , '54.79' , NOW() , NOW() ) 21/11/2022 04:08: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 = '74266' 21/11/2022 04:08:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '74266' 21/11/2022 04:08: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 ( '74266' , '19150' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 21/11/2022 04:08:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '' 21/11/2022 04:08:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '' , '1' ) 21/11/2022 04:08: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 ( '74266' , '16128' , 'DOMENICHE DA COLORARE - ANNO A' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 21/11/2022 04:08:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16128' AND id_supplier = '' 21/11/2022 04:08:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16128' , '' , '1' ) 21/11/2022 04:15:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3443' AND id_document != '72576' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-12') 21/11/2022 04:15:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3443', document_date = '2022-11-12', 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 = '37.80', price_tax_excluded = '37.80', date_upd = NOW() WHERE id_document = '72576' 21/11/2022 04:15:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '72576' 21/11/2022 04:15:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '72576' 21/11/2022 04:15:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72576' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 21/11/2022 04:15:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10060' AND id_supplier = '' 21/11/2022 04:15:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10060' , '' , '1' ) 21/11/2022 04:15:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72576' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 21/11/2022 04:15:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 21/11/2022 04:15:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 21/11/2022 04:15:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72576' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 21/11/2022 04:15:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 21/11/2022 04:15:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 21/11/2022 04:15: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 ( '72576' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '1.7' , '1.7' , '0' , '0' , '1.70' ) 21/11/2022 04:15:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '' 21/11/2022 04:15:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '' , '1' ) 21/11/2022 04:40:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000539' AND id_product != '1626' AND ean13 != '' 21/11/2022 04:40:58 pm >> UPDATE ps_product SET id_supplier = '73', reference = '2014', ean13 = '000539', date_upd = NOW() WHERE id_product = '1626' 21/11/2022 04:40:58 pm >> UPDATE ps_product_lang SET name = 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ', description = '' WHERE id_product = '1626' 21/11/2022 04:40:59 pm >> UPDATE ps_product SET wholesale_price = '32.00', on_sale = '0', price = '57.37704918032787' WHERE id_product = '1626' 21/11/2022 04:40:59 pm >> UPDATE ps_product_shop SET wholesale_price = '32.00', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '227', 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 = '1626' 21/11/2022 04:40:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '1626' 21/11/2022 04:43:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002069' AND id_product != '20437' AND ean13 != '' 21/11/2022 04:43:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002069', date_upd = NOW() WHERE id_product = '20437' 21/11/2022 04:43:16 pm >> UPDATE ps_product_lang SET name = 'LUMINO BIANCO 10BTS000', description = '' WHERE id_product = '20437' 21/11/2022 04:43:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '20437' 21/11/2022 04:43:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '227', 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 = '20437' 21/11/2022 04:43:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '20437' 21/11/2022 04:43:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20437' 21/11/2022 04:43:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20438' , '1' , '' , 'nuovo-prodotto' ) 21/11/2022 04:43:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20438' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20437' 21/11/2022 04:43:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20438' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20437' 21/11/2022 04:44:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002070' AND id_product != '20438' AND ean13 != '' 21/11/2022 04:44:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002070', date_upd = NOW() WHERE id_product = '20438' 21/11/2022 04:44:53 pm >> UPDATE ps_product_lang SET name = 'CANDELE VOTIVE 20X40 3B', description = '' WHERE id_product = '20438' 21/11/2022 04:44:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '57.37704918032787' WHERE id_product = '20438' 21/11/2022 04:44:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '227', 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 = '20438' 21/11/2022 04:44:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20438' 21/11/2022 04:44:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20438' 21/11/2022 04:44:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20439' , '1' , '' , 'nuovo-prodotto' ) 21/11/2022 04:44:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20439' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20438' 21/11/2022 04:44:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20439' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20438' 21/11/2022 04:45:25 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' , '633/X' , '2022-11-17' , 'X' , '0' , '73' , '2668' , 'VIA P. TRIBOLDI, 4 26015 SORESINA' , '' , '' , '70' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '1677.26' , '1374.80' , NOW() , NOW() ) 21/11/2022 04:45:25 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 = '74267' 21/11/2022 04:45:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '74267' 21/11/2022 04:45:25 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 ( '74267' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '20' , '20' , '1' , '34.4' , '28.196721311475' , '22' , '0' , '839.3600' ) 21/11/2022 04:45:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '73' 21/11/2022 04:45:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '73' , '1' ) 21/11/2022 04:45:25 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 ( '74267' , '20437' , 'LUMINO BIANCO 10BTS000' , '960' , '960' , '1' , '0.24' , '0.19672131147541' , '22' , '0' , '281.0880' ) 21/11/2022 04:45:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20437' AND id_supplier = '73' 21/11/2022 04:45:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20437' , '73' , '1' ) 21/11/2022 04:45:25 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 ( '74267' , '19150' , 'MOCCOLO 70X200' , '24' , '24' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '93.6960' ) 21/11/2022 04:45:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19150' AND id_supplier = '73' 21/11/2022 04:45:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19150' , '73' , '1' ) 21/11/2022 04:45:25 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 ( '74267' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '9' , '9' , '1' , '34.4' , '28.196721311475' , '22' , '0' , '377.7120' ) 21/11/2022 04:45:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20438' AND id_supplier = '73' 21/11/2022 04:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20438' , '73' , '1' ) 21/11/2022 04:45:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0210482' AND id_product != '6014' AND ean13 != '' 21/11/2022 04:45:54 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2016', ean13 = '0210482', date_upd = NOW() WHERE id_product = '6014' 21/11/2022 04:45:54 pm >> UPDATE ps_product_lang SET name = 'LUMINO BIANCO - 10B', description = '' WHERE id_product = '6014' 21/11/2022 04:45:54 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '6014' 21/11/2022 04:45:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '205', 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 = '6014' 21/11/2022 04:45:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '6014' 21/11/2022 04:46:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0210481' AND id_product != '6019' AND ean13 != '' 21/11/2022 04:46:24 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2016', ean13 = '0210481', date_upd = NOW() WHERE id_product = '6019' 21/11/2022 04:46:24 pm >> UPDATE ps_product_lang SET name = 'LUMINO ROSSO - 10B', description = '' WHERE id_product = '6019' 21/11/2022 04:46:24 pm >> UPDATE ps_product SET wholesale_price = '0.16', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '6019' 21/11/2022 04:46:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.16', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '205', 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 = '6019' 21/11/2022 04:46:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '6019' 21/11/2022 05:04:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 05:04:02 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' , '3540' , '2022-11-21' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '349.00' , '293.01' , NOW() , NOW() ) 21/11/2022 05:04:02 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 = '74268' 21/11/2022 05:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '74268' 21/11/2022 05:04:02 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 ( '74268' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 21/11/2022 05:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 21/11/2022 05:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 21/11/2022 05:04:02 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 ( '74268' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 21/11/2022 05:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 21/11/2022 05:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 21/11/2022 05:04:02 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 ( '74268' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/11/2022 05:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 21/11/2022 05:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 21/11/2022 05:04:02 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 ( '74268' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 21/11/2022 05:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 21/11/2022 05:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 21/11/2022 05:04:02 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 ( '74268' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11' , '11' , '0' , '0' , '11.00' ) 21/11/2022 05:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 21/11/2022 05:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 21/11/2022 07:10:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-11-21') 21/11/2022 07:10:08 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' , '35' , '2022-11-21' , '' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'cappellania OSPEDALE DA PROCIDA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.90' , '108.11' , NOW() , NOW() ) 21/11/2022 07:10:08 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 = '74269' 21/11/2022 07:10:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '74269' 21/11/2022 07:10:08 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 ( '74269' , '19748' , 'CORONA D\'AVVENTO STELLE' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 21/11/2022 07:10:08 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 ( '74269' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '26.00' ) 21/11/2022 07:10:08 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 ( '74269' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/11/2022 07:10:08 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 ( '74269' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' )