Slow query table mysqlроботи

Рейтинги підраховуються на основі готових формул. Рейтиги повинні постійно перераховуватись після завершення матчу в залежності від результату. Всі дані беруться з сайту через api. Ціна обговорюється після детального ознайомлення з завданням. Детальний опис завдання відправлю в повідомлення.

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

Добрий день. Мене звати Степан! Мені потрібно зробити 2д анімацію, для мого мобільноо додатку на 60 секунд. Яка у вас на це ціна?

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

As a freelance videographer, I'm looking for an individual based in Thailand who can assist me with capturing some events. - Required Equipment: I'm looking for a camera person who has their personal DSLR camera, tripod, and lighting equipment. The quality of these pieces of equipment is important to me as I'm looking for high-quality footage. - Primary Task: Your primary task will be v...project should have: - Experience in videography, particularly for events. - Own their own high-quality DSLR camera, tripod, and lighting equipment. - A strong portfolio demonstrating their videography skills. - Living in Thailand or able to travel to the location of the event. This project offers a great opportunity for collaboration and creativity, and I'm excited to see what you ...

Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.

I'm in the process of establishing a new digital marketing agency and need a website that will effectively bring in leads for potential clients. Key Details: - The primary goal of the website is to generate ...Proven experience in designing and building lead-generating websites. - Familiarity with the specific needs of small and mid-sized companies in the digital marketing space. - Proficiency in web design and development, with a focus on user experience and conversion optimization. - Strong communication skills and a collaborative approach, as I value a freelancer who can bring their own ideas to the table while also taking my preferences into account. I'm looking forward to seeing your proposals and discussing how we can work together to create a website that will he...

I'm currently facing a few issues with my Linux-based server infrastructure. These issues include slow performance, frequent downtime, and security breaches. I am looking to prioritize speed optimization as a primary focus for improvement. Few Days Work - Maybe One Day. Key Tasks: - Identify bottlenecks that are causing slow performance - Implement solutions to enhance server performance - Recommendations on security and downtime prevention Ideal Freelancer: - Proven experience in Linux server infrastructure maintenance - Proficient in diagnosing and resolving issues related to server performance - Familiarity with security measures for server systems - Reliable professional with a track record of improving server performance and reducing downtime. Key Responsi...

I'm looking fo...Please submit your unique design, we will reject any auto generated logo or copy of other's concept. The ideal candidate should have: - A solid understanding of logo design, particularly in the context of property development. - Proven experience in creating logos that communicate trust and reliability. - A keen eye for aesthetics and detail. - The ability to bring innovative and fresh ideas to the table. - Strong communication skills to understand and implement my vision and feedback. I'm open to different design styles, but the key focus should be on ensuring the logo resonates with our values. Please provide a portfolio of your previous logo work, especially if it includes similar themes. Looking forward to collaborating with a skilled designer t...

We are the production team of the TIKTOK Operation course, and I am looking for several TIKTOK creators who can face the camera to imitate and shoot simple oral videos. You don't need to have a lot of social media experience, as long as you're willing to try. Your main responsibilities include: - Execute video shoot according to the script we provided. - You can also write your own script b...will provide the reference template and text content of the video, you can directly imitate or adapt the shooting. We will be responsible for the later editing, production, and release in our account. If you can create interesting, unique, and engaging TikTok content, you may be the perfect candidate for the position. For the right freelancer, the possibility of a long-term partnership is ...

...necessary components for notifications, such as: Sender logo Sender verification status Timestamp formatting Title and short description of the notification Notification category Required Layouts: 1. Splash Screen 2. Login (without registration layout) 3. Notification List: Sender logo, Sender name, Title, Short content, Category, Tag, Timestamp 4. Notification Details: - Main: multiple elements like table, text content, button, image, tab - OTP (one-time password) - Log 5. Request Details 6. Search Suggestions and Results 7. Burger Menu: 8. Profile 9. Senders (requests, allowed, blocked) 10. Archived Additional Information: Design Style: Minimalistic and modern. Color Scheme: Already determined and can be taken from the existing Figma design. Delivery Time: Please provide an e...

I am looking for a comprehensive Autocad guide for beginners. The guide should focus on Autocad 2023 and be delivered in a written document format. The guide need to be focused on drawings from building services/installations designs in constructions (HVAC & Plumbing area) With the following necessary instructions: - it need to treat primary 2D and in 2 chapters 3D modelling - It need to have table of contents - 14 chapters - image/text ratio maximum 35/75 - Each chapter will have to have 2 exercises to solve at the end, including the solutions, separately, for them - formated on A5 - gramitacally and tehnically correct text - verified in Turnitin, max 10% plagiarism. - images must be color. - minimum 100 pages Key Focus Areas: - Basics of Autocad interface: Explanation of the...

Make the website same as the existing website, studio.d-id.com. The Backend will be provided. Please share your thoughts on how you would approach this project and what experience you bring to the table.

Hola, Estamos finalizando la funcionalidad de una web. Actualmente hay páginas que tenemos que modificar para que se adapten a versiones table y móvil. Buscamos una persona con conocimientos html y ccs para hacer estas modificaciones. Es obligatorio hablar español. Y buscamos un precio bajo y competitivo. Gracias.

...Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission and convert the data into a multidimensional array. - Da...

Minimum requirements of the role -At least 3 years of hands-on experience with JavaScript frontend frameworks such AngularJS, Stenciljs or React. -Strong Experience with NodeJS and Electron. -Strong knowledge of Relational Database Servers such as MySQL or PostgreSQL. -Some experience with C#. -Experience with microservice based architecture. -Strong coding skills, ability to use BDD and TDD where needed. -Experience and confidence developing RESTful APIs and high-load apps. -Proficiency with fundamental front end languages such as HTML, CSS and JavaScript. -Ability to switch between languages and frameworks. -Knowledge of Agile and Scrum. -Fluent in English. -Nice to have: Google Cloud,...

I'm looking for a talented songwriter who can create a hit Hindi emotional song for me. The song should center on the theme of heartbreak. Key requirements: - Proficiency in writing Hindi lyrics is a must - Experience in creating emotional songs, especially in the heartbreak genre, is highly preferred Please note that while I prefer a slow tempo for this particular project, this is flexible based on your creative input. The tone of the song is also open to your interpretation and creativity. I'm looking for a unique, engaging and commercially appealing song.

...one side. Private Rooms: Three private rooms for specialized services. Storage: Long storage cabinet along the block wall to optimize space. 3. Design Elements: Ceiling: Open ceiling design or suggested hanging ceiling with decorative elements. Proper lighting with linear lights for brightness. Furniture: Black-colored furniture for a cohesive look. Reception counter and coffee bar table designs to be sleek and modern. Walls: Marble slab design on one long wall for a luxurious touch. Inner wall paint suggestions: Soft and neutral tones to complement the service beds' white color. Glass Showcase: Utilize window glasses for showcasing products to the outside view. Inside view should feature sealed shelves with plain push-open doors. Washrooms: Simple and e...

I'm in need of a talented content writer that can create engaging, short-form content for my audience. Key Requirements: - Ability to craft high-quality content that is less than 500 words in length - Understanding of how to engage an audience through writing - Strong grasp of the English language and grammar - Previous experience in creative writing, blog post...through writing - Strong grasp of the English language and grammar - Previous experience in creative writing, blog posts, or similar content The ideal candidate will be able to make my readers want to dive into the content and keep them interested in every piece. This content should be concise and captivating, designed to get the reader to react or respond. If you can bring these skills to the table, please get in...

I'm in need of a talented designer who can create realistic mockups of various tables for my home decor line. Key Responsibilities: - Designing and creating mockups for tables - Ensuring the mockups are of high quality and look realistic - Providing a variety of designs that align with my brand Ideal Skills & Experience: - Proficiency in design software such as Adobe Photoshop, Illustrator, or others - Experience in creating mockups, particularly for home decor items - A good understanding of my brand and design aesthetic - Strong attention to detail and ability to deliver high-quality, realistic designs %d7%a9%d7%95%d7%9c%d7%97%d7%a0%d7%95%d7%aa-%d7%a1%d7%9c%d7%95%d7%9f this is reference for the type of design I'm looking for

I am seeking a professional to develop a custom click funnel with the primary goal of lead generation. Key Requirements: - Your primary focus will be on capturing leads from individual consumers (B2C). - The follow-up phase of this project will specifically involve creating an automated email series for engaging with the captured leads. Ideal Skills: - Proven experience in building succes...email series for engaging with the captured leads. Ideal Skills: - Proven experience in building successful click funnels for lead generation. - Strong understanding of B2C lead generation tactics. - Proficiency in designing and implementing automated email sequences. This project is of great importance to me, and I am looking forward to working with someone who can bring their expertise to the ...

Model + render coffee and side table. Pictures and dimensions are provided in chat box.

I'm looking for a talented songwriter who can create a hit Hindi emotional song for me. The song should center on the theme of heartbreak. Key requirements: - Proficiency in writing Hindi lyrics is a must - Experience in creating emotional songs, especially in the heartbreak genre, is highly preferred Please note that while I prefer a slow tempo for this particular project, this is flexible based on your creative input. The tone of the song is also open to your interpretation and creativity. I'm looking for a unique, engaging and commercially appealing song.

I have a video of a vehicle involved in an accident, and I need a professional with video manipulation experience to slow down the video and read the license plate. This is required for a police report. Key Responsibilities: - Analyze the video to find the specific frame where the license plate is visible. - Slow down the video effectively for detailed examination. - Accurately decode and transcribe the license plate information. Ideal Candidate: - Proficient in video editing software. - Previous experience in video analysis and enhancement. - Attention to detail and ability to work on a sensitive matter. Need the details of the white pickup that pulls out on the left suddenly.

...Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission and convert the data into a multidimensional array. - Da...

...website. • Ensure domain and hosting are configured. Phase 6: Post-Launch Support (3 months) • Monitor the website for any issues. • Provide bug fixes and updates as needed. • Offer user support. Technology Stack Frontend: • HTML, CSS, JavaScript • Framework: React.js (or Angular/Vue.js) Backend: • Node.js with (or Django/Rails) • Authentication: JWT or OAuth Database: • PostgreSQL or MySQL Payment Gateway: • Stripe, PayPal, or another secure payment processing service Platform: • WhatsApp Business API File Storage: • AWS S3 or Google Cloud Storage Hosting: • AWS, Heroku, or DigitalOcean Budget Estimate Design: $X,000 Development: $X,000 Testing: $X,000 Deployment: $X,000 Support and Maintenance: $X,000/month Key C...

...unique and memorable brand identity. I need a logo for a hotel resort/campus for kids and adults. The name is ARENA. We will have a lot of activities in the campus: - Motorsports (karting track, ATV dirt track, motocross track, etc.) - Motorsport ARENA - Tennis courts - Tennis ARENA - Kids Playground - Playground ARENA - Adventure Park - Adventure ARENA - Football field - Football ARENA - Table tennis (*ping-pong) - Ping-pong ARENA - ZOO garden - ZOO ARENA - Botanical garden - Botanic ARENA - Events center - ARENA Events - Aqua park area - Aquapark ARENA - Paintball track - Paintball ARENA - Legoroom - LEGOLand ARENA - Minigolf track - Minigolf ARENA It’s important for me to have the symbol that can integrate as many as we can from these activities. I was thinking t...

...through the competitive health supplement industry, I'm in search of a talented and creative freelancer to design my product packaging. Key Requirements: - Expertise in designing product packaging, specifically for health supplements. - Strong understanding of designing product visuals that effectively appeals to my target audience – adults and seniors. - Ability to bring creative ideas to the table, yet embody the wellness and trustworthiness of the product through design. - Keen awareness of industry trends and competition. The freelancer should be able to showcase a strong portfolio of product packaging designs, especially within the health supplements sector, demonstrate excellent communication skills, and deliver projects within deadlines. Please submit your...

...begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. Please provide your past experience and any relevant...

I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Con...errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table conversion is required. This is a project with a potential for ongoing work, so a freelancer with good communication and reliability is highly ...

I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.

...skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessary skills to complete ...

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record in creating high-performance ...

...Cards Against Humanity game that needs some adjustments and updates. Key Tasks: - Fixing Errors: The current project has some bugs that need to be addressed. The app is crashing on startup and experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interact...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appeali...enhancements - Excellent problem-solving skills and attention to detail - Ability to work within project deadlines - Good communication skills to understand and implement my requirements accurately. Your ability to combine creativity with technical expertise will be invaluable in achieving the project's goals. Looking forward to working with a skilled professional who can bring fresh ideas ...

...specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience workin...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

...user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to show the sections and login button on right corner - hero section with background image, heading and description of the product - features sections should create multiple sections for each feature with an image and description. - pricing table with 3 variants. - testimonials - footer with company details. 2) Login page - Login page should be divided vertically into two parts left should have a login form with third-party login images like Google, Facebook etc., Right side should be an image showing images in carousel. Bottom of the form should have links to signup. 3) signup page - similar to log...

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should ...methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static method. The other one should compare the performance of the two forecasting methods using the key performance indicators (KPIs) mentioned in Task 1 Question (c). The suggested table format should be used. -SETUP SOLVER WITH CONSTRAINTS of labels and keys for illustration an...

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount on this project.

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...

...service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can populate with our financial data that will then pull into the brochure, into graphs or...

I'm looking for a talented graphic designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform p...Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project is perfect for a designer who can bring fresh and modern ideas to the table. Items attached: 1. list of our current scope of works that is sent to clients. We want this to be visually appealing. 2. Current e-book "7 Things you should know before building a customer home". Please refer t...

...messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides...

I'm seeking a creative and experienced videographer for a high-quality 4k hip-hop music video. It's integral that the final product has a slow and energetic vibe and authentic urban cityscape visuals. Key Expectations: - Mix of both performance shots and narrative elements - Captivate audience through dynamic, energy-infused scenes - Shoot in various urban cityscape locations, potentially incorporating urban landmarks Ideal skills: - Proven experience in music video production, specifically in the hip-hop genre - Proficient in 4K video shooting and editing - Exceptional creativity and understanding of urban culture and aesthetics - Ability to effectively incorporate narrative elements into performance shots - Strong ability to convey energy and movement in videography.