Here is the scenario….
I need to add in….
AND user_actions.action_id != 15
AND user_actions.action_id != 24
But when I do that it removes my welcome message / or my welcome back message and I need that to only occur for when friend.id != {$uid}
SELECT
users.id,
users.firstname,
users.lastname,
users.username,
‘’ AS companyid,
‘’ AS industry,
‘’ AS stage,
‘’ AS companytag,
friends.gender,
users.accounttype,
users.country,
users.state,
users.city,
UNIX_TIMESTAMP(user_actions.time) AS approve_date,
friends.id AS FeedId,
friends.firstname AS FeedFirstName,
friends.lastname AS FeedLastName,
friends.username AS FeedUserName,
GROUP_CONCAT(actions.actionsdescription SEPARATOR ‘~’) AS action_id,
GROUP_CONCAT(user_actions.details SEPARATOR ‘~’) AS details
FROM users
INNER JOIN partners ON partners.user_id = users.id AND partners.approved = 1
INNER JOIN users friends ON partners.friend_id = friends.id
INNER JOIN user_actions ON user_actions.user_id = friends.id
INNER JOIN actions ON user_actions.action_id = actions.id
WHERE users.id = ${uid}
AND user_actions.time < ‘${time}’
GROUP BY
users.id,
users.firstname,
users.lastname,
users.username,
companyid,
industry,
stage,
companytag,
friends.gender,
users.accounttype,
users.country,
users.state,
users.city,
approve_date,
FeedId,
FeedFirstName,
FeedLastName,
FeedUserName