SELECT SQL_CALC_FOUND_ROWS u.ID , place.meta_value AS place,
category.meta_value AS category,
level.meta_value AS level, u.user_login, u.user_email, u.user_nicename, u.display_name, UNIX_TIMESTAMP(u.user_registered) as joindate, mu.membership_id, mu.initial_payment, mu.billing_amount, mu.cycle_period, mu.cycle_number, mu.billing_limit, mu.trial_amount, mu.trial_limit, UNIX_TIMESTAMP(mu.startdate) as startdate, UNIX_TIMESTAMP(mu.enddate) as enddate, m.name as membership, umf.meta_value as first_name, uml.meta_value as last_name FROM wp_users u LEFT JOIN wp_usermeta umh ON umh.meta_key = 'pmpromd_hide_directory' AND u.ID = umh.user_id LEFT JOIN wp_usermeta umf ON umf.meta_key = 'first_name' AND u.ID = umf.user_id LEFT JOIN wp_usermeta uml ON uml.meta_key = 'last_name' AND u.ID = uml.user_id LEFT JOIN wp_pmpro_memberships_users mu ON u.ID = mu.user_id LEFT JOIN wp_pmpro_membership_levels m ON mu.membership_id = m.id LEFT JOIN wp_usermeta lat ON lat.meta_key = 'latitude' AND u.ID = lat.user_id LEFT JOIN wp_usermeta lng ON lng.meta_key = 'longitude' AND u.ID = lng.user_id LEFT JOIN wp_usermeta category ON category.meta_key = 'category' AND u.ID = category.user_id LEFT JOIN wp_usermeta place ON place.meta_key = 'place' AND u.ID = place.user_id LEFT JOIN wp_usermeta logo ON logo.meta_key = 'logo' AND u.ID = logo.user_id LEFT JOIN wp_usermeta pin ON pin.meta_key = 'pin' AND u.ID = pin.user_id LEFT JOIN wp_usermeta level ON level.meta_key = 'level' AND u.ID = level.user_id WHERE mu.status = 'active' AND (umh.meta_value IS NULL OR umh.meta_value <> '1') AND mu.membership_id > 0 AND category.meta_value = "5854" ORDER BY level DESC, u.display_name ASC
I loved my 16 years as a coach and leadership development consultant specialising in behavioural diagnostics and personal development. But a longstanding interest in the relationship between health and performance led me back to university for a Masters in Obesity & Weight Management and a Postgraduate Certificate in Human Nutrition.
These days there’s so much noise and confusion about what we should or shouldn’t be doing/eating/drinking. Having delved into the research (I’m still delving!), I believe that if we all focused on what is agreed on rather than what’s disputed, we’d all be healthier and happier. What does everyone agree on? Avoid sugar and ultra-processed food, eat more veg and whole foods (real food!), prioritise sleep, manage stress, move more, get outside and see friends.
These are the principles I use in my work, both with individuals and groups. I call it the low carb/real food lifestyle approach and it works because it’s working with your physiology, not fighting it.
To find out more and get in touch, visit my website: www.louwalker.com. I offer a free 30-minute session to help you explore whether health coaching might be for you.