| 0.0005 | SELECT dvd.dv_id, dvd.v_id, dvd.title, dvd.year, dvd.features, dvd.flags, dvd.length, dvd.studio, dvd.dvddiscs, dvd.chapters, dvd.menu, dvd.sound, dvd.screen, dvd.oar, dvd.mpaa, dvd.dar, dvd.region, dvd.dvdsides, dvd.language, dvd.subtitles, dvd.rating, dvd.reldate, dvd.r_feature, dvd.cat as category, dvd_rev.author as description_author, dvd_rev.text as description
FROM (`dvd`)
LEFT JOIN `dvd_rev` ON dvd_rev.dv_id = dvd.dv_id
WHERE dvd.dv_id = 'E184072'
LIMIT 1 |
| 0.0012 | SELECT video.data, dvd.dv_id as has_dvd, trailers.vppid as trailer_id, product.amg_id as buy
FROM (`video`)
LEFT JOIN `dvd` ON dvd.v_id = video.v_id
LEFT JOIN `trailers` ON trailers.v_id = video.v_id
LEFT JOIN `product` ON product.amg_id = video.v_id
WHERE video.v_id = 'V 349487'
LIMIT 1 |
| 0.0002 | SELECT fname FROM dvd_covers WHERE dv_id = 'E184072' LIMIT 1 |
| 0.0003 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Eng'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Fre'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Spa'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Eng'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Fre'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'Spa'
LIMIT 1 |
| 0.0002 | SELECT dvd_abbr.replace
FROM (`dvd_abbr`)
WHERE `text` = 'WSE'
LIMIT 1 |
| 0.0003 | SELECT `v_id`, `v_title`, `year`
FROM (`expand_dvd`)
WHERE `dv_id` = 'E184072' AND v_id LIKE 'V%' |
| 0.0008 | SELECT `p_id`, `text`, `name`, rand() as rnd
FROM (`tag`)
WHERE tag.index = 'BIRTH+12 02'
ORDER BY `rnd` ASC
LIMIT 4 |
Send to Friend![Things We Lost in the Fire [WS]](http://image.allmusic.com/00/adg/cov200/dru500/u525/u52560v02my.jpg)
About Us | Contact | Employment | Product Submissions | Advertising | Privacy Policy | Terms of Service | Copyright Policy