Joomla select query with where conditions jobs

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

Please Sign Up or Login to see details.

I'm looking for a designer who can create a playful and fun voucher for a dentist. The voucher needs to be well-organized and include the dentist's name, contact details, services included, and terms and conditions. The design should be ready for print in DL size (99mm x 210mm). Ideal candidates for this project should have experience in creating vouchers or similar materials and have a knack for creating fun, engaging visuals. Please include samples of similar projects in your portfolio.

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

...experienced developer to create a user-friendly web application. Users will upload two images: a headshot and an image of an item of clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The fina...

Please Sign Up or Login to see details.

I'm looking for a Python developer to create a simple Dash app that includes a PDF viewer. Key Requirements: - User can upload multiple pdf files in the app. - The user can select which pdf should be displayed in the viewer - the user can enter a text in a text box and when hit submit the app should be able to highlight those texts in the PDF. - The pdf viewer should have search feature, pages and zoom in and out.

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot s...functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and respo...

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. ...

More details: What specific bug or issue are you experiencing in your app? App crashing Under what conditions does the app crash? On startup What is the primary function of your app? dating app

...study will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's calendar availability. There is an ability for the student to schedule a set of sessions for a whole subject or many subjects, with a specific Instructor, then determine date/ti...

I'm seeking a skilled developer to create a comprehensive priest booking platform that will enable users to book priests for religious services and schedule events at specific temples or with particular priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Prof...

Please Sign Up or Login to see details.

I need a skilled website designer to create an engaging and user-friendly platform that reflects my unique doctor services. This includes providing general check-ups, diagnosing and treating various health conditions, and offering specialized procedures in functional medicine, with a focus on measuring energy density in the body for improved wellness. The website should include sections detailing my services, a knowledge hub regarding body energy measurements at a cellular level, and a segment for clients seeking customized treatments. Key Qualifications: - Experience in e-commerce website design - Knowledge of medical and health-related content - Exceptional visual design skills The ideal candidate should be able to use compelling graphics and visuals to explain complic...

I'm looking for a skilled game tester to assist in the quality assurance of my upcoming action game. The game runs on a PC, so it is crucial that you have access to a compatible system. Your main responsibility will be to identify, record, and track any bugs or glitches in the game. This will involve playing through the game multiple times, under different conditions, to ensure all potential issues are captured. It is essential that the successful candidate has: - A keen eye for detail - A methodical approach to problem-solving - Excellent communication skills to accurately report bugs Previous experience in game testing, particularly on PC, would be highly advantageous. Job is only around 15 - 30 minutes.

Hello, how are you, I have a very easy task in Angular for someone who knows about NgRx. popular a select to make the call to an api (store). It's angular 15 and you have to know about actions, reducers, effects, and everything about NgRx. This should take 1-2 hours and my budget is $14. If you complete it there will be more tasks later. Write the word ragnar to know you read this. Thank you.

...& Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multiple tables in the DB,...

...offline data storage. Consider it an offline simplified Instagram app: Dashboard gallery - has a + button that creates a post (see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logg...

Hi Saira Arif M., as discussed this involves configuring Nginx on an AWS EC2 instance to properly serve a frontend React app under a custom domain while addressing SSL issues. Nginx configuration files need to be set up to ensure seamless access to the React site via the specified domain, resolving any SSL-related issues to ensure secure connections. my price is 10$ and I have one conditions: If you are happy we can do it right now

I'm looking for...definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in finance or trading would be beneficial. This project requires a freelancer who is detail-oriented, with a keen eye for market trends, and can create a reliable and efficient script that aligns with my specific requirements. I'm open to discussing and incorporating a...

...via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts the resulting photos ◦ Sees your historical orders as well Here is the necessary screens: ### 1. Login Screen - **Purpose:** Allow users (brokers and photographers) to log in. - **Elements:** - Email/Username input - Password input - Login button - Forgot Password link - Signup link ### 2...

I'm looking for...definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in finance or trading would be beneficial. This project requires a freelancer who is detail-oriented, with a keen eye for market trends, and can create a reliable and efficient script that aligns with my specific requirements. I'm open to discussing and incorporating a...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects peo...community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes

I'm looking for a skilled game tester to assist in the quality assurance of my upcoming action game. The game runs on a PC, so it is crucial that you have access to a compatible system. Your main responsibility will be to identify, record, and track any bugs or glitches in the game. This will involve playing through the game multiple times, under different conditions, to ensure all potential issues are captured. It is essential that the successful candidate has: - A keen eye for detail - A methodical approach to problem-solving - Excellent communication skills to accurately report bugs Previous experience in game testing, particularly on PC, would be highly advantageous. Job is only around 15 - 30 minutes.

I am looking for a skilled individual to customize and install a website template for my project. The ideal candidate will have experience with website design, development, and template customization. Requirements: Proficiency in HTML, CSS, and JavaScript Experience with website templates (e.g., WordPress, Joomla, HTML templates) Ability to modify and customize templates to meet specific requirements Knowledge of web hosting and installation processes Attention to detail and good communication skills Responsibilities: Customize the website template according to my specifications Install the customized template on the web hosting server Ensure the website is fully functional and responsive What

I'm in need of a Trend-following indicator for the TradingView platform. I require this indicator to offer more than just basic settings adjustments; I'm looking for it to have specific alert conditions. Key Features: - Trend-following Indicator: The indicator should be designed to effectively identify and track trends in the market. - Customizable Alerts: I need the indicator to have specific alert conditions that can be customized to my preferences. Ideal Freelancer: - Experience in developing indicators for the TradingView platform. - Proficiency in implementing alert conditions. - Strong understanding of trend-following indicators and their uses in trading.

...have the main purpose of enabling users to create NFC cards, generate QR codes, and edit their unique links. Key Features: - The website is to be built on WordPress, so expertise in this platform is a must. - Users should be able to select templates for their cards, upload images, and customize text. - Crucially, they must be able to input their desired content and have the system generate NFC cards and QR codes accordingly. This implies a seamless, automated process that requires expert coding. Ideal Skills and Experience: - Proficiency in WordPress, with experience in developing custom websites. - Strong knowledge of NFC card creation and QR code generation. - Experience in implementing user-friendly interfaces for template selection, image upload, and text customiz...

...school discovery platform in the UAE. Project Title: Comprehensive Market Research for School Discovery Platform in UAE Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: -Collect up-to-date statistics on the UAE education sector,...

...their own web pages within the main site, where they can upload movie posters along with comprehensive metadata about the movies. The homepage will showcase various top critics and their recommendations. General users can browse through these critics, select their preferred ones, and navigate to their individual pages. On a critic's page, users can view movie recommendations and sort movies by various criteria, such as year or genre. ### Project Problem Statement **Project Problem Statement: Development of a Movie Critique and Review Platform** **Objective:** To develop a web-based platform that allows users, specifically movie critics, to publish and manage their own movie critiques, reviews, and recommendations, while providing general users with a...

Project Title: Comprehensive Market Research for School Discovery Platform Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enroll...

...project involves extensive customization and integration of various features primarily tailored for a multi-branch business model. The system must be able to handle multiple branch warehouses, with each customer being assigned to a specific branch based on their location. Key Requirements: - Integration of Point of Sale (POS), Accounting, Customer Relationship Management (CRM), Inventory Management and Purchases features from Odoo ERP. - Implementation of a system that assigns customers to a branch based on their location. This should be done automatically based on IP, and also allow customers to manually select their preferred branch. - Seamless user interface that enables easy navigation for customers across the website. - Implementation of multiple warehouse functional...

I'm searching for an experienced video editor to professionally edit our wedding footage into a final, 5-10 minute cinematic movie. This transformative effort should take raw footage and create a compelling story, imbued with emotion and beauty. Ideal Skills & Experience: * Mastery of Adobe Premiere Pro, Final Cut Pro, or iMovie. * Proven track record of cinematic-style video editing. * Strong sense of storytelling through film. * Keen eye for detail and creative flair. * Experience with wedding videography is a plus. Your task will be to sift through raw footage, select the best shots, and seamlessly assemble a captivating, cinematic narrative. Your creative input in the editing choices is strongly encouraged as you work towards creating a cherished keepsa...

...Proficient in both iOS and Android app development. - Experience with document processing and merging. - Knowledge of file format compatibility. Please provide samples of your previous work, especially if you have developed applications with similar features. The Db is already designed Here is some key points: User interface in the app • Login/ register (Email verification) • Forgot password • Show the historical orders The user I formation to register will be Full name Adresse IP adresse scanned during the registration Telephone number Admin Interface (web only) • Enable/disable users • User password reset functionality (user will receive an email for a reset password) • View user historical orders with a ...

I'm in need of a freelancer who can help with integrating Klaviyo into my Joomla Gridbox website. Key Requirements: - E-commerce Integration: The primary reason for this integration is to enhance the e-commerce capabilities of the website. I want the Klaviyo integration to be seamless and optimized for the products on the platform. The ideal candidate should have: - Proficiency in Klaviyo integration - Experience with Joomla Gridbox - E-commerce integration expertise. Your role will be pivotal in ensuring a successful integration that improves overall efficiency and boosts the e-commerce functionality of the website.

Your Responsibilities: System Monitoring and Maintenance You will monitor system health, proactively respond to monitoring alerts, and inspect application and system logs to take appropriate action in case of error conditions. Development and Implementation You will support in defining and implementing Kubernetes deployments and provide consultation in creating Kubernetes manifests for custom deployments. Software Audits and Disaster Recovery You are responsible for software updates, VM configurations, and the system's disaster recovery. • general VM updates and configuration through ours to be built IaC definitions (Terraform, Ansible and Kubernetes) • inspecting newer container images and software versions • planning and executing updates on infrastructure com...

I am in need of a fluent Uzbek to US English translator for translating website content. The content includes various types of legal documents, with a particular emphasis on terms and conditions. it's a long tram project. Key Requirements: - Proficiency in both Uzbek to US English - Ability to accurately translate legal documents, with a strong focus on terms and conditions - Experience in translating website content - you have to pass a task to do the translation Ideal Skills: - Prior experience in legal translation - Familiarity with terms and conditions - Understanding of website content translation best practices The successful applicant will need to convey the nuances of legal language in a clear and accurate way, ensuring that the tr...

I have a strategy with some conditions slightly complex. It should not take alot of time for someone who is experienced in using tradetron.

...TradingView Pine Script. The primary function of the current code is to execute trading decisions based on the conditions of the market. **** 1 MORE CONDITION TO BE ADDED MENTIONED IN TXT FILE ATTACHED******* ***** FIXED PRICE RS. 3000/- ONLY ******* Key requirements: - Conversion: The Amibroker AFL strategy needs to be converted to TradingView Pine Script. The converted script should retain the functionality and logic of the original. - Optimization: The Pine Script should be optimized for performance on the TradingView platform, ensuring efficient execution and minimal latency. - Strategy understanding: It's crucial that the freelancer understands the trading logic and conditions embedded in the Amibroker AFL script, and can effectively translate these into the new ...

I am in need of a skilled and creative designer to develop a modern style logo for my brand. The logo should represent brand identity and be visually striking using bright and bold colors. Key requirements: - Create a logo that effectively communicates brand identity - Utilize a modern design style - Select bright and bold colors for the logo The ideal candidate should have: - Proven experience in logo design - A strong portfolio of modern and creative logos - Ability to deliver high-quality work in a timely manner - Excellent communication skills to understand and incorporate feedback.

I'm looking for a skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems...

...compatible with both iOS and Android devices. - The primary goal of the app will be daily reporting. This means users will be able to easily submit reports on a daily basis. - The app should be intuitive, user-friendly and well-designed. - Security is also a key consideration, as the reports will likely contain sensitive information and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

...This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replicating our current site, which includes the following ce...

...photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01")) Shell ("D:khalid " & jpegfilename & " " & pdffilename) ' = True sheetxx(i).Select sheetxx(i).ChartObjects(1).Activate For Each objCht In fname1 & i & "...

... while also ensuring that the design is consistent with my existing brand assets. Key requirements and considerations for the project include: - **Multiple Pricing Handling**: You will need to create a mechanism that can adjust product pricing based on various inputs like length, cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current brand assets to maintain a cohesive visual identity across all touchpoints. I'm seeking a freelancer with the following ...

I'm looking for a talented designer to create a new logo for our business, Southern Smoked Co. We are a small startup that smokes BBQ meats and fish. Some key concept themes include: -wood, -fire, -smoke, -mea...logos - Expertise in versatile logo design that can be adapted to different color schemes - Strong understanding of brand identity and able to reflect this in the design. We are very open to ideas! Please be creative and progressive. We will only select logos that show a high level of thought, and skill in production. We will need logos to be provided in a variety of colours (if thats the way you design them), in editable formats with all rights transferred at the point of completion. We look forward to working with you - we will be active ...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

...simple, one-page website for my restobar. Key features should include: - A rustic and minimalistic design that's eye-catching and easy to navigate - Integrations with Google Maps for location and social media, specifically Instagram, with recent IG posts visible on the site - The inclusion of key elements like a few select high-resolution photos, our menu, and contact information The ideal freelancer for this project should have a wealth of experience in website design and should be familiar with integrating various platforms into a site. I need a detailed project proposal that outlines your suggested approach to the job. Familiarity with the restaurant or hospitality industry might be an advantage, but it isn’t a requirement. I'm loo...

Interactive web browser app (mobile compatible) that does a simple questionnaire, based on 0. Home page where user is prompted to START. UI should be clean and feel open and creative. Shouldn't be much on the home page. Should be an area/page to show some instructions of the app. 1. Before the questionnaire there are some options to choose, e.g. language, version of Bible, sections of the Bible i.e. Pentateuch / History Books / Writings / Prophets / Old Testament / New Testament. The user doesn't have to choose these each time, just the first time, to be saved in browser. If they want to modify it in the subsequent questionnaires they take, they are able to do so as an option. 2. Then there is a simple 10 question questionnaire. All using API logic. For each question