Mysql recursive query parent child tree jobber

Hi Dears, I am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4...am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4. Previous projects where you improved MYSQL performance f...

I'm looking for an experienced app developer to create an intuitive DNA trait predictor tool for cats. This tool will predict the offspring's traits based on the user's input of the parent cats' traits. Features to be included in the application are: - Fur color prediction - Eye color prediction - Prediction of dilute traits - Pattern prediction - Silvering prediction - Dominant White & White Spotting prediction - Agouti prediction The design of the user interface involves the use of drop-down menus for trait input

**Project Title:** Transfer and Enhance PHP/Mysql/Ajax Team Organisation Tool to Flutter Web App **Project Description:** We are seeking a skilled developer to assist in migrating an existing PHP/Mysql/Ajax Team Organisation Tool to Flutter, with the aim of releasing it as a web application. The primary objectives of this project include implementing a robust user authentication system, enhancing work organisation capabilities through calendar events, introducing user profile management for self-updating special user data, incorporating team management by assigning role models such as Teammember, Teamorganiser, Controller, Boss, and Admin, adding communication options to send team emails, chats, SMS, and WhatsApp messages, including timestamp functions for each team member w...

I need an experienced programmer to develop a custom-built website for a Loadshedding scheduler. The project has a high priority and needs to be completed as soon as possible Before 20 May 2024 Basics Summary: The Load shedding Scheduler System is a comprehensive solution designed to address the challenges associated with managing and implementing load shedding in an efficient and organized m... - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing this project promptly. Please provide your relevant experience and a proposed timeline for the project. for skills required on this platform i can only put 5 but include Web Hosti...

I require a freelancer with experience in video editing and production to create a promo video from my kid's birthday pictures and video. The ideal candidate would have a mastery in creating engaging music videos to encapsulate the joy of the occasion. - Length: The final product should be 1-3 minutes long, making it perfect for...prefer a music video style, as I believe these videos are engaging and lively. - Music: I don't have specific songs in mind. Therefore, I trust the freelancer would incorporate kid-friendly music that enhances the tone of the video. The perfect freelancer for this project needs to have prior experience producing promotional and event videos, specifically those involving children. Understanding of child-friendly themes and creativity in video e...

I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.

...experienced Shopify app developer to create a specialized app for me. This app should have the following functionalities: 1. Select the Order Date and time slot in the local delivery 2. Select the store pickup address for order 3. Very Pincode for local develiry is available or not this pincode? Require Skill - Shopify Order Edit - Shopify Webhook - REST API - Node.js and React.js - MySQL and Postgres - Javascript, HTML, CSS, Jquery A critical feature I require is the ability to gather specific information with each order. This should include: - The ability to select an order date via a calendar date picker. - Collect and record this order date. Ideal candidates for this project should be experienced in the development of Shopify apps, with a particular e...

I'm seeking a professional to help migrate my existing Grafana 8 alerts to Grafana 10. Your proposal should include detailed project plans and timelines for completing the following tasks: - Alert Configuration: This includes setting up and configuring alerts based on specific metrics, thresholds and conditions. - Alert Rule Mappi...alert notifications to ensure they are received by the relevant parties promptly and efficiently. Ideal candidates should have: - Extensive experience with Grafana and its alerting system - A proven track record of successful alert migration projects - Excellent communication skills and a proactive approach to problem-solving. While not mandatory, experience with Prometheus, Elasticsearch, and MySQL would be a plus given the data sources we'...

..., and its MySQL database on Cloudways. I'm looking for a professional to transfer both the frontend and backend to DigitalOcean. I need help in setting up the server and transferring the database as well. Key Project Requirements: - Transfer existing Angular project from to DigitalOcean - Move existing MySQL database hosted on Cloudways to DigitalOcean - Set up the server on DigitalOcean for hosting the Angular project - Transfer and configure the MySQL database on DigitalOcean - Ensure the migration process is smooth and without downtime - No manual deployment used, so expertise in this area is crucial Ideal Freelancer: - Proficient in Angular for frontend transfer - Experienced with setup and configuration of servers on DigitalOcean - Skilled in MySQL...

I'm in need of a skilled Shopify App Developer to create an innovative, new application that specifically includes an 'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be...'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be easy to use and intuitive. - Requires seamless integration with my Shopify store. Ideal Skills & Experience: - Shopify App Development - UI/UX Design - Knowledge of eCommerce and order processing. - Node.js and React.js Expertise - Mysql and Postgres - Javascript, HTML, CSS, Jquery Looking forward to dis...

Custom Task Management System By ARABIC Language RTL , From Scratch SDLC To Deploy. I have Some Screens to understand Most Requirement> Requirement: PHP Laravel 11 MySQL Jquery CSS Bootstrap All Must be the last versions.

We have a device which is transmitting using JT808 , we want to capture that transmission and write in a mysql db. We will not provide documentation on JT808. Do NOT bid if you do not have experience with this protocol. If you have worked before with this protocol, please give a brief explanation of what you did.

I'm looking for a skilled professional to help me create an introduction video about family tree with audio & video editing, Key Requirements: - The main goal of this project is to visualize family tree & relationships in a digital format. - I want the family tree to be interactive, with some engaging features that can help viewers understand the relationships more effectively. Ideal Skills and Experience: - Experience in video editor

...license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a download link to Excel Template PRO. * The email system should also forward invoice details to the buyer with a copy to the site administrator. + The Coder has to create a Macro in my Excel Template to validate License keys connecting to our DB. Ideal applicants will possess: * Proficiency in Python and MySQL. * Experience in API development and integration. * Ability to create unique, veri...

Vennligst Registrer deg eller Logg inn for å se detaljer.

I'm seeking a skilled 3D modeler to bring my vision for a culturally significant scene to life. The purpose of this project is to contribute to the preservation of Australian Aboriginal culture through a 3D model. I need a 3D model of an elder sitting with a child. It's crucial that this model reflects the nuances and significance of this intergenerational relationship in the Aboriginal community. Ideal candidates should: - Have excellent experience in 3D modeling - Understand the cultural significance of Australian Aboriginal culture - Be able to create a detailed and realistic 3D model - Have a portfolio or examples of similar work This project will be a great opportunity for someone who appreciates and understands the importance of cultural preservation.

I'm in need of an expert with outstanding knowledge of Gluster Configuration, Forge Laravel, Linode, and nginx configuration to help deploy my Laravel application. You will employ the Forge Laravel server operating system for this project and will be required to set up a MySQL database to work in concert with my app. I'm looking for someone with: - A solid understanding of Laravel application deployment using Forge - Proficient skills in server configuration with nginx - Extensive knowledge of MySQL databases and their integration with Laravel projects - Experience with Linode If you are proficient in these areas, then you're the person I'm looking for. Please shoot me a bid and let's get to work!

...exclusively prioritize text-based news articles. With featured images No video or audio content is to be included. - The platform should support the English language, as it is the primary medium for news in the region. -The platform shall pick news from sites I authorize to avoid fake news The platform should allow reading of articles (1st 3 paragraphs) before referring user to read fulll article at the parent site from where the article originates. The platform should give use ability to read full article from within the site environment -Exquisite design and user friendliness is a must -Must be mobile responsive as 90% of the users shall access the site use their phones. Ideal Skills and Experience: - Proficiency in web development, particularly in designing and creating u...

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

In need of a skilled professional who can help me with an exciting object detection project using LiDAR data. This project primarily involves: - Implementing object detection algorithms on LiDAR datasets. - The detection should be detailed, focusing on specific models like car models and tree species. - The detected object data will be used for research and development, aiming to refine and improve current detection algorithms. The ideal candidate for this project should have: - Strong background in LiDAR data processing. - Proficiency in object detection algorithms, particularly for LiDAR data. - Experience in working with detailed object detection, such as specific models. - Ability to use the detected object data for research and development purposes. If you have a keen in...

I am seeking an experienced Architect or draftsman to develop a 2D playground specifically targeted for children. Ideal Skills: - Experience with creating kids' games. - Understands child psychology and gaming trends. - Proven experience in 2D design. The key features or activities to be included were not specified, so feel free to be creative and suggest some based on your experience and understanding of what might work best in a children's game. However, it would be great if the game includes but is not limited to popular play elements like swings, slides, and climbing structures. Please include examples of previous similar work in your proposal.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I'm looking for an app developer to create a school management software compatible with Android and web browsers. The software should have the following features: - Attendance tracking: Capable of recording and tracking student attendance. - Grade management: Enabling teachers to input, calculate, and manage student grades. - Parent-teacher communication: Facilitating seamless communication between parents and teachers. User Roles I envision the software having three distinct user roles: - Admin: Main role responsible for overseeing the software and its functions. - Teachers: Staff members who use the software for attendance and grade management. - Parents: With access to the software for communication with teachers and monitoring their child's progress. The ideal cand...

I am in need of a professional to convert a CSV file with about 3000 lines into a .sql file, ready for flawless loading into a MySQL database. THIS HAS TO BE DONE WITHIN THE NEXT 60 MINUTES. PLEASE DO NOT BID UNLESS YOU CAN DO IT IMMEDIATELY. THANKS. Payment will be $25. US Key tasks: - Convert provided CSV file into a .sql file - Ensure Date/Time values are formatted according to MySQL Date/Time format - Format numeric values as FLOAT within MySQL - Configure date/time values to match my local timezone Skills & Experience: - Proficient in SQL - Experience with MySQL databases - Attention to detail and accuracy Understanding of Time Zones would be a complimentary bonus. This project requires quality and accuracy. Thanks in advance for your valuable ...

...Features: - Centralized Case Tracking: The software must enable me to track and manage individual cases efficiently. - Comprehensive Reporting: Robust analytics and reporting functionalities are crucial. This will help me generate the necessary reports for stakeholders and assess the progress of each case. Specific Case Details to Manage: - Personal Information: This includes basic details of the child. - Educational History: Tracking the child's progression in the educational sphere. - Coordinators' Notes: The software should allow me to input and access notes from different coordinators involved in a case. - Billing: It should enable billing based on the hours worked. - Scheduling: The software should have a scheduling feature that would help in organizing visits, th...

I need a WooCommerce plugin that will enforce a time limit on the user's cart with specific products. - **Product Specification**: The plugin should allow me to specify a particular product for time-limited checkout. - **Time Limit Enfo...time-limited checkout. - **Time Limit Enforcement**: The customer should be prompted to complete the purchase before the time limit expires. - **Automatic Removal**: If the customer exceeds the time limit, the specified product should be automatically removed from the cart. Ideal Skills and Experience: - Proficient in WooCommerce and WordPress Plugin Development - Competent in PHP, JavaScript, and MySQL - Previous experience in developing time-limited cart functionalities is preferred - Strong understanding of e-commerce practices and custo...

...compatibility across various devices and browsers Integrate third-party APIs and services as needed Conduct thorough testing to identify and resolve any bugs or issues Provide ongoing support and maintenance for the website and plugins Requirements: Proficiency in WordPress development, including theme and plugin development Strong understanding of PHP, HTML, CSS, and JavaScript/jQuery Experience with MySQL databases and SQL queries Familiarity with version control systems such as Git Knowledge of WordPress security best practices Ability to troubleshoot and debug issues effectively Excellent communication and collaboration skills Attention to detail and a commitment to delivering high-quality work Duration: This is initially a one-month project with the possibility of extensi...

I'm in need of a PHP developer who can help ...current system. The goal is to unencode emails with 'Content-Type: text/html; charset=utf-8' and 'Content-Transfer-Encoding: base64' and then save the body, along with the subject, sender, recipient, and date into my existing MySQL database. Key Requirements: - Use PHP to unencode the email and save the content into MySQL - Omit attachments from this process - Ensure the subject, sender, recipient, date, and body are accurately stored in the database Ideal Skills: - Proficiency in PHP and MySQL - Experience with email parsing and decoding - Knowledge of email headers and MySQL schemas - Attention to detail to ensure all data is correctly stored NOTE: Files will be passed back and forth us...

Looking for expert DBA having an experience with Amazon RDS MySQL 8 Community edition. Lot of queries are stuck in "executing" state without any kind of database table locking. Most of the queries stuck are all "SELECT" queries. The queries itself is fully optimized using joins and indexing for better performance and those are regular queries which are executing just fine without any issue since many months. If you have a VAST amount of AWS experience, reply with the text "I have a vast amount of AWS experience and I am available right now to help." Thanks! --- Comments below are from AI -- I am in urgent need of AWS server administrator to resolve critical issues with my EC2 and RDS services. The server is currently experiencing performance degrada...

...a children's book plus the book cover. Key Requirements: - Proven experience in illustrating children's books, with a portfolio showcasing relevant work. - Proficiency in creating high-quality, engaging, and child-friendly cartoon illustrations. - Consistency in delivering work on time and with attention to detail. - Ability to adapt to the narrative and bring the characters to life through your illustrations. Ideal Skills and Experience: - Proficient in digital illustration software. - Prior experience working on children's books or related projects. - Strong understanding of child psychology and the ability to create illustrations that resonate with the target audience. - Excellent communication skills to understand and align with the vision of the book&...

I'm seeking a skilled backend developer to assist with API development and integration with a MySQL database. To help build a website that has this purpose- The purpose of the 'Thai Wills' web application is to provide a user-friendly platform where registered users can create legal wills online. The application aims to simplify the process of will creation through an automated system for basic wills, while facilitating access to legal services for more complex will situations. Scope • The development of the'Thai Wills' web application which includes user registration, questionnaire-based will generation, and an interface for admin and legal professionals to manage and facilitate the will creation process. The scope includes: ▪ Basic will creation th...

...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...

...large double doors that's one at the front of the property and one at the rear of the property all doors are to have a self-closing mechanism, smart locks with fingerprint, facial recognition, the garage door must be armoured please see link before for examples of doors and gates all internal doors must also be armoured with a self-closing mechanism as well but must bust be light enough for a young child to open and close with ease. All socket outlets are to be UK standard 3-pin sockets with USB type C ports, all lights to be led, all heating is to be done by electrical heaters and AC, main entrance should have a led chandelier. Property to get power from battery 2x battery packs that can individually be turned off in an emergency or when under maintenance, solar panels to...

... – Copy Trade (decoded) Overview : Copy trades from one account to another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of ch...

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I want to use the child features like on this t-shirt. Not the whole face. Just the eyes, eyebrows, nose, and mouth as shown in the picture.

Se necesita programador PHP + MySQL para desarrollo de página web y BackOffice de la misma

...componentes y ajustarlos para que la aplicacción que se está desarrollando en C# trabaje con normalidad. Teniendo en cuenta que será publicada en entorno Web y Móbil (Android y Apple). Los requerimientos hasta el momento han quedado de la siguiente manera: - Ubuntu 24.04 Server LTS - .NET Core - Krestel - Apache como proxy inverso sobre Krestel - MySQL - Tareas de respaldo para el entorno a nivel de componentes y tareas de respaldo para el MySQL. - Configurar la seguridad requerida ya que esta app, estara accesible directamente desde internet. Quedo atento a sus propuestas, Tengan buen día....

...Images of books, letters, and phonics materials to convey the educational aspect. Text: Catchy headline emphasising the benefits of the programme (e.g., "Unlock Your Child's Reading Potential"). Clear and concise course description highlighting key points from the provided description. Prominent display of dates (28th - 31st May) and price (£100). Call to action encouraging parents to enrol their child ("Book Now!"). Incentives: Highlight the £5 discount for bringing a friend to encourage word-of-mouth promotion. Branding: Incorporate the Accelerate Learnings logo Poster Specifications: Size: A3 (297mm x 420mm), Instagram sizing Orientation: Landscape. Format: High-resolution digital file for both print and online promotion. Additional Notes...

I am seeking a talented designer to create an enticing, modern, yet clean and minimalist landing page suitable for parents of 6 to14 years old children. The focus of the landing page is our program or service, and it needs to strongly appeal to our demographic while encompassing a vibrant and contemporary design. We have a layout with structure and content of o...design - Proven experience in designing for a specific demographic, in this case parents. - Knowledge of Figma or other design tools Please, take into account that this work needs to resonate with parents of 6 to 14 years old children. The color scheme and visual themes need to be derived from the layout attached. The design should be bright, playful yet professional, and needs to incorporate child-friendly illustrations...

Postgres data query system Docker across multiple servers

I'm in need of a skilled product designer to create a product that will cater to children. This product will serve the purpose of solving a specific problem in a creative and engaging way. The design phase will be for both physical and digital aspects of the product. Key Responsibilities: - Designing a product that is child-friendly and appealing - Incorporating innovative solutions to address a specific issue - Creating a seamless user experience for children - Balancing the physical and digital aspects of the product Ideal Skills: - Previous experience in designing products for children - Strong understanding of both physical and digital product design - Ability to think creatively and innovatively - Excellent user experience design skills - Good communication skills to un...

...of two pixels in length. Think well about the problem and once you are sure of a solution, design on the paper (this "design" needs be then described into the pseudo code part) and then implement a program ex1(input_file, output_file) which: - reads the file indicated by the parameter 'input_file' using the 'images' library - preprocesses the image--if needed--and implements a *recursive* function to solve the requirements below. - counts all the patches of lands that are in the image and returns the number of patches. It should return the number of rectangles with the color of the background that is present in the image. Regarding the simplified case below: # +++++++++++++++++++ # +-1-|-2-|---------+ ...

We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...

I'm looking for a skilled PHP developer who can create a secure login and register system using fingerprint data stored in a MySQL database. The system must ensure seamless user experience, while maintaining strong security measures to protect sensitive data. Key Features: - Implementation of a biometric device for fingerprint data collection - Two-factor authentication to enhance the system's security - Support for multiple user roles with distinct permissions Ideal Skills and Experience: - Proficient in PHP programming language - Experience in MySQL database management - Strong understanding of data security principles and practices - Prior experience in implementing biometric systems would be advantageous - Excellent problem-solving and communication skills If...

I'm looking for a talented developer to create an interactive D3 tree for showcasing a family tree. This is a unique project, and I need someone with experience in D3.js and working with large datasets. The main requirements are as follows: - Visualizing a family tree: The D3 tree should be able to display a large family tree with 100 generations. It should be easy to navigate and explore. - Experience with D3.js: I need someone with proven experience in D3.js and creating interactive data visualizations. - Handling large datasets: Given the size of the family tree, the project may require expertise in handling, processing, and visualizing large datasets efficiently. Current website: the design theme is completed, the website has some feat...

I'm seeking an experienced web designer to create a vibrant and user-friendly e-commerce website for selling party balloons. While the site should appeal to both children and adults, my unique selling point will be the elegant theme of the balloons. Ideal skills for the job: - Solid understanding of e-commerce web design - Ability to captivate both child and adult audience through design - Experience in creating visually appealing and intuitive e-commerce platforms Job Experience Requirements: - Previous experience in e-commerce site development is a must - Proven track record of creating websites that cater to diverse age groups - Experience in incorporating elegant themes in design will be an added advantage. This site will be a one-stop-shop for party planners seeking e...

I'm leading the development of a cutting-edge video streaming app using Flutter. Our aim is to provide users with a seamless entertainment experience, offering a wide range of conten...protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable working with cloud platforms like AWS or Google Cloud. 7. Be familiar with DevOps practices like CI/CD and containerization. 8. Possess strong collaboration and commun...

I'm seeking a skilled marketing professional to help me execute a multichannel marketing campaign. The primary goal of this campaign is to increase brand awareness. This will involve reaching out to Millennials and Parents through Social Media and Email Market...Create engaging content to resonate with our target audiences. - Implement and monitor the performance of the campaign. - Analyze data and adjust strategies accordingly to ensure maximum brand exposure. The ideal candidate should have: - Proven experience in managing multichannel marketing campaigns. - Expertise in Social Media and Email Marketing. - Strong understanding of the Millennial and Parent demographics. - Excellent content creation and copywriting skills. - Ability to track and analyze data to optimize campai...