davedave2SELECT DISTINCT (_prod_search.uid) AS Expr1, _prodserv.uid, _prod_category.cat_id, _prod_search.title, _prod_search.prod_image_url1, _prod_search.sku, _prod_search.price
FROM ((_prodserv INNER JOIN _prod_dept ON _prodserv.uid = _prod_dept.prod_uid) INNER JOIN _prod_category ON _prodserv.uid = _prod_category.prod_uid) INNER JOIN _prod_search ON _prodserv.uid = _prod_search.uid
WHERE header = 1 and (((_prod_category.cat_id) In ()) AND ((_prod_dept.dept_id)=)) group by _prod_search.uid;<div class="row"></div>