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 = 282328 )
AND ( oc_t_item_location.fk_i_region_id = 740467 )
AND ( oc_t_item_location.fk_c_country_code = 'gb' )
AND oc_t_item.fk_i_category_id IN (520)
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