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_region_id = 741186 )
AND ( oc_t_item_location.fk_c_country_code = 'gb' )
AND oc_t_item.fk_i_category_id IN (391, 401, 404, 409, 410, 392, 400, 414, 411, 415, 403, 412, 398, 413, 421, 399, 417, 396, 405, 397, 395, 408, 393, 407, 394, 402, 406)
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
