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 = 34816 )
AND oc_t_item.fk_i_category_id IN (339, 679, 347, 352, 570, 678, 349, 343, 346, 344, 348, 350, 341, 353, 345, 597, 351, 662, 340, 658)
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
