Deekshith
8 months ago

Laravel query

Posted 8 months ago by Deekshith

Hi everyone, I have two tables namely, user and user_membership

users table has the following columns:

id,name,email,mobile

the user_membrship table has the following columns:

id,user_id,started_date,ended_date

Now, users renew their membership every year. for example,

user table:

id name email mobile 1 Deekshith [email protected] 8908908908

and user_membership table have following entries,

user_membrship table:

id users_id started_date ended_date 1 1 2017-01-01 2017-12-31 1 1 2018-01-01 2018-12-31

now I want to expire all users which membership "ended_date" is lesser than the current date,

In above example user "deekshith" ended_date is expired so I want to get all expired users like the above user in table format. I have tried but I am getting only 2017-12-31 ended_date data instead of 2018-12-31 in the user_membership table.

My code is (Raw query),

SELECT users_membership.started_at,users_membership.ended_at,users.id,users.name FROM users_membership join users on users_membership.users_id = users.id where users_membership.ended_at< '2019-01-25';

But it is displaying an only first entry of the user_membership table for a single user, but I want only last latest entry of the user_membership table for a particular user.

Please help me out.

Please sign in or create an account to participate in this conversation.