Schedule ssis data extract jobs

Please quote for the production of part of a set of architectural construction drawings for alterations and additions to an existing, medium sized house, project 2320 using AutoCAD. Refer to the attached schedule of drawings that need to be completed. Please find attached: - an example of the level of drawing and detailing that is required, project 1717. - our current set of plans, elevations + 3 x section for this project 2320. Once the job is assigned, further details, architectural drawings + structural drawings will be provided to assist. Payments will be processed over 7 milestones with a submission and review at each stage: Milestone 1 – 33% of all 4x sections, + 66% of plans (drawings highlighted in pink) Milestone 2 – 75% of sections + 75% of elevations to re...

...and Milestone Scheduler. Key Responsibilities: - Setting up our monthly schedule with a concentration on task completion and the achievement of set milestones. - Leveraging metrics such as the percentage of tasks completed and the quality of deliverables to monitor and assure proper execution of tasks and milestones. Skills and Experience Required: - Proven track record in project management or related fields of work. - Experience with task management tools and software. - Excellent organization and diligence to monitor progress and adjust schedules as needed. - Attention to detail and commitment to maintaining high-quality standards. Your mission will be to ensure that the project moves according to schedule and that every milestone is celebrated as an achievement...

I am seeking a highly detail-oriented freelancer for a data entry task involving the extraction of data from public record databases. Here's what I specifically need: - A keen focus on copy and paste assignments from these databases. - An understanding of the type of information housed within public record databases. This role is perfectly suited to someone who has: - A proven track record with data entry tasks, specifically dealing with public record databases. - Excellent attention to detail. - Outstanding accuracy in copy-paste tasks. - Patience and a methodical approach to ensure no data is missed or copied inaccurately. - A flexible schedule to ensure the timely completion of tasks. If you meet these requirements, I encourage you to bid. Th...

Extract informative text from website app.

Project to extract informative website data.

I need a high-functioning, user-friendly website developed ... user-friendly website developed for online professional courses. Along with offering well-structured and detailed course content, it should also feature: - A secure payment gateway: This should support both credit and debit card transactions. Moreover, an integral aspect is to have strong security measures to prevent fraud. The platform should also accommodate multiple currencies. - Course Schedule: The website should host a strategically planned out scheduling system managed by the admin, yet offer flexibility for customizable scheduling. The ideal candidate should be skilled in website developing, possessing experience with online course websites and payment gateway integrations, with exceptional attention to securi...

As a renovation company, we realize the impor...persuasive tone and more engaging content. Ideally, the writer should have experience in corporate branding and public relations. - Contracts: We want simpler language and terms used, clearer payment terms and deadlines included, and comprehensive clauses for project scope added. A writer who understands business law or has contract writing experience would be preferred. - Scope of work & Finishes Schedule: These critical internal documents also need improvement in clarity and structure. Any experience with project planning and/or interior design would be beneficial. By the end of this project, we hope to have documents that effectively convey our brand message, simplify our contract resolve process, and improve our internal pro...

I require a web-based application, built with PHP, that will allow users to upload screenshots from various video games to extract specific text data - such as Player name, Health points, Game score, KDA ratings, champions played and so on. The system should implement Tesseract OCR to accomplish this and provide the resulting information in the form of web accessible XML. Based on the game chosen by the user, the system should have predefined text region boxes in order to accurately extract the necessary data from the screenshot. Although the programming language for the web dashboard wasn't specified, PHP is highly desirable considering the client's preference for it during the project submission. Other languages can also be considered. The comple...

...digital artist with a knack for exquisite anime/manga style artistry. I am particularly interested in an illustrator who can finalize a work in progress with a keen eye for detail and precision. Here's some information to help you gauge the scope and nature of this project: - Timeline: The project must be completed within a week, so you should have the capacity to work under a fairly tight schedule. Key Aspects: - You will be required to masterfully render a piece with a specific pise. Although the background scenery was skipped initially, if you possess the skills to add that in, it would definitely be a plus. - it will be a colored art piece. Ideal Skills: - A strong understanding and love for anime/manga style art. - Ability to work quickly without compromising o...

I need someone who know a process or shortcut to convert a .laz file no georeferenced to .dwg georeferenced, also extract all the trees and included the contours lunes and perimeter.

I'm in need of a software engineer adept at web application development, particularly minimalistic designs. I'm working on a project that mainly demands two important functionalities: -Extract data from -Cross reference the data on Whitepages to find household phone number -Add phone number and names to google docs sheet Ideally, we're looking for someone who can deliver a sleek, minimalistic interface for the website. Your ability to balance aesthetics and functionality would be highly appreciated. Experience working on similar projects is a great advantage. We value productivity, so an understanding of efficient coding practices is desirable.

...that weaves an intricate tale of love entwined with horsemanship, and pushing past the boundaries of domestic abuse. Requirements: - Proven experience in editing fiction, preferably with a specialization in equine literature or romance novels. - Solid comprehension of themes involving overcoming limitations and addressing domestic abuse. - The ability to adhere to deadlines, as I am on a strict schedule. - Constructive feedback and suggestions for content improvement while respecting my narrative voice. Your role will be to polish up this manuscript, ensure language efficiency, plot continuity, engage readers more deeply, and of course, rectify any grammatical errors. I expect the editor to be adept at enhancing narrative without losing originality and emotional resonance. The...

...numbers. As a programmer with a keen understanding of Astrix & API integrations, you'll be expected to pull off an integration with an Astrix server. To make the initiative successful you would need to: - Implement a system that picks numbers randomly from selected pools upon each instance of call initiation. - Create a versatile call scheduling functionality. This should have the capability to schedule one-time calls, repeating calls, and limit calls to explicitly specified hours. - Create a system for managing the number pools - Develop a detailed log for call details - Record the calls for log - Supply a action usage calls report based on the logs. Primary language for the development process will be Python. Substantial experience in Python programming, API int...

I need a skilled and experienced web scraping freelancer who can extract data from the Website: while avoiding Recaptcha. The target data is just the PDF obtained after form completion. Tasks Expected Include: 1. Fill in the "Verificador de documentos (CVE)" field (example cve: ACXMf6IExtbk) 2. Obtain the PDF while bypassing the Recaptcha. 3. Delivering the code in Python language. The code must receive the cve string and a file path and write the PDF in the file path. Ideal Skills & Experience: * Expertise in web scraping. * Proficiency in Python or other scripting languages commonly used in scraping. * Knowledge of methods to overcome Recaptcha or similar security measures. Though there's no specific time constraint

...Key Task: - Develop NLP model for sentiment analysis on social media posts Essential Skills: • Experience with Natural Language Processing or computational linguistics • Strong knowledge of Python • Previous experience in sentiment analysis • Familiarity with social media APIs Your job will be to: - Extract and preprocess the relevant data from social media posts. (Arabic language) - Implement an NLP model capable of accurately determining sentiments - Validate this model with test data - Possibly improve the model based on feedback and results Please, when bidding, briefly describe your previous related work and explain how you'd approach this task. Your ability to effectively communicate the proposed solution will be a key factor in ...

...extracting tweets over a four month period. The tweets are specifically from two Mexican political candidates. My main purpose for this extraction is gathering data for analysis. Key Responsibilities: - Teaching me to write code in Python to extract tweets based on specific keywords and dates - Guiding me to analyze the data from the extracted tweets for trend-identification purposes Ideal Candidate: You should be highly proficient in Python, specifically knowledgeable about leveraging Twitter's API for data scraping. You must also possess excellent teaching skills to relay this knowledge effectively. Any past experience in political data analysis would be a valuable addition. Note that while I have intermediate Python skills, your role would r...

...problem-solving skills and attention to detail. - Strong communication skills and the ability to work independently. #### What We Offer: - Detailed specifications for the required bug fixes, new features, and security enhancements. - Direct access to the original script developers for any clarifications. - A competitive project fee, with a bonus available for completing the project ahead of schedule and exceeding security expectations. - Potential for ongoing work and updates to the script in the future. #### Application Process: Interested candidates should submit the following: - A brief cover letter explaining your experience with PHP, MySQL, and web application security. - Examples of previous projects where you have successfully improved the security of w...

I urgently need an experienced freelancer to extract text and numerical data from a 121 page PDF document, and input it into an Excel format. Relevant skills needed include data entry, PDF manipulation, Excel proficiency, and of course, keen attention to detail to ensure that nothing gets missed during the conversion process. When applying, please provide examples of past work that demonstrate your expertise in handling similar tasks. The project needs to be completed as soon as possible, so time efficiency is also a vital skill for this job. I've attached an example of the data in the PDF (In yellow) that should be input in the Excel data sheet

I need a graphic created that depicts my daughter's lacrosse schedule visually. The information to be displayed includes: * Date * Time * Opponent (Logo & also name in text) * Something to denote home games versus aways games (there are only 2 home games) I have attached the logos for each of the opponents. The files are named the same as the team. I also attached a txt document that contains the date/time/opponent details so that you don't have to key any text. If you need anything more from me as far as input please let me know. I don't have it now but they are taking a team picture today that we might also incorporate once we have it. Thank you.

...company in an industry that is both "high design" and also high-volume and want to learn actual real-world tasks that your future employers and/or clients need you to understand. 2. Please understand this is a learning position usually done when in school. For 2, please put the number of hours you can commit to each week up to a maximum of 20 so you do not neglect your studies and the proposed schedule (in EST time zone please) by day. with no more than 4 hours per day that you will be able to be an intern for my client. 3. for 3, please write your proximity to Indore India, and New Delhi. My client has an overseas offices there. It is not a requirement to be in India. This is a remote Position. 4. For 4, please write your the experience you may have had for clients. As...

I'm seeking an expert in web scraping to proficiently extract text-based content from Website A. There are approx 300 pages of data to scrape - Comprehensive and accurate extraction of text-based content - Conversion of extracted data into CSV or Excel Ideal skills for this project include proficiency with web scraping tools, strong understanding of data extraction methodologies, and experience with data conversion into CSV or Excel formats. The final product should be well-formatted, ensuring easy reference and analysis. High attention to detail and commitment to accuracy are paramount for this job.

Data Insights Technical Assessment For the technical assessment, we will be using a mock scenario similar to a recent project. All data is anonymized. Scenario: I was hired by a lender to evaluate one of their portfolio companies and their ability to hit their 2021 financial forecast. I was also hired to introduce better reporting and visualization practices for increased visibility into the finances of the business. Client: Small CPG company (~$70M annual revenue) that produces snacks and baked goods. They sell private labels (think store branded, i.e., Harris Teeter) and branded products across two channels, Foodservice (i.e., restaurants) and Retail (i.e., grocery stores). Context: This is a mix of an analytical exercise to identify and quantify the risks and opportunitie...

...leveraging industry contacts, you will help me find promising vendors who could benefit from my platform. - Contacting Vendors: Once potential vendors have been identified, you will play a critical role in initiating contact and explaining why my platform could be a valuable resource for them. - Scheduling Vendor Onboarding: After these initial conversations, you will be in charge of arranging a schedule for vendors to onboard onto the platform. In addition, while performing these tasks, I would like the expert to gather some information from vendors such as their contact information and the products or services they offer. Ideal candidates for this project will have previous experience in lead generation and a deep understanding of the food and events industry. Furth...

...fresh perspective to the analysis. - Research skill: Experience in carrying out research work is essential. You should be able to find, interpret, and use different research materials relevant to the topic. - Writing ability: Strong writing skills are vital. Your work should be engaging, informative, and adhering to accepted academic and journalistic standards. Responsibilities: - Extract relevant information and data from thesis to construct 1 or 2 journal articles. - Write a comprehensive and compelling journal article. - Collaborate on review and revision processes to ensure the quality and integrity of the piece. Please ensure to attach samples of your previous work related to business writing and/or academic research, as this will help me judge your suitability for ...

...mission will be to introduce our company's solutions to vessel managers, superintendents, fleet managers, and technical managers, ultimately setting up meetings to discuss potential collaborations. Target Audience: Your first call will be to contact the headquarters of leading maritime organizations and identify key people (fleet managers/superintendents/vessel managers/ technical managers, etc.), schedule a phone call with persons of interest, and persuade them to have a meeting with our team. Expected Outcomes: We're counting on you to use your communication skills and professionalism to secure meetings with our target audience, laying the groundwork for fruitful partnerships. We are looking to pay for about 10$-15$/per hour Also, you will have a bonus per each co...

As someone requiring a comprehensive solution for health care management, I am looking for an experienced Android app developer capable of creating an online system. Key functions include: - Appointment Booking: Seamlessly schedule doctor appointments, manage timings, and keep patients updated. - Patient Information Storage: Catalog and retrieve patient profiles, health records, and medical history. - Online Consultation: Facilitate remote medical consultations. This project doesn't require integration with existing hospital systems. The ideal freelancer should have a solid background in Android app development and experience in healthcare management systems will be a plus.

...the questions in this document, as they address the main desired targets: 3. You must proven experience in what you suggest. As the first paragraph of the document says:We are looking for an online and mobile solution provider that allows us to: streamline our lead generation, qualify them, lead them to schedule a call with us, automated chat follow up by WA, IG/FB, LI and not by email (though good if you’re the solution allows for it, analytics, CRM, unified chat inbox with WA, IG/FB, LI and email all in one column so each agent can attend many prospects in the day without having to click between a CRM page and the Unified Chat page, Analytics that allow to track campaign performance across the prospect

The site contains adult content only apply if you are ok with that! We are looking for a person who can manage our social media channels on Reddit and Twitter. Your task will be to create the creatives, schedule the posting and improve our follower numbers. To consider your application please send us the following information: - Examples and experience with Reddit - Examples and experience with X-Twitter Experience with adult content or newsletter is a plus. If you have any questions, just let us know!

I'm in dire need of a Python-Selenium script for Google Maps scraping. Ideally, this script should have the following features: * Capability to extract the business name, address, and phone numbers, emails and other valuable info. * Able to execute on a regular basis and be used for different regions/countries. My maximum budget for this is $65. If you are not willing to work for this budget, do not apply.

I need an experienced social media manager to handle Facebook and Instagram accounts for a daily posting schedule. Key responsibilities include: - Generating original and captivating content relevant to our brand. - Daily scheduling and posting of the created content on both platforms. Skills and experience required: - Proven track record in social media management, particularly Facebook and Instagram. - Skill in creating diverse, engaging content that drives interaction. - Punctuality and consistency in executing a daily posting schedule.

...you have experience in driving organic traffic to our website? We are looking for a SEO Content Writer to join and help me create high-quality blog posts that rank well on Google and drive organic traffic to our website. You will be responsible for researching, writing, and optimizing blog posts on various topics. This is a remote and flexible position, where you can work at your own pace and schedule. You will be paid monthly, based on the article posting and leads. We expect you to deliver 3 articles per day. To apply for this position, you need to have: - A good understanding of SEO principles and tools, such as keyword research, meta tags, headings, etc. - Excellent writing and editing skills in English, with attention to grammar, spelling, and punctuation. - A reliable a...

...web portal I have access to. Key Requirements: - Proficiency with Selenium framework for web scraping. - The capability to schedule the web scraper to run at specific intervals, with a current need to run every 5 minutes. - Previous experience with similar projects involving Selenium. The steps are 1. login to portal 2. Go to alert section 3. select report from left side frame ( there are 10 different ) 4. select filter for time frame 5. select on excel download 6. It opens download progress from where need to download the excel file 7. save file in a folder I can specify the Report name to script so it download the report and file name where it will save the data. My BUDGET is INR 3000 for the task In your application, please include your past work and experienc...

Description: We are seeking a skilled and experienced Data Scientist to help us extract valuable insights from our customer data. We have a rich dataset containing people information, contact details, and other relevant information in an Excel sheet. Our goal is to track current phone and email engagement signals, such as recent interactions, and delve deeper into understanding customer behavior, lifestyle, and buying intent. Responsibilities: Analyze and interpret data to identify patterns and trends related to customer engagement. Utilize statistical methods, machine learning, and data analysis techniques to extract meaningful insights from the dataset. Track and analyze current phone and email engagement signals, providing real-time updates o...

...2-digit millisecond range. I am running FastAPI + Uvicorn server setup on EC2 instance. I am using 4 Uvicorn workers and 4 celery workers on 8vCPU Ec2 instance. I am performing very simple task. I get data on post API, schedule background task using celery and return response immediately. For this simple task if I send 40 concurrent request at sec, I get p99 as 600 ms which is very high. It should be within two digit. Can you help me debug this issue ? Key Project Details & Requirements: - Debugging: You'll need experience in debugging machine learning models, specifically those with a data preprocessing error. - REST API: Any experience with API response time optimization, particularly REST API, would be highly beneficial. - Communication: A profession...

I need a proficient Wordpress Developer to create a unique blog for me. It needs to be designed in a way that accommodates frequent daily posts with content relating to internships and job updates, among other things. -CONTENT: Internships, Job updates, and much more. -FUNCTIONALITIES: I require a platform that's efficient for blogging. The blog should have the ability to schedule and post content on a daily basis. -SKILLS REQUIRED: The ideal freelancer would have vast experience in Wordpress blog development, content scheduling, and an understanding of blogging functionalities. -EXPERIENCE: Experience in designing and maintaining blogs with similar content will be an added advantage. Familiarity with blogging best practices and optimizing Wordpress for SEO purposes wou...

<Overview> Please collect product information on vehicles or service information that have or will have the technologies described in the “Technology Description” section below. <Technology Description> When a vehicle moving by power stored in a battery requires charging of the battery, this technology creates schedule information including a travel schedule that enables the vehicle to finish a predetermined task additionally set to the vehicle, and to travel to a charging station where the battery is to be charged. Please search for this technology in this contest <<NOTICE>> The target car brands in this search are limited to US, European, Chinese, and South Korean brands. <Requirements for Payment> ・Submit documentary evidence th...

I am in need of a comprehensive database of Australian-based influencers who are active in the home, décor, and lifestyle sector. Ideally, the freelancer undertaking this task should be experienced in influencer research and social media marketing. Specifically, the project entails: • Identifying influencers who actively use YouTub...with these influencers. Additionally, preference will be given to those influencers that fit the following criteria: • Operate within the home, decor and lifestyle niche. • Located in Australia. • Age-range is not specified, but ideally influencers who appeal to a wide age demographic. Please note that an excellent eye for detail is essential, as well as being able to efficiently navigate and extract pertinent informati...

I need a proficient data scientist who is an expert in Convolutional Neural Networks (CNNs). The primary task includes constructing a tool capable of analyzing video content. The tool must be able to process live-streamed and pre-recorded videos, extract frames, and utilize a trained model to identify malicious or inappropriate content based on predefined standards. Key Responsibilities: - Developing a CNN model to scrutinise video content - Extracting frames to check for inappropriate content - Implementing a reporting mechanism for videos containing inappropriate content, so they can be flagged for manual review. Ideal Skills: - Experience with Machine Learning Algorithms, particularly CNN - Understanding of video handling and frame extraction - Ability to design a warnin...

I am in need of a comprehensive database of Australian-based influencers who are active in the home, décor, and lifestyle sector. Ideally, the freelancer undertaking this task should be experienced in influencer research and social media marketing. Specifically, the project entails: • Identifying influencers who actively use YouTub...with these influencers. Additionally, preference will be given to those influencers that fit the following criteria: • Operate within the home, decor and lifestyle niche. • Located in Australia. • Age-range is not specified, but ideally influencers who appeal to a wide age demographic. Please note that an excellent eye for detail is essential, as well as being able to efficiently navigate and extract pertinent informati...

I've created a preliminary construction schedule in Primavera, but I need help refining and polishing it for an hour.

I am currently in need of a freelancer who can support as a data entry assistant. Your task will primarily involve: - Entering simple text data, such as addresses and names. - You will be provided with direct sources such as documents or websites to extract the necessary information. No advanced technical knowledge or expertise is required. However, an ability to work accurately and efficiently is crucial. Proven experience in a similar data entry role would be a bonus.

I'm in need of an animator with proficiency in Maya to quickly rig and animate a prepared human model. The animations required are fairly basic - for instance, a simple walk cycle or similar action. Render is not neccesary and i have a scene with studio lighthing. I need it to be ready until Tuesday - Wednesday(as fast as possible) Here's what I'm looking for:...Quick turn-around time given the urgency of the project Please note, the character model is fully prepared and no additional modeling will be required. Ability to effectively communicate your progress will be crucial for this task. A simple, clear, and succinct animation is what I'm aiming to achieve for the character. Your ability to create these simple movements accurately, even on a tight schedule, ...

Currently, I'm aiming to create an effective email marketing template using Zoho Campaigns. To accompl...these tasks, desired candidates should possess the following skills and experiences: - Extensive marketing experience, specifically with Zoho Campaigns - Knowledge of creating engaging and professional email templates - Proven track record of successful call-to-action designs, particularly to prompt recipients to request meetings. The goal of this project is to encourage email recipients to schedule a meeting. Hence, the emphasis will be more on persuasive writing and designing. Focusing on enhancing the readability of emails is crucial, coupled with compelling visuals which may increase the possibility of communication. Please present any past work that aligns with these ...

...a platform for my wellness-focused consultation and recording services. The scope of the project is as follows: Services to Incorporate: - Health and wellness consultation. - End-of-Life Doula services. - Meditation consultation. - Delivering tailored consultation recording services. Features to Include: - Dynamic booking system: This feature should enable customers to conveniently book and schedule for any of the above services. Ideal Skills & Experience: - Proficiency in website development and design: You should have a portfolio showcasing your previous works to demonstrate your capability. - Familiarity with wellness industry: A background or interest in wellness would be advantageous, as it can contribute to intuitive user interface and experience. - Experience in i...

I'm in need of a proficient draftsman seasoned in architectural drafting. More specifically, I require assistance with building elevations f...Mastery in drafting building elevations - Attention to detail and accuracy in work - Creative problem-solving skills Kindly only apply if you have a suitable background and notable experience with projects of this scale. Will require - email working plans in high quality PDF format - Site plan, floor plan, foundation plan, framing details, elevation plan, connection details, door and window schedule, MEP and HVAC. All dimensions required for building metal frame home on a 4 inch concrete slab. House will metal - White with black trim and roof. See attached photos for details . I want this house with no fireplace. I look forwa...

I'm looking for an accomplished data mining expert to extract specific sets of data from immoscout24.ch. This specialist should have an aptitude in dealing with website scraping and handling large sets of data systematically and methodically. The task requires: - Scrape property details including price, location, and size (1 bedroom to 5.5 bedroom), year of construction/renovation. - Extract agent/contact information relevant to each listed property - Filter all scraped properties within a specified area (8 cities), for different bedroom sizes for selling and renting. - The output should be as follows: area, location, bedrooms*, price (selling price/ rent a month), size, year of construction, floor, agent, link in an excel file. If you have rela...

At our global company we are actively seeking a part-time (~8 hours per week) skillful Social Media Manager and Web Manager with the following responsibilities: Social Media Management Create and schedule posts on LinkedIn, Instagram, and Youtube. The content should be engaging that it not only increases brand awareness but also helps in generating leads and sales. Apart from that, a significant part of your job would be aimed at driving traffic to our website. Web Management/Graphic Design Manage our website on Squarespace and update content (e.g. new events) when needed. In doing so, you are expected to have a great eye for design as well as a proficient understanding of web design principles and tools (Canva, Adobe). Ideal Skills: We are looking for a freelancer with robust...

Looking for an about-turn in your digital footprint? I'm in need of a proven marketer to help elevate my brand. Core experience should include: • Search Engine Optimization (SEO) • Pay-per-click (PPC) advertising • Social Media Marketing All applicants should include: • Past Work: I'd like to see a...Social Media Marketing All applicants should include: • Past Work: I'd like to see a portfolio, showcasing your successful campaigns. • Experience: How long have you been in this field, and what's your specialty? • Detailed Proposals: Let me hear your unique approach to digital marketing. Although you may be currently engaged, my project needs immediate HELP. If you can slot my brand in your schedule ASAP, it would be apprecia...

As someone seeking to leverage the power of AI, I need a professional AI engineer with expertise in machine learning, natural language processing, and computer vision. Key Responsibilities: - Develop intelligent systems using machine learning techniques - Implement natural language processing for better interaction with software - Use computer vision to extract useful information from images or videos Required Skills: - Machine Learning - Natural Language Processing - Computer Vision There's no rush on this project, allowing ample time for quality work and fine-tuning. Please apply if you believe your skills, experience, and passion align with this project.

...logo should predominately consist of the colours Orange and White to match our corporate identity. Other colours are also accepted. Ideal Skills and Experience: - Creativity: Applicants should demonstrate the ability to create distinctive, imaginative designs - Branding: The ability to consider our brand values and target audience when creating the logo - Time management: We are on a tight schedule and require the project to be completed ASAP. Although it is not necessary, freelancers may wish to include details of similar past projects or their particular design approach in their application. Special Notes: 1. Logo should be fit for a construction business. 2. By looking at logo people should be able to identify Aruba Designs and Construction. 3. Logo should be distinct an...