21/01/2023 09:33:34 am >> SELECT document_num FROM ps_document WHERE document_num = '214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 09:33:34 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' , '214' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.75' , '64.75' , NOW() , NOW() ) 21/01/2023 09:33:34 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 = '80450' 21/01/2023 09:33:34 am >> DELETE FROM ps_document_detail WHERE id_document = '80450' 21/01/2023 09:33:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80450' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.5' , '1.5' , '0' , '0' , '60.00' ) 21/01/2023 09:33:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80450' , '20501' , 'QUANTA LUCE NELLE FESTE DI MARIA - A. COMASTRI - 8157' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/01/2023 09:47:27 am >> SELECT document_num FROM ps_document WHERE document_num = '215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 09:47: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' , '215' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.00' , '120.82' , NOW() , NOW() ) 21/01/2023 09:47: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 = '80451' 21/01/2023 09:47:27 am >> DELETE FROM ps_document_detail WHERE id_document = '80451' 21/01/2023 09:47: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 ( '80451' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/01/2023 09:47: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 ( '80451' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 21/01/2023 09:47: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 ( '80451' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 21/01/2023 09:47: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 ( '80451' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '45.00' ) 21/01/2023 09:49:44 am >> SELECT document_num FROM ps_document WHERE document_num = '216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 09:49:44 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' , '216' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.48' , '70.59' , NOW() , NOW() ) 21/01/2023 09:49:44 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 = '80452' 21/01/2023 09:49:44 am >> DELETE FROM ps_document_detail WHERE id_document = '80452' 21/01/2023 09:49:44 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 ( '80452' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 21/01/2023 09:49:44 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 ( '80452' , '3865' , 'LETTERE ENCICLICHE - BENEDETTO XVI ' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 21/01/2023 09:49:44 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 ( '80452' , '4427' , 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - opera omnia - RATZINGER' , '1' , '-1' , '4' , '55.00' , '55' , '0' , '5' , '52.25' ) 21/01/2023 10:08:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 10:08: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 ( '26' , '3' , '2023-01-21' , '' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , 'CINGOLO + CROCE COMPRESI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 21/01/2023 10:08: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 = '80453' 21/01/2023 10:08:37 am >> DELETE FROM ps_document_detail WHERE id_document = '80453' 21/01/2023 10:08: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 ( '80453' , '13750' , 'TUNICA DUE PIEGONI' , '1' , '0' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 21/01/2023 10:08: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 ( '80453' , '' , 'TUNICA GRECHE ORO' , '1' , '0' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 21/01/2023 10:09:41 am >> SELECT document_num FROM ps_document WHERE document_num = '11/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 10:09:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '11/A' , '2023-01-21' , 'A' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , 'C/VISIONE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 21/01/2023 10:09:41 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 = '80454' 21/01/2023 10:09:41 am >> DELETE FROM ps_document_detail WHERE id_document = '80454' 21/01/2023 10:09:41 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 ( '80454' , '' , 'TUNICA 2 PIEGONI MISURA 125' , '1' , '-1' , '0' , '40' , '40' , '' , '0' , '40.00' ) 21/01/2023 10:09:41 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 ( '80454' , '' , 'TUNICA GRECHE ORO MISURA 125' , '1' , '-1' , '0' , '50' , '50' , '' , '0' , '50.00' ) 21/01/2023 10:09:41 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 ( '80454' , '' , 'CINGOLO' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 21/01/2023 10:10:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820991845' AND id_product != '4427' AND ean13 != '' 21/01/2023 10:10:22 am >> UPDATE ps_product SET id_supplier = '79', reference = '13/2', ean13 = '9788820991845', date_upd = NOW() WHERE id_product = '4427' 21/01/2023 10:10:22 am >> UPDATE ps_product_lang SET name = 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - OPERA OMNIA - RATZINGER', description = '' WHERE id_product = '4427' 21/01/2023 10:10:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '55.0000' WHERE id_product = '4427' 21/01/2023 10:10:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '55.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '168', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4427' 21/01/2023 10:10:22 am >> DELETE FROM ps_specific_price WHERE id_product = '4427' 21/01/2023 10:30:19 am >> SELECT document_num FROM ps_document WHERE document_num = '217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 10:30:19 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' , '217' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 21/01/2023 10:30:19 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 = '80455' 21/01/2023 10:30:19 am >> DELETE FROM ps_document_detail WHERE id_document = '80455' 21/01/2023 10:30:19 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 ( '80455' , '12660' , 'CAMICE BIANCO - MISTO COT. 145' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 21/01/2023 10:59:23 am >> SELECT document_num FROM ps_document WHERE document_num = '218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 10:59:23 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' , '218' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 21/01/2023 10:59:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80456' 21/01/2023 10:59:23 am >> DELETE FROM ps_document_detail WHERE id_document = '80456' 21/01/2023 10:59:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80456' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/01/2023 11:06:38 am >> SELECT document_num FROM ps_document WHERE document_num = '219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 11:06: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' , '219' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 21/01/2023 11:06: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 = '80457' 21/01/2023 11:06:38 am >> DELETE FROM ps_document_detail WHERE id_document = '80457' 21/01/2023 11:06: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 ( '80457' , '2933' , 'CROCE 15 CM FORATO - 4493/3' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 21/01/2023 11:06: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 ( '80457' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 21/01/2023 11:14:51 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 11:14:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '12/A' , '2023-01-21' , 'A' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '117.00' , NOW() , NOW() ) 21/01/2023 11:14:51 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 = '80458' 21/01/2023 11:14:51 am >> DELETE FROM ps_document_detail WHERE id_document = '80458' 21/01/2023 11:14:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80458' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '26' , '-26' , '4' , '4.5' , '4.5' , '0' , '0' , '117.00' ) 21/01/2023 11:39:48 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 21/01/2023 11:39:48 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '173' , '1' ) 21/01/2023 11:39:48 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '173' , '1' ) 21/01/2023 11:39:48 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '173' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 21/01/2023 11:41:11 am >> UPDATE ps_address SET id_state = '145', lastname = 'CARLUCCIO ROBERTA', address1 = 'ZONA INDUSTRIALE ASI SUD MOD. 114/4', address2 = '', postcode = '81025', dni = '', vat_number = '', city = 'MARCIANISE', phone = '', phone_mobile = '3339840420', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:41:11 am >> UPDATE ps_supplier SET email = '', name = 'CARLUCCIO ROBERTA', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:41:11 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '173' 21/01/2023 11:42:14 am >> UPDATE ps_address SET id_state = '145', lastname = 'CARLUCCIO ROBERTA', address1 = 'ZONA INDUSTRIALE ASI SUD MOD. 114/4', address2 = 'CENTRO ORAFO IL TARI\'', postcode = '81025', dni = '', vat_number = '', city = 'MARCIANISE', phone = '', phone_mobile = '3339840420', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:42:14 am >> UPDATE ps_supplier SET email = '', name = 'CARLUCCIO ROBERTA', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:42:14 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '173' 21/01/2023 11:42:42 am >> UPDATE ps_address SET id_state = '145', lastname = 'CARLUCCIO ROBERTA - CENTRO ORAFO IL TARI\'', address1 = 'ZONA INDUSTRIALE ASI SUD MOD. 114/4', address2 = 'CENTRO ORAFO IL TARI\'', postcode = '81025', dni = '', vat_number = '', city = 'MARCIANISE', phone = '', phone_mobile = '3339840420', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:42:42 am >> UPDATE ps_supplier SET email = '', name = 'CARLUCCIO ROBERTA - CENTRO ORAFO IL TARI\'', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:42:42 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '173' 21/01/2023 11:43:26 am >> UPDATE ps_address SET id_state = '145', lastname = 'CARLUCCIO ROBERTA - CENTRO ORAFO IL TARI\'', address1 = 'ZONA INDUSTRIALE ASI SUD MOD. 114/4', address2 = '', postcode = '81025', dni = '', vat_number = '', city = 'MARCIANISE', phone = '', phone_mobile = '3339840420', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:43:26 am >> UPDATE ps_supplier SET email = '', name = 'CARLUCCIO ROBERTA - CENTRO ORAFO IL TARI\'', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:43:26 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '173' 21/01/2023 11:46:19 am >> UPDATE ps_address SET id_state = '145', lastname = 'CARLUCCIO ROBERTA', address1 = 'CENTRO ORAFO IL TARI\' - ZONA INDUSTRIALE ASI SUD MOD. 114/4', address2 = '', postcode = '81025', dni = '', vat_number = '', city = 'MARCIANISE', phone = '', phone_mobile = '3339840420', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:46:19 am >> UPDATE ps_supplier SET email = '', name = 'CARLUCCIO ROBERTA', date_upd = NOW() WHERE id_supplier = '173' 21/01/2023 11:46:19 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '173' 21/01/2023 12:06:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 12:06: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' , '220' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.30' , '52.45' , NOW() , NOW() ) 21/01/2023 12:06: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 = '80459' 21/01/2023 12:06:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '80459' 21/01/2023 12:06: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 ( '80459' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 21/01/2023 12:06: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 ( '80459' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.13' , '2.13' , '0' , '0' , '21.30' ) 21/01/2023 12:17:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 12:17:35 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' , '221' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 21/01/2023 12:17:35 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 = '80460' 21/01/2023 12:17:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '80460' 21/01/2023 12:17:35 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 ( '80460' , '19840' , 'PERLE DI DON DOLINDO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 21/01/2023 12:45:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 12:45: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 ( '11' , '222' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '117.00' , NOW() , NOW() ) 21/01/2023 12:45: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 = '80461' 21/01/2023 12:45:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '80461' 21/01/2023 12:45: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 ( '80461' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '26' , '-26' , '4' , '4.5' , '4.5' , '0' , '0' , '117.00' ) 21/01/2023 12:45:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 21/01/2023 12:45:32 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' , '223' , '2023-01-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '117.00' , NOW() , NOW() ) 21/01/2023 12:45:32 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 = '80462' 21/01/2023 12:45:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '80462' 21/01/2023 12:45:32 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 ( '80462' , '11151' , 'LIBRI' , '26' , '-26' , '4' , '4.5' , '4.5' , '0' , '0' , '117.00' )