Search results: Furniture Jarrow

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 = 283308 ) AND ( oc_t_item_location.fk_i_region_id = 741962 ) AND ( oc_t_item_location.fk_c_country_code = 'gb' ) AND oc_t_item.fk_i_category_id IN (422, 682, 426, 425, 430, 431, 675, 651, 424, 610, 593, 623, 429, 428, 427, 423, 594, 432, 433, 434) GROUP BY oc_t_item.pk_i_id ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND() LIMIT 0, 8