/tag/Dyno+Tuning select idx_link.*, if (isnull(premium) || expire < now() || paid != 1, 0, premium) premium, if (isnull(sponsored) || expire < now() || paid != 1, 0, sponsored) sponsored from idx_link left join idx_paid_listing on (idx_link.link_id = idx_paid_listing.link_id) left join idx_pagerank on (idx_link.link_id = idx_pagerank.link_id) where suspended = 0 and (concat(', ', keywords, ',') like '%, Dyno Tuning,%' or concat(',', keywords, ',') like '%,Dyno Tuning,%') order by sponsored desc, premium desc, bid desc10
|
|
|
|
/tag/Dyno+Tuningselect * from idx_link where suspended = 0 and hot = 1 order by hits desc, last_updated desc limit 10110
/tag/Dyno+Tuningselect idx_link.*, idx_review.* from idx_review left join idx_link on (idx_review.link_id = idx_link.link_id) WHERE status = 1 ORDER BY idx_review.date desc LIMIT 5110
