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 = 36255 )
AND ( oc_t_item_location.fk_i_region_id = 742134 )
AND ( oc_t_item_location.fk_c_country_code = 'gb' )
AND oc_t_item.fk_i_category_id IN (575, 577, 578, 588, 590, 580, 583, 582, 585, 452, 587, 576, 581, 579, 584, 677, 589, 586, 480)
GROUP BY oc_t_item.pk_i_id
ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND()
LIMIT 0, 8
Want better results? Check out this tips:
- Use more general keywords.
- Check your spelling.
- Use less specific filters.
Reset filters.
There are no ads in this category yet. Post an ad
