| 0.0002 |
SELECT *
FROM (`oyo_translations`)
|
| 0.0002 |
SELECT *
FROM (`oyo_config`)
|
| 0.0025 |
SELECT oyo_sources.*, oyo_categories.name AS categoryname
FROM (oyo_sources)
LEFT JOIN oyo_categories ON oyo_categories.id = oyo_sources.category
WHERE `oyo_sources`.`active` = 'yes'
ORDER BY `name` ASC
|
| 0.0003 |
SELECT *
FROM (oyo_categories)
WHERE `pid` = 0
AND `active` = 'yes'
ORDER BY ordering
|
| 0.0009 |
SELECT oyo_posts.enclosures, oyo_posts.images, oyo_posts.id, oyo_posts.source, oyo_posts.date, oyo_posts.title, oyo_posts.slug_url, oyo_posts.permalink, oyo_t2.name AS sourcename, oyo_t2.website AS sourceswebsite, oyo_t2.category AS sourcecategory, oyo_t2.slug_url AS sourceslug
FROM (oyo_posts)
LEFT JOIN oyo_sources oyo_t2 ON oyo_t2.id = oyo_posts.source
WHERE `oyo_posts`.`date` < '2012-05-26 18:45:00'
AND enclosures LIKE '%.jpg%'
OR images LIKE '%.jpg%'
ORDER BY date DESC
LIMIT 30
|
| 0.0003 |
SELECT oyo_sources.*, oyo_categories.name AS categoryname
FROM (oyo_sources)
LEFT JOIN oyo_categories ON oyo_categories.id = oyo_sources.category
WHERE `slug_url` = 'http:'
AND `oyo_sources`.`active` = 'yes'
LIMIT 1
|
| 0.0003 |
SELECT oyo_posts.description, oyo_posts.enclosures, oyo_posts.enclosures, oyo_posts.images, oyo_posts.id, oyo_posts.source, oyo_posts.date, oyo_posts.title, oyo_posts.slug_url, oyo_posts.permalink, oyo_t2.name AS sourcename, oyo_t2.website AS sourceswebsite, oyo_t2.category AS sourcecategory, oyo_t2.slug_url AS sourceslug
FROM (oyo_posts)
LEFT JOIN oyo_sources oyo_t2 ON oyo_t2.id = oyo_posts.source
WHERE `source` IS NULL
AND `oyo_posts`.`date` < '2012-05-26 18:45:00'
ORDER BY date desc
LIMIT 20
|
| 0.0001 |
SELECT COUNT(*) AS numrows
FROM (oyo_posts)
LEFT JOIN oyo_sources oyo_t2 ON oyo_t2.id = oyo_posts.source
WHERE `source` IS NULL
AND `oyo_posts`.`active` = 'yes'
|