Feature records in one table using accounts table

Okay, is this in the front end or inside the CMS?

in the user accounts table i have created a checkbox inside the cms called featured listings.

I have a table created called Equipment where different users have author access to enter different records they want to display on the site.

On the home page of the website we are showing around 15 random records from the equipment table.

what i wanted to be able to do is inside the cms, user accounts table was check the box i created call featured listings and on the home page of the website, only show listings authored by users who have the checkbox checked.

Right now i can show 15 random of all the listings in the equipment table, but would like to know how to limit it to only the users who are checked  featured.

so i guess this is in the front end and inside the cms....

Okay good, this is likely more simple than it seems. Can you copy the getRecords call for the 15 random records here please?

Okay, please look at these changes:

load($users, $usersMeta) = getRecords(array(
'tableName' => 'users',
'where' => 'featured = 1',
'allowSearch' => false,
'loadUploads' => false
));
$featuredIds = array_pluck($users, 'num');

// load records from 'equipment'
list($equipmentRecords, $equipmentMetaData) = getRecords(array(
'tableName' => 'equipment',
'limit' => '15',
'where' => 'user IN ('.mysql_escape(implode(',',$featuredIds)).')',
'orderBy' => 'RAND()',
'loadUploads' => true,
'allowSearch' => false,
));


Please make sure you change the table name in the first getRecords to the name of the relevant user table, and change the variable name in the where parameter in the second getRecords to whatever it should be for the user num.