select value from hl_settings where name = 'sr' Table 'perhost_mafia.hl_settings' doesn't exist
select id, name from hl_groups order by ordering, id Unknown column 'ordering' in 'order clause'
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 column 'approved' in 'where clause'
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 column 'type' in 'field list'
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 (5,6) order by price desc Unknown column 'approved' in 'where clause'
select l.*, l.id as id, date_format(l.date_added, '%b %D, %Y') as added, date_format(l.date_closed, '%b %D, %Y') as closed, (to_days(now()) - to_days(l.date_online)) as lifetime, (to_days(now()) - to_days(l.date_added)) as monitored, (l.date_added + interval 5 day > current_date) as new, a.*, a.expiration as expiration, date_format(a.date + interval a.expiration day, '%b %e, %Y') as exp_date from hl_ads as a left outer join hl_listings as l on a.listing_id = l.id where a.type = 1 and a.approved = 1 and a.date < now() and ((a.expiration = 0) || (a.date + interval a.expiration day > now())) order by a.price desc Unknown column 'l.date_online' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 54 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 54 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 265 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 265 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 265 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 265 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 54 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 54 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 320 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 320 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 312 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 312 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 320 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 320 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 265 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 265 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 265 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 265 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
select count(id) as cvotes, sum(user_id > 0) as ucvotes, vote from hl_votes where listing_id = 54 and confirm = '0' group by vote Unknown column 'user_id' in 'field list'
select sum(`intraf`) as tin, sum(`outtraf`) as tout from hl_traffic where listing_id = 54 and date + interval 7 day > now() Unknown column 'intraf' in 'field list'
SELECT max(r.fst_rcb) as fst_rcb, r.fst_bonus, l.id, l.name FROM hl_refback AS r INNER JOIN hl_listings AS l on r.listing_id = l.id WHERE l.status = 1 AND l.hyip_status < 3 GROUP BY l.id ORDER BY max(r.fst_rcb) desc, l.id LIMIT 0, 5 Table 'perhost_mafia.hl_refback' doesn't exist
SELECT u.username, sum(r.inv_amount) as inv_amount FROM hl_refback_requests AS r INNER JOIN hl_users AS u on r.user_id = u.id WHERE r.user_id > 0 AND r.status = 1 AND u.status = 1 AND r.date_added >= date_format(now(), '%Y-%m-1') GROUP BY r.user_id ORDER BY sum(r.inv_amount) desc, u.id LIMIT 0, 5 Table 'perhost_mafia.hl_refback_requests' doesn't exist
SELECT s.hits, s.hosts, l.id, l.name FROM hl_hitstats AS s INNER JOIN hl_listings AS l ON s.listing_id = l.id INNER JOIN hl_groups AS g ON l.group_id = g.id WHERE g.type != 'Monitors' AND l.status = 1 AND l.hyip_status < 3 AND s.date = current_date() - interval 1 day ORDER BY s.hosts desc LIMIT 0, 5 Table 'perhost_mafia.hl_hitstats' doesn't exist
SELECT * FROM hl_articles WHERE ln = '' ORDER BY traffic desc, date desc LIMIT 0, 5 Table 'perhost_mafia.hl_articles' doesn't exist
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, 5 Unknown column 'ln' in 'where clause'
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 column 'listing_id' in 'field list'
select * from hl_groups where onindex = 1 order by ordering, id Unknown column 'ordering' in 'order clause'
mafiainvest.com