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
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
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
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
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
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