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 day5 USD
1036 44 0 1 day5 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
2643 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
Emails about orders and requests from the website are not coming.
16 USD
Diagnosis and resolution of the issue with email notifications on the OpenCart site is required. Currently, notifications are not being received via email for the following events: new orders; callback requests; comments left by users; questions and answers about products; other… C & C++, Databases & SQL ∙ 7 hours 15 minutes back ∙ 15 proposals |
Resolve the loading issue on the PrestaShop website hosting
The website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable… PHP, Databases & SQL ∙ 11 hours 14 minutes back ∙ 20 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 12 hours 44 minutes back ∙ 18 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 14 hours 42 minutes back ∙ 33 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 15 hours 47 minutes back ∙ 8 proposals |
Laramie