SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
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.fk_i_category_id IN (626)
AND oc_t_item.pk_i_id IN (SELECT distinct d.fk_i_item_id
FROM (oc_t_item_description as d, oc_t_item as ti)
WHERE ti.pk_i_id = d.fk_i_item_id
AND MATCH(d.s_title, d.s_description) AGAINST('Raymond Weil Collection Parsifal Stainless Steel Automatic Mens Watch 2841' IN BOOLEAN MODE)
AND ti.b_premium = 1
AND ( d.fk_c_locale_code LIKE '%' ))
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
