Find Jobs
Hire Freelancers

Write some Software

£10-20 GBP

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 7 χρόνια πριν

£10-20 GBP

Πληρωμή κατά την παράδοση
Very simple project. I just need someone to fix or change a query which has gotten to complicated for me. You can see it below: SELECT p.`id` as id, p.`postinguser` as postinguser, p.`page` as page, p.`likedby` as likedby, p.`redwabled` as redwabled, p.`replyid` as replyid, case r.`redwabledby` when (SELECT `followed` FROM `uc_following` WHERE `userid` = '5') then r.`time` when '5' then r.`time` else p.`time` end as date_time FROM `uc_posts` p left join ( SELECT * FROM ( SELECT * FROM `uc_redwables` WHERE EXISTS (SELECT * FROM `uc_following` WHERE `userid` = '5' AND find_in_set(followed, redwabledby) > 0) OR find_in_set('5',`redwabledby`) order by `time` desc LIMIT 20 ) AS t1 GROUP BY dwable ) r on [login to view URL] = [login to view URL] WHERE p.`postinguser` = '5' OR find_in_set('5',p.`redwabled`) OR EXISTS (SELECT * FROM `uc_users` WHERE `id` = '5' AND find_in_set(postinguser, following) > 0) OR EXISTS (SELECT * FROM `uc_following` WHERE `userid` = '5' AND find_in_set(followed, redwabled) > 0) order by date_time desc LIMIT 20 It was working fine until my user '5' followed two people and then I was getting an error message that the sub query was returning more than one row. Also please note my version of MariaDB doesn't support IN. I've tried using it. Thanks!
Ταυτότητα εργασίας: 11687362

Σχετικά με την εργασία

5 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
I am experienced php developer and web designer with the depth knowledge related to MySQL,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I have worked as Php & Web developer in industry and now i am full time freelancer and having the experience of huge and live projects. I can design the web pages with the backend of php and I have also experience of query optimization and performance management through php support. I am finding one startup like you so i can provide my skills to IT market and I can give you 100% surity for quality work in minimum time sir. I have also launched eCommerce Product for pharmacy industry and launched android app on play store as well , I have great control in android with backend of php webservices and api generation with JSON integration. I can work at anytime with the great satisfactions,quality output and result in your hand with the fulfilling your requirements for sure. Waiting for your positive response , so we can start the work soon ...
£21 GBP σε 1 ημέρα
5,0 (71 αξιολογήσεις)
5,2
5,2
5 freelancers δίνουν μια μέση προσφορά £37 GBP για αυτή τη δουλειά
Avatar Χρήστη
Hi, Many thanks for spending your valuable time to review my bid. I assure you with great designs and fast turnaround. Multiple options and unlimited revisions will be provided to you. let me share the best deal what you'll be getting in this bid. As soon as possible we are in touch for project discussion. (✔ GRAPHICS: Mockup Design/ Logo Templates/ Banner Design/ Business Card/ Letter Head/ Brochure / Flyer/ Photo-editing/ Business AD making/ Corporate Identity/ Graphics/ Print Templates/ e-Publishing/ Textures/ Vectors/ Infographics/ Icons/ Presentation Templates/ Web Elements/ T-Shirts/ Wedding Invitation/ Invitation Template and may more.) Experienced resources (07 year experience). Timely communication via Freelancer. Regular reporting as per your need. Eye catchy quality work - QUICK DELIVERY. You will have complete copyrights to your logo. Revision till satisfaction level. Please Message me. Regards Neha J.
£100 GBP σε 7 ημέρες
4,8 (61 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
Hello there, I'm developer and i have experienced in development more than 5 years,and i have experienced development team as well, we are webmetek company already i have made more than 50 websites so please let me know your concern and full requirement so i can help you out and we can start your project ASAP, Regards Avijit das
£25 GBP σε 1 ημέρα
5,0 (45 αξιολογήσεις)
5,7
5,7
Avatar Χρήστη
Already fixed. write me asap and you will get working query.........................................
£18 GBP σε 1 ημέρα
5,0 (11 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
Hello sir, i have more than 4+ years of experience in PHP and MySql, you can check my portfolio, inbox me so we can discuss more about this thank you
£18 GBP σε 1 ημέρα
5,0 (1 αξιολόγηση)
1,2
1,2

Σχετικά με τον πελάτη

Σημαία της UNITED KINGDOM
Cardiff, United Kingdom
5,0
4
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Απρ 27, 2016

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.