select value from hl_settings where name = 'sr' Unknown storage engine 'InnoDB'
select id, name from hl_groups order by ordering, id Unknown storage engine 'InnoDB'
select hl_listings.*, date_format(hl_listings.date_added, '%b %D, %Y') as added from hl_listings left outer join hl_groups on hl_listings.group_id = hl_groups.id where hl_groups.onnew = 1 and hl_listings.date_added + interval 10 day >= current_date and (hl_listings.expiration = 0 || date_added + interval hl_listings.expiration day >= current_date) and hl_listings.status = 1 order by date_added desc, id Unknown storage engine 'InnoDB'
select * from hl_ads where date <= now() and ((expiration = 0) || (date + interval expiration day >= now())) and approved = 1 and type in (3,4) order by rand() Unknown storage engine 'InnoDB'
select type, count(*) as cnt, (unix_timestamp(min(if(expiration = 0, 9999999999, date + interval expiration day))) - unix_timestamp(now())) as exp_time, date_format( min(if(expiration = 0, '8999-12-31', date) + interval expiration day), '%b %e, %Y') as exp_date from hl_ads where date <= now() and ((expiration = 0) || (date + interval expiration day >= now())) and approved = 1 and type in (3,4) group by type Unknown storage engine 'InnoDB'
select *, (unix_timestamp(date + interval expiration day) - unix_timestamp(now())) as exp_time, date_format(date + interval expiration day, '%b %e, %Y') as exp_date from hl_ads where date <= now() and ((expiration = 0) || (date + interval expiration day >= now())) and approved = 1 and type in (2,5,6,7) order by price desc Unknown storage engine 'InnoDB'
delete from hl_votes where confirm != '0' and date + interval 3 day < now() Unknown storage engine 'InnoDB'
SELECT v.*, date_format(v.date, '%b %D, %Y') as date, l.name, l.id as id from hl_votes as v, hl_listings as l where (v.confirm = '' or v.confirm = '0' or v.confirm = NULL) and v.listing_id = l.id and l.status = 1 order by v.date desc limit 0, 10 Unknown storage engine 'InnoDB'
SELECT l.id, l.name, l.rating, s.amount, s.batch, date_format(s.date, '%b %D, %Y') as date FROM `hl_statistics` AS s, hl_listings AS l WHERE s.listing_id > 0 AND s.type = 1 AND l.id = s.listing_id AND l.status = 1 ORDER BY s.date DESC limit 0, 10 Unknown storage engine 'InnoDB'
SELECT l.id, l.name, l.rating, s.amount, date_format(s.date, '%b %D, %Y') as date FROM `hl_statistics` AS s, hl_listings AS l WHERE s.listing_id > 0 AND s.type = 0 AND l.id = s.listing_id AND l.status = 1 ORDER BY s.date DESC limit 0, 10 Unknown storage engine 'InnoDB'
SELECT l.id, l.name, sum(s.amount * (s.type = 1)) AS paid, sum(s.amount * (s.type = 0)) AS spent, sum(s.amount * (s.type = 1))/sum(s.amount * (s.type = 0)) as ratio FROM hl_statistics AS s, hl_listings AS l WHERE l.id = s.listing_id AND l.hyip_status = 1 AND s.listing_id > 0 AND status = 1 GROUP BY l.id, l.name HAVING sum(s.amount * (s.type = 0)) > 0 ORDER BY ratio desc LIMIT 0, 10 Unknown storage engine 'InnoDB'
SELECT l.id, l.name, (to_days(now()) - to_days(l.date_added)) AS monitored FROM hl_listings as l inner join hl_groups as g on l.group_id = g.id WHERE g.type != 'Monitors' AND l.status = 1 AND l.hyip_status = 1 ORDER BY monitored desc LIMIT 0, 10 Unknown storage engine 'InnoDB'
SELECT l.id, l.name FROM hl_listings AS l WHERE status = 1 AND l.hyip_status = 4 ORDER BY date_updated desc LIMIT 0, 10 Unknown storage engine 'InnoDB'
SELECT * FROM hl_articles WHERE ln = '' ORDER BY sticky desc, date desc LIMIT 0, 6 Unknown storage engine 'InnoDB'
select *, date_format(date, '%b-%e-%Y %r') as d from hl_news where (expiration = 0 || (date + interval expiration day >= current_date)) and ln in ('', '') order by date desc limit 0, 6 Unknown storage engine 'InnoDB'
select * from hl_groups where status = 1 and nav_name != '' order by id Unknown storage engine 'InnoDB'
select count(*) as cnt from hl_listings Unknown storage engine 'InnoDB'
select count(id) as cnt from hl_groups where status = 1 and id = 3 Unknown storage engine 'InnoDB'
select listing_id from hl_ads where type = 1 and approved = 1 and date <= now() and ((expiration = 0) || (date + interval expiration day > now())) order by price desc Unknown storage engine 'InnoDB'
select * from hl_groups where onindex = 1 order by ordering, id Unknown storage engine 'InnoDB'
FairMonitor.com
  • Skype: Lexsys23
  • Google Talk: contact.fairmonitor@gmail.com
  • ICQ: 394-983-537

Вход в кабинет

Обзоры и статьи

Актуальные новости

Последние отзывы

Мы в:

Реклама

Новые проекты

Последние выплаты

ТОП рабоющих

ТОП прибыльных