1. Home
  2. All Categories
    3. Back to Results

APPLY FILTERS:

SELECT p.*,u.group_id,g.top_search_result FROM `ad_product` as p INNER JOIN `ad_user` as u ON u.id = p.user_id INNER JOIN `ad_usergroups` as g ON g.group_id = u.group_id where p.status = 'active' AND p.hide = '0' AND (p.product_name LIKE '%@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' or p.tag LIKE '%@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%') AND (p.country = 'US') AND p.id NOT IN (SELECT DISTINCT p.id FROM `ad_product` AS p WHERE p.status = 'active' AND p.hide = '0' AND p.promoted = 1 AND FROM_UNIXTIME(p.promoted_date) >= CURRENT_DATE ) ORDER BY (CASE WHEN g.top_search_result = 'yes' and p.featured = '1' and p.urgent = '1' and p.highlight = '1' THEN 1 WHEN g.top_search_result = 'yes' and p.urgent = '1' and p.featured = '1' THEN 2 WHEN g.top_search_result = 'yes' and p.urgent = '1' and p.highlight = '1' THEN 3 WHEN g.top_search_result = 'yes' and p.featured = '1' and p.highlight = '1' THEN 4 WHEN g.top_search_result = 'yes' and p.urgent = '1' THEN 5 WHEN g.top_search_result = 'yes' and p.featured = '1' THEN 6 WHEN g.top_search_result = 'yes' and p.highlight = '1' THEN 7 WHEN g.top_search_result = 'yes' THEN 8 WHEN p.featured = '1' and p.urgent = '1' and p.highlight = '1' THEN 9 WHEN p.urgent = '1' and p.featured = '1' THEN 10 WHEN p.urgent = '1' and p.highlight = '1' THEN 11 WHEN p.featured = '1' and p.highlight = '1' THEN 12 WHEN p.urgent = '1' THEN 13 WHEN p.featured = '1' THEN 14 WHEN p.highlight = '1' THEN 15 ELSE 16 END),(CASE WHEN p.product_name = '@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher' THEN 1 WHEN p.product_name LIKE '@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' THEN 2 WHEN p.product_name LIKE '%@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' THEN 3 WHEN p.tag = '@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher' THEN 4 WHEN p.tag LIKE '@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' THEN 5 WHEN p.tag LIKE '%@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' THEN 6 ELSE 7 END), id ASC LIMIT 0,20
SELECT DISTINCT p.* FROM `ad_product` AS p WHERE p.status = 'active' AND p.product_name LIKE '%@language @english @hindi @arabic @turkish @russian @korean @japanese @chinese @french @armenian @spanish @italian @hebrew @german @greek @math @chess @armenia @Onlinecleasses @Onlinetutoring @ArmenianTeacher @teacher%' AND p.hide = '0' AND p.promoted = 1 AND FROM_UNIXTIME(p.promoted_date) >= CURRENT_DATE ORDER BY p.id DESC LIMIT 5