Find Jobs
Hire Freelancers

Fixing my sql

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
Hi, I am looking for someone who can fix my mysql query below: SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], feednews.created_date, [login to view URL], [login to view URL], [login to view URL], likeTable.post_id as liked, unlikeTable.post_id as unliked, loveTable.post_id as loved, COUNT(likeTable.post_id) as likenumber. ==>When i remove this like, it shows 3 results. How to show the count for all the posts FROM feednews LEFT JOIN userDatabase ON [login to view URL] = [login to view URL] LEFT JOIN follower ON [login to view URL] = follower.user_id OR ([login to view URL] = follower.follow_id AND [login to view URL] = "2") LEFT JOIN likeTable ON [login to view URL] = likeTable.post_id LEFT JOIN loveTable ON [login to view URL] = loveTable.post_id LEFT JOIN unlikeTable ON [login to view URL] = unlikeTable.post_id WHERE [login to view URL] IN (SELECT [login to view URL] FROM contact LEFT JOIN userDatabase ON ([login to view URL] = contact.user_id AND contact.friend_id = 'e76f9714311bde29d106350c93feb32b' OR [login to view URL] = contact.friend_id AND contact.user_id = 'e76f9714311bde29d106350c93feb32b') WHERE contact.user_id = 'e76f9714311bde29d106350c93feb32b' OR contact.friend_id = 'e76f9714311bde29d106350c93feb32b') OR [login to view URL] IN (SELECT [login to view URL] FROM follower LEFT JOIN userDatabase ON ([login to view URL] = follower.user_id AND (follower.follow_id = 'e76f9714311bde29d106350c93feb32b' AND [login to view URL] = "2") OR ([login to view URL] = follower.follow_id AND [login to view URL] = "2" AND follower.user_id = 'e76f9714311bde29d106350c93feb32b'))) OR [login to view URL] = 'e76f9714311bde29d106350c93feb32b' ORDER BY feednews.created_date DESC I would like to show all the posts and number of count for like from likeTable for each post
Project ID: 27533623

About the project

9 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
hello sir, i am interested in your task. I read your description and found myself eligible to so this with my 6 years experience in development. my aim is to provide satisfied and quality work. for assurance of quality. we can discuss more in chat
$35 USD in 1 day
5.0 (4 reviews)
2.9
2.9
9 freelancers are bidding on average $25 USD for this job
User Avatar
hi am interested in your task. I read your description and found myself eligible to so this with my 6 years experience in development. my aim is to provide satisfied and quality work. for assurance of quality you can see my reviews. we can discuss more in chat
$30 USD in 2 days
5.0 (123 reviews)
5.8
5.8
User Avatar
Dear Client. I am very interested in this project. I have a lot of experience in sql. If you have any questions or concerns don't hesitate to let me know. I hope to hear from you. Best regards, Gleni
$30 USD in 1 day
5.0 (18 reviews)
5.2
5.2
User Avatar
Hello I've seen your brief and I understood your specs of fixing your bug using Login and MYSQL. As professional developer with 5+ years experience, I'm sure that I'll be able to provide you a web app that will capture client's attention instantly and will be functionally sound. Surly, special skill is friendly and quality working. I 'm looking forward to helping you grow your business by sharing my experiences. Thanks & Regard Marko
$20 USD in 1 day
5.0 (13 reviews)
5.0
5.0
User Avatar
Hi, solved. Please contact me so I can send you fixed SQL query. I can also explain how to create selects for future queries.
$26 USD in 1 day
4.4 (15 reviews)
4.3
4.3
User Avatar
Hi, Trust you are well. Will fix this query soon. My skill sets are HTML/CSS, UI/UX, Java, etc. I have hands of experience in Html, Angular, React, bootstrap etc. I have 8+years of experience in Software development. Available for immediate discussion, Let's proceed and work together. Thanks, Yogesh
$20 USD in 7 days
4.4 (10 reviews)
3.0
3.0

About the client

Flag of UNITED STATES
San Jose, United States
5.0
36
Payment method verified
Member since Sep 20, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.