Search results: Home Decor Nottingham

SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name FROM (oc_t_item, oc_t_item_stats) LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id WHERE oc_t_item_stats.fk_i_item_id = oc_t_item.pk_i_id AND oc_t_item.b_premium = 1 AND oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND ( oc_t_item_location.fk_i_city_id = 35794 ) AND ( oc_t_item_location.fk_i_region_id = 741647 ) AND ( oc_t_item_location.fk_c_country_code = 'gb' ) AND oc_t_item.fk_i_category_id IN (613) GROUP BY oc_t_item.pk_i_id ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND() LIMIT 0, 8