Create reports mysql databasemunkák

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I'm in ...creativity is definitely welcome for the final designs. The models need to be in FBX format, so while Blender is preferred, feel free to use any program you're comfortable with. Requirements: - The trash bins should have basic movements such as walking, arm rotation, and potentially facial expressions (if applicable to your design). - I need at least 4 animated trash bins in total. You're welcome to create more if you feel inspired. - The level of detail I'm looking for is intermediate. This means I'd like somewhat elaborate textures and shapes, but nothing overly complicated. Ideal Skills: - Proficiency in Blender or another 3D modeling program that can export to FBX. - Experience in creating animated models. - Creativity and a good eye for deta...

I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.

...optimization for enhanced user experience and search engine visibility. Social Media Marketing: Design and publish visually appealing posts/reels, schedule regular content across all platforms. Develop engaging content tailored to the target audience, increase engagement, and employ interactive hashtags. Create and manage promotional ads, segment the target market, and implement lead generation campaigns. Monitor comments/messages, assign dedicated customer support, and provide monthly analytics reports. Additionally: Develop a comprehensive content plan and schedule postings for consistency. Share captivating social media stories. Platforms: Instagram, Facebook, Snapchat, TikTok, WhatsApp. Ideal Skills and Experience: - Proven experience in website optimization for bot...

Create 5 gifts with our logo of the real estate

...the opportunity to gain hands-on experience in managing our social media presence across various platforms, including but not limited to Facebook, Instagram, Twitter, and LinkedIn. Responsibilities: Create and curate engaging content for our social media platforms. Schedule and publish posts using social media management tools. Monitor social media channels for comments, messages, and mentions, and respond promptly. Assist in developing and implementing social media strategies to increase brand awareness and engagement. Track and analyze social media performance metrics and prepare reports for management. Stay updated on industry trends and best practices in social media marketing. Requirements: Currently enrolled in or recently graduated from a relevant degree program ...

Hello, as we discussed, please create another mockup video for us.

Our office, based in Poland, is looking for an exper...professional to join our small team of 1-5 members. As our MLRO/AML checks officer, we are dedicated to: - Identifying and preventing money-laundering activities - Conducting thorough due diligence on clients and transactions - Ensuring compliance with various regulatory requirements We need support in the following areas: - Routine transaction monitoring - Preparation of regulatory reports - Risk assessments and audits Ideal candidates should have experience in the aforementioned areas, be detail-oriented, and have a strong understanding of the latest AML laws and regulations. We value team players who can work efficiently and effectively in a fast-paced environment. Polish language skills are desirable but not ...

I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individua...

TRANSLATING DOCUMENTS FROM ENGLISH TO ARABIC & ARABIC TO ENGLISH MICROSOFT OFFICE PACKAGE (WORD, EXCEL, POWER POINT & VISIO) PHOTOSHOP PRORAMME CORPORATE ORGAISATIONAL STURCUTRE, EVALUATION REPORTS & PROMOTION TYPING: 40 WORDS PER MINUTE IN BOTH ARABIC & ENGLISH

...We are seeking a highly skilled and motivated Research Assistant to support a significant research project led by a University. The ideal candidate will possess a strong background in financial databases, data analysis, and academic research, with proven expertise in using Stata for data organization and analysis. Responsibilities: Download and extract data from financial databases and annual reports as well as others as required. Efficiently merge and manage datasets from multiple sources to ensure consistency and accuracy. Conduct thorough literature reviews in finance and related fields to support research objectives. Utilize Stata to analyze complex datasets, perform econometric modeling, and generate insightful results. Collaborate effectively with the research team to ...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I require a Warehouse Inventory Management Software to efficiently track, manage and report on our inventory. Key Features: - Real-time Inventory Tracking: This is essential for us to maintain accurate stock levels. - Reporting and Analytics: We need the software to generate insightful reports on inventory trends, stock levels, and other key metrics. User Base: There will be a limited number of users accessing the software, specifically 1-10 users. Ideal Skills and Experience: - Proficiency in developing inventory management software - Strong background in real-time tracking and reporting - Experience in creating user-friendly interfaces for non-technical users would be a huge plus

I'm seeking a skilled data analyst to analyse data in SPSS to test my hypotheses rel...results in a comprehensive report that I can include in a lab report. Key Tasks: - Analyze data - perform correlation, regression, mediation or moderation - Identify trends and patterns - Create a comprehensive report summarizing the analysis, report all results in APA style Ideal Skills: - Proficiency in SPSS, ideally with at least a Bachelors level degree in Psychology - Strong data analysis and interpretation skills - Ability to present findings in a clear, concise manner Experience: - Prior experience with social media metrics analysis is highly preferred. - A background in creating data-driven reports will be advantageous. Please provide examples of similar projects you have ...

Use my logo and tagline: "GTA service store" Use these followings as objects in the picture: (it has to look good, no need to add all of the objects use as you like) 1: Use three character as attached 2: Use attached car 3: attached bike You need to digitally draw characters, car & bike images and put it together in a great way using our theme red color.

Ho un progetto vb.net da completare per la sincronizzazione di database. il progetto è in github e darò l'accesso una volta assegnato il progetto. ho un problema nella lettura del formato dei campi da un tipo di database e la creazione dei campi nella tabella del database di destinazione che è di un formato diverso. i formati database principalmente coinvolti sono MySql, Firebird, Ms Access, Ms SqlServer

Looking for someone well experienced in pitch decks to help us create a sponsorship proposal. I am searching for someone that can help me create a Sponsorship Pitch Deck for an event that I have in New York City. We are targeting sponsorships from:
-Liquor brands -Restaurant (food) Chains and Local Restaurants -Speaker companies The event is an outdoor kickback/mixer. The crowd is made up of around 100-150 young black professionals, socialites, influencers, & content creators. All are between 25-40 years old. If we can secure financial sponsorships that is great. If not, then in-kind sponsorships/product donations are okay. You must understand what brands want to see & what information to highlight to peak their interest.

Hi, I'm searching for a developer who can make a custom quotation system inside my WP website. This tool has to do retrieve data from my woocommerce products and display them inside a new page. These are the specifics: The products in the website are simple ad variable. They have some custom fields added with ACF. The main task is to create a new page that allows the user to go through 3 steps. In step 1 the user can choose: Brand, Model, Setting via a drop-down menu. In step 2 choose: Total KM, Duration, Condition, Change. In step 3 show Price, Inventory and Delivery Time. This data must be related to the variants of the individual products therefore show only the corresponding variant in the corresponding drop-down menu also in WooCommerce. This page has to be accessible o...

I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!

Dear All, I am thrilled to announce the launch of a logo design competition for Tamarysse Executive, our boutique recruitment agency specializing in the hospitality sector. As we aim for a logo that exudes sophistication and elegance, we invite all talented designers to participate in this exciting opportunity. A few pointers to guide your creativity: Incorporate the initials "T" and "E" creatively, reflecting our company name. Opt for shades of blue to resonate with professionalism and trust, while leaving room for creativity. Consider subtle, minimalist designs that convey our commitment to excellence and refinement. As a woman-owned business catering to the hospitality industry, we value elegance, attention to detail, and professionalism. We believe our logo shoul...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

...You should be an individual with strong command of English, and a creative mindset to help push the boundaries of our digital marketing efforts. Responsibilities Include: - Creating Social Media Posts (image + content) on Instagram and Twitter; - Doing community management in social; - Creating e-mail marketing campaigns; - Creating blog posts; - Managing a CRM (Monday); - Ability to create reports with insights; The end goal of our marketing efforts includes both increasing brand awareness and driving website traffic which ultimately fosters lead generation and customer engagement. Our target audience encompasses a wide range which includes general consumers, B2B businesses, specific age groups and the local community. The ideal candidate should have: - Experien...

...reputable and relevant sites. **SEO Tools and Analytics Setup**: Set up and configure Google Analytics, Google Search Console, and any other necessary SEO tools to track performance. Create a dashboard for monitoring key SEO metrics, including organic traffic, bounce rate, and conversion rates. **Reporting and Optimization**: Provide monthly SEO reports detailing performance metrics, insights, and actions taken. Offer ongoing recommendations and optimizations based on analytical data. **Deliverables**: A comprehensive SEO strategy tailored to the book's promotional needs. Monthly performance reports. Ongoing support and adjustments for three months post-implementation. **Project Timeline**: The initial phase of the SEO campaign should be completed w...

Project Overview We are seeking a skilled Android developer to create a simple and efficient Car Maintenance Tracker app designed for auto repair shops. The app's primary function is to streamline customer and vehicle management by utilizing RFID technology. Core Features: RFID Integration: The app will utilize an RFID reader connected to the Android tablet to scan customer vehicle tags. Scanning a tag will display the vehicle's service history and stored information. Vehicle & Customer Data Management: For new customers, the app will allow users to create profiles by entering: Customer Name Contact Information (Phone, Address) Vehicle Details (Type, Engine Type, Oil Type, Filter Types, Battery Size, etc.) Additional Notes Existing customer data can be easily ac...

...definite advantage. - Goal: The main objective of this project is to perform in-depth data analysis. I need the freelancer to assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code for the following calculation of Code Synchronization adoption rate: I've 4 excel files, 2 Jira extracts and 2 solman extracts. 1 for Jira Support state(support user stories & bugs) and 1 for Solman Support state(Support CRs). Other would be same Jira & SolMan extract but for Project State. Project might have more ite...

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.

I'm looking for a Kotlin (KMM) developer with experience in migrating applications from local Realm to MongoDB Realm. The current status of the app is fully developed, and I'm only interested in converting the local Realm database to the MongoDB Realm database, without any additional feature or minor changes. The ideal candidate should: - Be proficient in Kotlin - Have experience with Realm - Have experience with MongoDB Realm - Understand database migration processes and best practices

I consider my self a linux user with more than 10 years of experince. I have having some issues with a linux server running mysql. From time to time it stops responding. I am unable to find the root cause. Therefor i need a linux guru to connect to my anydesk/teamviewer and debug with me till we find the error and fix it. We have various logs in the system so it will be helpful to debug

I'm in need of a skilled web designer and developer who can create a professional corporate website that effectively communicates and enhances the identity of my brand. Key Requirements: - Strong Branding: This project is primarily aimed at establishing and reinforcing my brand identity. Your expertise in crafting the right logo, color scheme, typography, layout, and including imagery and multimedia to complement these branding elements is crucial. - Web Design: You will need to design a user-friendly, aesthetically pleasing, and cohesive website. The design should be professional and match the branding guidelines. - Web Development: The website should not only look good but also function seamlessly. I expect the functionality to be smooth, responsive and easy to navigate....

I'm looking for a skilled website designer and developer with graphic design expertise to create a modern, sleek website for a car transportation company in India. Key Features: - Customer Testimonials: The website should have a section where our customers can leave testimonials. - Quote Request: There should be a feature where potential clients can request a quote. - Customer Form: We need a user-friendly form for customers to contact us. - WhatsApp Support: A chat support system that integrates WhatsApp for customer convenience. - SEO Optimized: The website should be optimized for search engines. Ideal Skills and Experience: - Website Design and Development: Proficiency in creating user-friendly, visually appealing websites. - Graphic Design: Strong skills in graphic desig...

I am looking for a professional tally accountant to manage the finances of my NGO. Key Responsibilities: - All bank transactions and other data entry is done in Tally Prime, apart from this, manipulated entries are done to increase the turnover, which is suitable for NGOs. - Justifying all aspects of bookkeeping. - Helping with budgeting - Preparing financial reports The ideal candidate should have experience working with Tally software and a strong understanding of the specific financial needs of a non-profit organization such as an NGO.

I am in need of a proficient Personal Assistant to work remotely with me as I manage a fundraiser for a specific cause. The ideal candidate would be able to handle various key tasks in relation to the fundraiser and overall CEO support. Tasks: - Typing Admin documents: The PA should assist in typing a range of documents related to the fundraiser. This will include letters, reports, and agendas. Proficiency in MS Office suite is expected for this task. - Setting Appointments: The PA should be able to manage my calendar effectively, setting appointments which could be related to the fundraiser or general business activities. - Handling Emails: The PA should be able to effectively manage incoming emails, filtering out important ones and responding to some on my behalf. The purpose o...

I'm seeking a proficient data analyst to create a comprehensive Looker Studio report for me using Google Search Console (GSC) and Google Analytics data. Here's what I need: * Consolidation of GSC data and Google Analytics data into a thorough report. * Ability to effectively analyze and interpret this specific data, and capture relevant screenshots. * Unfortunately, I've not decided on the specific GSC and Google Analytics metrics nor the specific screenshots for this project so flexibility and the ability to suggest relevant metrics is crucial. Skills and Experience: * Proficiency in using Looker Studio to generate reports * Extensive experience with GSC and Google Analytics * A knack for data interpretation and analysis * Excellent judgement in selecting...

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

...up/ or Canceled. 10b. Multiple orders can be selected for selected day to change status. (Once status is changed to Picked up or cancelled it does not show in active orders) 10c. If order is canceled it cannot count in daily production list (report) 10d. Order can be changed or edited (Items canceled or quantity changed) (If order is changed it must update in daily production report (11b) 11. Reports: 11a. All orders for selected day with customer name and items ordered. (Print or export PDF and excel) Print on letter size (A4) 11.b Daily production report (All items ordered for selected day > Category A Item A -20 Item B -30) (Print or export PDF and excel) Print on letter size (A4) or Label size 4"x6” Current application

I'm in need of a seasoned Facebook ads expert to manage my Facebook ad campaigns on the Facebook mobile app, desktop, and Instagram app. The primary goal of thes...multiple platforms - Ability to deliver on increasing website traffic, generating leads, and boosting brand awareness - Expertise in targeting specific audience demographics such as the 18-24 age group and male gender - Understanding of audience interests including travel, fitness, and technology, and how to tailor ads accordingly - Excellent communication skills and ability to provide comprehensive reports and insights Looking for someone who can hit the ground running and bring innovative strategies to maximize the effectiveness of our ads. If you have the skills and experience needed to drive results, I'd lo...

Submission Requirements: Your proposal must include a detailed pitch deck covering all aspects of this job post! I expect you to read all areas and have answers each topic I brought up. Why Us? Justify why your agency is best suited to our needs, particularly focusing on lead generation for service i...improvement and alignment with our business goals. Collaborative Work and Reporting: Communication and Workflow: - Outline your proposed workflow for collaboration, including communication channels, regular meeting schedules, and the use of project management tools. Regular Reporting and Adjustments: - Describe your approach to regular reporting, including the frequency and format of performance reports. Discuss how you will use these insights to make proactive adjustments to ...

I need a developer to create reports using AG Grid or a similar tool. The reports are intended for data analysis, performance tracking, and potentially financial reporting.

...desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java based desktop application and host it on a cloud instant of AWS. - must have multi user access - must have a database component - must have a web interface that can allow users to config...

...lead & -appointment setting improvement. -Recommends and conducts disciplinary actions when necessary. Mentors and coaches team members to instill confidence and increase productivity. -Builds relationships to create a positive, professional work environment that focuses on providing exceptional customer experiences and increases the customer base. -Maintains a sense of urgency to promptly respond to our customers needs. -Leads by example and promotes a “customer centric” attitude at all times. -Keeps track and monitor performance of appointment/lead cost in our CRM and prepare reports for management. -Develop and maintain a successful rehash program bringing in additional revenue from past sales opportunities Requirements: Minimum of 1-3 years of supervi...

...promote emerging artists. This position offers flexible hours with a focus on results and performance. **Responsibilities:** - **Contact Identification and Research:** - Utilize various online tools and databases to research and compile a list of key music industry professionals, such as A&R executives, playlist curators, music managers, and record label executives. - Maintain an organized database of contacts, including names, positions, companies, and contact details. - **Email & Socials Campaign Management:** - Draft compelling and personalized email pitches and outreach messages to introduce demo tracks and artists. - Send out emails and social media messages through a managed and systematic campaign, ensuring high levels of professionalism and adherence to...

...Instagram, TikTok, and Blog. Key Tasks: - Your primary responsibility will be to manage and post content across these platforms multiple times a day. - Additionally, I'm looking for someone capable of creating engaging, high-quality content that resonates with our audience. - You will also be responsible for enhancing audience engagement and analyzing social media performance, providing regular reports on our progress. Requirements: - Prior experience in social media management, including Facebook, Instagram, TikTok, and Blog. - Proven track record in creating engaging, high-quality content. - Strong communication and marketing writing skills. - Proficiency in analytics and reporting. - A good understanding of social media platforms and their algorithms. - Consistency in p...

...developer who can create a Springboot application that connects to our Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - ...

I'm in search of an adept LinkedIn manager who can creatively handle my account. Your role would involve: 1. Post Creation: Generate one quality topoc post daily t...audience in order to drive engagement. 2. Connection Building: Focus on increasing my LinkedIn connections specifically within targeted regions. Leverage your network-building skills to create valuable, local connections. 3. Monitoring & Reporting: Present a daily report which provides clear information about the number of new connections made, engagement rate on posts, and frequency of profile visits. Ideal freelancers should have previous experience managing LinkedIn accounts and an understanding of region-specific networking. Experience with LinkedIn analytics and ability to provide informative performance...

**Your Bidding Amount is Final. No change allowed later**##Please read the attached file for details## I have an existing Online Stamp Inventory for Postal Stamp Collectors in my site. It is made in CakePHP. I need to add some features to it and repair current feature. I want to add Export feature, improve search feature and add the feature of uploading images/document, repair Year field, URl field, make the current captcha and email verification system better. Further, I need to add Subscription feature. Free Users can add limited number of entries whereas Paid Subscribers can get full features. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop any new website or web design. Just...

NEED URGENT PLEASE CONTACT. NEED TO START WORKING NOW Exciting opportunity to develop a law firm management system from scratch! We need specific features including: - Custom report generation: Ability to create variety of reports with different variables. - Client portal integration: Safe, easy-to-use interface for clients to access their case information. - Time tracking and billing enhancements: Efficient module for tracking billable hours and expenses accurately. Ideal candidate should have extensive experience in Laravel and in-depth understanding of client portal integration and report generation. Provision of detailed descriptions will be available to get you up to speed. Experience in developing robust, secure, law office management systems will strongly be preferr...

I am looking for Individual to Create a static website for my cloud based pathology lab management software. i have every thing domain, Hosting, Stock Photos and graphics are Provided by us. your job is : 1. Create a code for a Responsive multipage website using PHP, HTML, CSS (4 page Home, About software, About us, contact ) 2. Create editable header, footer and menu for easy editing. 3.. Content writing and arrange the things together. 4. SEO Key word (to Prove your skill in SEO) we have this awesome trample too if you're good on edit

Magento 2 Configurable Product Creation using Simple Product Attributes to create them I am looking for an experienced Magento developer to create a configurable product programmatically using existing simple product attributes. The ideal candidate will have expertise in both front-end and back-end development of magento 2. Scope of Work: - this work is NOT to convert simple products to confirguable products - Create all configurable products for a product catalog of over 150,000 simple prodcuts in Magento 2 using existing simple products so make a configurable product made from the simple products - Programmatically generate the configurable products from the data in the simple products - Ensure that the configurable product is functional and displays correctly on ...

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...