Need set state city database jobs

I'm looking for an experienced freelancer to help me set up the SIP locally to connect incoming calls to an AI script I have. This setup has to be done on VICIdial using the QuestBlue SIP. The main objective of this project is to establish a call response system. As someone with a pre-built AI script, I need you to link it to the incoming calls on the VICIdial platform. Your expertise will include, but not be limited to: - Proficiency in VICIdial: You must have previous experience working with this platform. - Familiarity with SIP set-ups: QuestBlue SIP experience would also be a bonus. - AI Integration: Able to connect incoming calls to an AI script. Please ensure these skills align with your capabilities before bidding on this project.

I'm interested in obtaining a high-quality photo of New York City streets with the Empire State Building in the backdrop. While the architectural magnificence of the building should be captured, the photo should also reflect the vibrant life of the city with elements of street views unique to NYC. Here are some specifics: - The photo needs to be taken during the evening hours. Perhaps capturing the essence of evening lights will add to its charm. **** Lastly, please note this photo is meant to serve as a reference for artistic work, and while it needs to be aesthetically pleasing, it needs to accurately represent the city's streetscape and the Empire State Building. Ideal candidate: - Skilled photographers with expertise in street photography - Pr...

Create an small ecommerce for selling tours in different locations with a landing page, a city page, tours (integration with an existing wp plug in from another system), a cart page and integration with a payment method with our bank (plug in with woocommerce)

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this ...

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this ...

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic datab...

I am looking for an experienced developer to integrate Google Analytics 4 (GA4) into my WooCommerce website. Key tasks will involve: - Setting up GA4 with my WooCommerce platform. - Ensuring accurate tracking for add to cart, checkout completion, and product impression on my ecommerce site. - Setting up Google Tag Manager (GTM), as I'm uncertain about its present state on our site. - This integration is crucial to improve our marketing strategy, so previous experience with similar projects is highly preferred. Ideal skills and experience: - A minimum of two years of experience setting up Google Analytics and Google Tag Manager with WooCommerce. - Expert understanding of ecommerce tracking features in GA4. - Excellent problem-solving skills and attention to detail.

...I'm in need of a skilled developer who can create a city-specific interactive map paired with a versatile booking system. Key Requirements: - Custom Interactive Map: The primary focus of this project is to develop an engaging and functional city-specific map. Users should be able to easily navigate through the city's various locations, businesses, and landmarks. The map should be visually appealing and intuitive to use. - Booking System: The secondary component of this project is the implementation of a versatile booking system. This system should support various types of bookings, including appointment scheduling, room or venue booking, and event ticket reservations. Skillset: - Proficiency in Interactive Map Development: Prior experience in creating in...

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client ...

I'm looking for a freelance graphic designer with experience in modern, sleek logo design to help revamp my current logo to improve my brand identity. It should be state of the art (I think gradients are not used in logos anymore). Key aspects of the project include: - Emphasizing on abstract geometric shapes to create a unique, contemporary look. - Ensuring the design stays modern, yet displays a strong, clear identity - Prioritizing brand recognition and impact in the final design Ideal candidates would be those with a strong portfolio in modern logo design and brand identity development. A deep understanding of current trends, especially in the IT sector will be greatly valued. Excellent knowledge of color theory and the psychological connotations of shapes is also crucial...

As a Flutter Developer, you will review the software specifications and UI mock-ups, develop a cross-browser mobile application from scratch, and lead the application t...user interface components by following well-known Flutter / Dart workflows and practices. · Participate in testing, quality assurance, and bug fixes as part of the CI/CD cycle. Qualifications and Requirements: · 3 to 5 years of experience developing mobile apps natively in iOS and/or Android. · 3 years of commercial experience developing and delivering Flutter-based apps. · Good understanding of state management, Flutter Flavors, and app architecture. · Experience in a remote software development environment. · Experience with building apps and software for consumer goods ...

I'm in need of a skilled Facebook Ad Specialist to take over the set up of my Facebook ad account and campaign. Your main goal will be to help me increase brand awareness and drive website traffic. *NEED SOMEONE WITH PROVEN SUCCESS & EXPERIENCE **GOAL: FINANCE LEADS/FACEBBOOK FORM Will need to create an ad account, get pixel and add pixel to my site or give it to me so I can add it. Need to review my site/niche and create targeting and budget, review my creatives and choose which to use and test, use my ideas for ad copy to create effective ad copy that will convert. Need 4 different ad copy and each with a number of images to test which is the most effective. Would prefer ongoing management so please mention that as secondary but this...

As a client, I'm interested in a proficient developer with experience in Android app development using Kotlin and familiarity with implementing passwordless login and FIDO2 authentication. I want a state-of-the-art Android app designed and built that uses FIDO2 registration and authentication against a Node.js backend with a MongoDB server. The successful freelancer should ideally possess the following skills and experience: - Profound understanding of Kotlin and Android app development - Previous experience with FIDO2 registration - Good grip on Node.js backend and MongoDB server - Familiar with implementing passwordless login Features to be included: - FIDO2 registration and passwordless login - Fingerprint recognition and Facial recognition capabilities in the authentica...

I'm in need of a skilled freelancer who can help me set up a Dynamics D365 demo environment. The primary goal of this setup is for development and testing purposes, so I'm not looking for a simple demo, but rather a full-fledged working system. Key Tasks: - Setting up the Dynamics D365 environment on an on-premises server. Experience with on-premises server configurations, especially for Dynamics 365, is crucial. - Configuring the environment to include the Finance and Operations application. A strong understanding of this specific D365 application is required. Ideal Skills: - Proficiency in setting up Dynamics 365 environments on on-premises servers. - Extensive experience with Dynamics 365 Finance and Operations. - Ability to configure the environment to support...

...I am looking for help to build a Shopfiy store. 1) My business model is the same is this one: -- Speciality local items, souvenirs, food products and gifts from a well-known US state. Im interested in hiring someone who can provide the same or better level of quality, appearance, and professionalism as this site. 2) I have an existing WooCommerce site for a related business and want to transfer about 120 items over, which I have already done via CSV file, but it all needs to be fixed up and organized. I have photos, product descriptions, etc. I just need them to be transferred. 3) I would like the relevant integrations to be made, such as ShipStation, Omnisend, Google Ads, and a number of other apps and integrations to get the site fully functional and integra...

I have to collect 200 cloth store and 200 footware store from each 52 usa state including company name website phone number address city state zip code hours category profile picture description 6 gallery photo. They are will be total 104 csv file. Eac file should contain 200 data.

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

I need someone who will facetime with me to show me how to post an ad on Facebook Marketplace - Apartments for Rent. I do not need you to write copy. I need you to have experience in posting apartment for rent ads. I need a tutor who will go on facetime and watch what i am doing and point out what is right or wrong. I have already posted one ad. This is a tutoring job for at most an hour. The apartment rental ad is already on Facebook marketplace apt for rents. I posted it. I just need an hour of a person to tutor me so I can do it better. So if you read what I need it is not a team or marketing seo skillsets its to have experience in posting in real estate apt for rent and I will pay for an hour of work. So give me a bid for an hour usi...

I'm in need of a skilled and experienced freelancer who has an intermediate level of experience with Omron PLCs and HMIs to review and complete a program for me. Key Requirements: - Proficient with Omron PLC CP1L and HMI NB10W - Intermediate level of experience with Omron PLCs and HMI - Previous experience in similar projects - Able to provide clear and detailed project proposals The ideal candidate should be able to quickly understand the current state of the project and efficiently complete it. I am looking for someone who can bring their expertise and experience to the table, to ensure that the programming is done properly and efficiently.

I'm seeking an experienced street photographer in Katmandu. I wish to capture the essence and vibrancy of the city in a unique and colorful way. Key requirements: - The photographer must be skilled in capturing the life and character of distinct locations such as Thamel, Durbar Square, and Boudhanath Stupa. - The style should be a blend of vibrant and colorful shots along with elegant black and white compositions. Ideal skills and experience for this project: - Proven experience in street photography, ideally in an urban setting - Ability to capture moments naturally and candidly - Strong post-processing skills, especially in creating vibrant and appealing images - Previous work in black and white photography would be a plus, combining with color shots to create a visually ...

I need an experienced freelancer to replicate the design, layout & structure from an existing website to serve as a starting point for our own site. Key tasks involve: - Implementing the structure or an an existing example website on Wordpress. This includes the pages, placeholders for posts, menu structure, etc. - Utilizing Spectra blocks/Kadence theme, contact form 7 Ideal candidate should have strong skills in Wordpress and Spectra/Kadence theme implementation. Please include examples of past work in your application. You will be working from a clean Wordpress install.

I'm in need of a knowledgeable professional to assist in planning the relocation our flexo printing plate making facility in Union City, CA. The task involves moving just two blocks away, but it is no small feat considering the specialized machinery implicated. Equipment to be relocated: - Plate-making machines - Assorted machinery - A cutting table - 200-gallon solvent recycling still - Air compressor Safety and Regulation Compliance: Relocation activities must strictly adhere to regulations pertaining to: - Handling and transportation of chemicals, particularly solvents - Equipment handling safety norms - Facility relocation regulatory compliance Ideal Skills and Experience: The ideal candidate should possess knowledge and experience in plant relocation, particularl...

...autonomously. I will provide the concept and some wireframes, the expectation is you will design and UI and workflow which fits the use cases I need. You must have a good understanding of how App store subscriptions work (), as we will need to implement that. do NOT apply if you are unfamiliar, you will be wasting your time I will not contact you outside of Freelancer, if you ask for it, I will find someone else. The app will be required to create several types of alarms with optional snooze, some metrics need ot be gathered. the alarm screen may need to display an image, do NOT apply if you are unfamiliar with this process, you will be wasting your time You are expected to check in the

¡Please read before submitting proposals! === ➔ The brand name is: Alquila tu vestido mvd "Alquila tu vestido MVD" means "Rent your dress in Montevideo." Montevideo is the capital city of Uruguay. === The overall style of the logo should be: minimalistic, elegant, contemporary It should not include a dress or hangers. The typography should be sans-serif. Elements that could be included in the logo: queen's crown, diamond, small stars, moon, circle with reused arrows. === Values to Enhance through Corporate Image: Elegance, exclusivity, seriousness, sobriety. Elements to Include in Identity: It should be an elegant and clean logo. If using any element, it should be subtle and not directly linked to dress rental. For example: it should not be a dre...

...would cover approximately 1-5 pages. The primary focus would be on crafting a visually appealing, user-friendly and professional-looking website. - Membership Site Setup: I intend to set up a membership site with a basic structure, including a few different levels of membership and resources. Understanding the nuances of membership site setup within Wordpress is a must. - Sales Funnels Creation: I need a sales funnel that converts effectively. Your previous experience in creating and implementing high-performing funnels is highly desirable. specifically: 1. WEBSITE HAS BEEN LAID OUT, NEED TO FINISH IT 2. SET UP REGISTRATION QUESTIONS AND PAYMENTS (WOULD LIKE TO OFFER ACH PMT OPTION ALSO) 3. FUNNEL REGISTRATION QUESTIONS TO AN EXCEL REPORT TO USE FOR MAIL ...

I'm seeking a professional researcher to develop a comprehensive research paper exploring the effectiveness of AI methods against multiple cyber threats in cloud environments. Here’s what I have in mind: • Focusing on the following cyber threats: - Data Breaches - Identity Theft - Malware Attacks • The research should incorporate AI methods...strengths, weaknesses and how they could mitigate the mentioned threats. Ideal Skills: • Solid understanding of Cloud Technologies • Deep knowledge of AI, machine learning, deep learning • Proficient with Research/Writing • Familiarity with cyber threats and security Your informed solutions and recommendations will not only score their effectiveness but also play a role in enhancing the c...

...of my product-centric promotional content through social media reels. Key Responsibilities: * Basic Editing: Your primary role is to make my product shine using basic cuts, seamless transitions, and dynamic text overlays. Ideal Skills and Experience: * Master of Video Editing Softwares: Proficiency in using state-of-the-art video editing software is a must. You should be able to deftly marshal these tools to bring out the best in raw footage. * Social Media Expert: You need to have a grasp of the quirks and features of different social media platforms, especially the ones that utilise reels. * Detail-oriented: A keen eye for detail is important to ensure a smooth viewer experience. * Product-Oriented: Experience in creating product-centric videos designed for promot...

we are trying to reach out to businesses like locksmiths, key cutting stores, shoe repairs, covenience stores and cell phone repair businesss. We are looking for a canada wide list. we need the list to encompass these cities i will find places in these cities: Ontario Toronto Ottawa Mississauga Brampton Hamilton London Markham Vaughan Kitchener Windsor Burlington Greater Sudbury Oshawa Barrie St. Catharines Cambridge Guelph Quebec Montreal Quebec City Laval Gatineau Longueuil Sherbrooke Saguenay Levis Trois-Rivières Terrebonne British Columbia Vancouver Surrey Burnaby Richmond Abbotsford Coquitlam Kelowna victoria Alberta Calgary Edmonton Red Deer Lethbridge Manitoba Winnipeg Saskatchewan Saskatoon Regina Nova Scotia Halifax

I'm looking to enhance my website's SEO to improve my online visibility, traffic, and Google rankings. While the SEO is currently in a fair state, I aspire to take it to the next level. • Enhancing my online visibility: I look forward to making my website unmissable on relevant online platforms which lets people easily discover my website. • Increasing web traffic: The goal is to significantly increase organic traffic to the website. I want to turn searchers into visitors by appearing everywhere they're searching. • Improving page rankings: I'm eager to get my website to the top of search results for my key phrases. Ideal candidates should possess extensive SEO and Google ranking knowledge, have a proven track record of similar projects, and a s...

...attitude and a modern progressive vision. Skills and Experience Required: - Expertise in graphic design and branding - Excellent understanding of design aesthetics and balance - Ability to interpret and translate desired feelings and ideas into design Project Details: - The name of the township to be incorporated into the logo is "Marion Township." - The township located in Allen County in the state of Ohio. - Creative design is your playground, as we are open to color suggestions. - The logo needs to reflect our community-centric ideals, paired with modern and forward-thinking traits. - The logo should be professional, visually appealing, and easily recognizable. - The designer should have a strong understanding of symbolism and the ability to create a visually stri...

I am seeking a skilled civil engineer based in Garner, North Carolina, who has a deep understanding of the city's regulations. The project involves the extension of my commercial property, spanning from its current 2200 square feet to a maximum capacity of 3000 square feet. Specific Requirements: - Site Visit and Realistic Planning: I need a professional who can physically visit the site and provide a practical plan for the renovation. This includes evaluating the existing structure and formulating a design that can accommodate an increase in space without compromising on safety and functionality. - Structural Changes: The focus of the renovation is on structural changes. The ideal candidate should have prior experience in overseeing similar projects and be able to provide in...

We are currently in a basic project, to reactivate the LPG system in a city in the interior of São Paulo/Brazil. There is an existing Vent Stack on site. At this stage of the project, we need to validate, according to Brazilian technical standards and API521, that the system meets, as it was designed and installed in the 80s. To do so, the professional must take into account some data that we will provide below. Documents that the professional needs to generate: - Atmospheric Dispersion Study; - Calculation Memory - Vent Stack System - Process Data Sheet for Vent Stack System Equipment Existing process data (see attachment also): There would be 2 cases of typical relief for system sizing, which would be: 1 - Opening of the PSV for solar irradiation heating of the ...

I'm in need of a React application that will serve as a simple login system. The app will be using MongoDB to store user login information. Process will be: User logs in. Their login information persists in their state and they can create a user profile and access their user profile Log out and log back in

I'm in need of a simple map illustrating the various states and cities of India in a single PDF file. The map should be minimalistic in design and provide details at both state and city levels. Key Requirements: - A map showcasing the layout of states and their respective cities in India - The map should be designed in a minimalistic style - Details at state and city levels should be clear and easily distinguishable Ideal Skills and Experience: - Proficiency in designing and creating detailed maps - Experience in creating minimalistic designs - Familiarity with the layout and geography of India, to ensure accuracy in the map's representation - Previous work in similar projects would be highly regarded

Retrieves the client's IP address. Checks whether the script should run based on a time limit.(5 minute) Retrieves the client's IP details (region and city) using an IP geolocation API. Retrieves a job feed from the specified URL. Filters the job listings based on the client's location (city and region) and excludes certain isp's from been redirected( google/i, amazon/i, Cloudfare/i...) Randomly selects a job listing from the filtered jobs and redirects the user to the selected job listing URL.

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I require a detailed design of a residential spiral staircase, designed per my drawings and details using steel materials. The project should encompass: - calculations, drawings stamp WA State Skills and Experience required: - Proficiency in Architectural design particularly with a focus on spiral staircases. - Comprehensive understanding of material science, particularly metal and its structural implications. - Excellent communication to correctly interpret and incorporate my design ideas and drawings. - Strong attention to details particularly the safety standards of staircase designs for residential use. Your expertise in staircase design and keen attention to detail will make you the ideal fit for me. Get in touch if you have a passion for creating outstanding residen...

I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engag...

I'm stepping into the entrepreneurial world and I need an expert in website creation and social media set-up. - You would be creating an informational website that showcases my products/services. I'm after a clean, straightforward design that prioritizes user-friendly experiences and easy navigation. - Alongside the website, I need to establish my brand's presence on Facebook and Instagram. - I would need the content creation, account set-up, and initial posting taken care of. Key Desirables: - Expertise in creating informational websites - Experience in social media management and content development - Understanding of effective SEO practices - Eye for detail and design aesthetics - Excellent communication and understanding of...

My project requires the creation of a captivating video that provides an in-depth overview of our clinic’s facilities and staff. The primary aim of the video is to engage our existing patients. To achieve this, I want specific emphasis to be laid on: - Our state-of-the-art equipment: showcasing the innovative technology we use in our clinic. - Our top-notch staff: introducing our highly qualified, experienced doctors and their expertise. - Knowledgeable Front of house staff - Conditions we treat - Partners we work with - Talk to us today - shooting some questions such as "waking up feeling stiff and tired?" etc Ideal candidates for this job would have prior experience in creating promotional videos, preferably in the healthcare sector. They should be adep...

...well. We are reaching out to invite you to collaborate with us on an exciting freelance research project focused on identifying Effluent Treatment Plant (ETP) and Sewerage Treatment Plant (STP) manufacturers, as well as wastewater treatment plant suppliers in Maharashtra. As a freelancer, your task would involve comprehensive research to compile a database of relevant companies operating in the field of wastewater treatment across Maharashtra state. The information gathered will be organized into an Excel sheet, including but not limited to: Company Name Email Address Website Address Location and Address Contact Number The scope of the research will cover suppliers located in major industrial estates and towns across Maharashtra. This includes but is not limited to area...

I have al old account of New Relic, I would like to enable again but looking for anybody able to explain me how.

Looking to hire someone fulltime I'm in need of a proficient sales representative to handle cold calls targeting the transport industry within the state of Australia. The ideal candidate should: - Have a proven track record in sales - Possess excellent English language skills - Be able to operate effectively within the Australian market Your primary role will be to initiate and follow up on calls with potential customers to secure sales. If you have a strong background in cold calling, this is a great opportunity to showcase your skills.

Hello check my booking link first carefully I've got a platform that's focused on providing fantastic tour packages for tourists. However, the number of bookings and thus, sales, needs significant improvement. I have already tried using discount campaigns as a strategy to increase sales, but there is still a gap to be filled. To accomplish this: • Understanding of the tourist market and knowledge on attractive tour packages is vital. • Proven experience in implementing sales strategies beyond discount campaigns, in the online tour booking context would be highly beneficial. • Expertise in affiliate marketing and social media promotion is highly desirable, as these are avenues I haven't explored extensively

Hello, I host a game and I would like to send an email to all my old members. There are more than 1 million emails, some are very old from 2005 to 2024, so there will be many bounce emails in between, but I still want to reach out to my old players. I am looking for someone to set up a VPS with a mail server for me. Regards

...am in need of a seasoned EU trademark attorney/legal professional with experience in resolving trademark issues to represent me before the EUIPO. I have encountered a provisional refusal of my trademark application, due to non-compliance with Article 33(2) of the EUTMR. You must have experience of representing third parties before the Office (Articles 119(2) and 120(1) EUTMR). Protection of the international registration for the European Union will be refused in part if I do not appoint a representative within the next 3 weeks (my time limit). KEY TASKS as follows: - Thoroughly examine the grounds given for provisional refusal provided by the EUIPO (highlighted on pages 8 and 9 of the attached PDF). - Identify the terms used for the specific goods and services that the EUIPO ...

Hi First Page SEO, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

We are currently seeking an AI prompt engineer with a rich product content background. The successful applicant will be able to train our artificial intelligence system to generate human-like content based on the current state of our website's products, producing high-quality content that is more valuable to users. Qualifications and Requirements: 1. Bachelor's degree in computer science, artificial intelligence or a related field. Master's degree preferred. 2. Extensive experience in training artificial intelligence models, especially in generating human-like codes. 3. Proficient understanding of current SEO practices. 4. Familiarity with Natural Language Processing (NLP) and Machine Learning technologies. 5. Excellent problem-solving skills and attention to detail....

...ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billing_postcode`, `billing_address`.`street` AS `billing_street`, `billing_address`.`telephone` AS `billing_telephone`, `shipping_address`.`city` AS `shipping_city`, `shipping_address`.`company` AS `shipping_company`, `shipping_address`.`postcode` AS `shipping_postcode`, `shipping_address`.`street` AS `shipping_street`, `shipping_address`.`telephone` AS `shipping_telephone`, GROUP_CONCAT(comme...