The MySQL line
2 USD Client's review of cooperation with Vanya Kutuzov
The MySQL lineWork is done quickly and quality
Freelancer's review of cooperation with Vladyslav Horodnytskyi
The MySQL line+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
-
1 day9 USD
465 27 0 1 day9 USDWelcome, you are ready to implement this project.
To clarify the details of the project and the full cost, go to LS or...
Skype for Spider13 Software
ICQ 3533966
Posts Tagged @spider13software
The website is https://spider13.net/
-
1 day4 USD
1036 44 0 1 day4 USD
I do right now.
I do right now.
I do right now.
-
1 day2 USD
224 20 2 1 day2 USD
Good day ,
I can do it today, but I need the text of this request and the empty dump of your BD (so that it is possible to play it with me). The amount of the rate is conditional, it can be clarified by the outcome of familiarity with the original data. thank you.
–
with respect,
The I.V.
-
Winning proposal1 day2 USD
2593 427 9 1 Winning proposal1 day2 USD
Break the line and what to do.
=- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =- =-
-
Покажите строку запроса
-
SELECT dedicated_ip.ip,dedicated.port_ssh,dedicated.strana as dedicated_strana,dedicated.install_dir,dedicated.id as dedic_id,auth_members.name as user_name,auth_members.phone as user_phone,auth_members.mail as user_mail,`status`,servers.`user` as ftpuser,servers.`server_name` as server_name,servers.`password` as ftppassword,`slots`,`day`,`namesurname`,`country1`,`country2`,`countryorder`,`ordername`,`ordercount`,`fullordercount`,`sellordercount`,`orderprice1`,`orderprice2`,`timestorage`,`sellstorage`,`orderstatus`,`orderlink`,`orderphone`,`email`,`skype`,`viber`,`whatsapp`,`telegram`,`otherphone`,`comments`,`descriptions`,`payout`,`leftpayout`,`tid`,`param`,`orderback`,`invoice_id`,tarif.`name` as tarif_name,tarif.`startmap` as tarif_startmap,tarif.game_prefix,tarif.art_prefix as art_prefix,`port`,`user_id`,servers.`id` from servers LEFT JOIN tarif ON servers.tarif=tarif.id LEFT JOIN auth_members ON servers.user_id=auth_members.id LEFT JOIN dedicated ON servers.dedic_id=dedicated.id LEFT JOIN dedicated_ip ON servers.ip_id=dedicated_ip.id ORDER BY servers.id
-
Одного запроса маловато. В чем проблема то? Не отрабатывает? Ошибка? Тут бы еще структуру БД глянуть.
-
проблема в том что where ломает всю конструкцию
-
я уже даже не знаю куда его добавить, в любом месте даже перед ORDER BY, всегда ломает, как указать правильно не знаю
-
SELECT dedicated_ip.ip,dedicated.port_ssh,dedicated.strana as dedicated_strana,dedicated.install_dir,dedicated.id as dedic_id,auth_members.name as user_name,auth_members.phone as user_phone,auth_members.mail as user_mail,`status`,servers.`user` as ftpuser,servers.`server_name` as server_name,servers.`password` as ftppassword,`slots`,`day`,`namesurname`,`country1`,`country2`,`countryorder`,`ordername`,`ordercount`,`fullordercount`,`sellordercount`,`orderprice1`,`orderprice2`,`timestorage`,`sellstorage`,`orderstatus`,`orderlink`,`orderphone`,`email`,`skype`,`viber`,`whatsapp`,`telegram`,`otherphone`,`comments`,`descriptions`,`payout`,`leftpayout`,`tid`,`param`,`orderback`,`invoice_id`,tarif.`name` as tarif_name,tarif.`startmap` as tarif_startmap,tarif.game_prefix,tarif.art_prefix as art_prefix,`port`,`user_id`,servers.`id` from servers LEFT JOIN tarif ON servers.tarif=tarif.id LEFT JOIN auth_members ON servers.user_id=auth_members.id LEFT JOIN dedicated ON servers.dedic_id=dedicated.id LEFT JOIN dedicated_ip ON servers.ip_id=dedicated_ip.id WHERE auth_members.phone LIKE %search% ORDER BY servers.id
Вот будет у Вас фильтрация по телефону юзера. Если в телефоне есть search - выдаст это.
-
Current freelance projects in the category Databases & SQL
A Senior Flutter + Backend developer is required to create an MVP for a startup (similar to Uber for household services).
223 USD
Looking for an experienced developer (or a small team) to create an MVP mobile application — a service for urgent calls to specialists similar to Uber, Uklon. Development needed: • mobile application for iOS and Android (Flutter); • server part (REST API); • admin panel; •… Databases & SQL, Hybrid Mobile Apps ∙ 2 hours 38 minutes back ∙ 16 proposals |
Database parsing
45 USD
Channel requirements: 1. Content language: Russian or Ukrainian (mixed RU/UA content is allowed) 2. Number of subscribers: At least 500 subscribers 3. Activity: The last post published no later than 32 hours ago 4. Comments: Comments must be open under the posts (through a group… Databases & SQL, Data Parsing ∙ 1 day 8 hours back ∙ 30 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 4 days 11 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 4 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 5 days 22 hours back ∙ 93 proposals |
Laramie