9.74 ms (7.80%)
|
26 |
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13 FROM dvds d0_ WHERE d0_.iddvd = ?
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13 FROM dvds d0_ WHERE d0_.iddvd = '251';
|
9.13 ms (7.31%)
|
26 |
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13, d0_.idextranetuser AS idextranetuser_14, d0_.iddvdzone AS iddvdzone_15, d0_.iddvdformat AS iddvdformat_16, d0_.iddvdtechno AS iddvdtechno_17 FROM dvds d0_ WHERE d0_.iddvd = ?
SELECT d0_.iddvd AS iddvd_0, d0_.title AS title_1, d0_.date_shooting AS date_shooting_2, d0_.place_shooting AS place_shooting_3, d0_.price AS price_4, d0_.comments AS comments_5, d0_.time_movie AS time_movie_6, d0_.url_vente AS url_vente_7, d0_.url_vente_bis AS url_vente_bis_8, d0_.import_copat AS import_copat_9, d0_.url_clean AS url_clean_10, d0_.dateupdate AS dateupdate_11, d0_.dateinsert AS dateinsert_12, d0_.publish AS publish_13, d0_.idextranetuser AS idextranetuser_14, d0_.iddvdzone AS iddvdzone_15, d0_.iddvdformat AS iddvdformat_16, d0_.iddvdtechno AS iddvdtechno_17 FROM dvds d0_ WHERE d0_.iddvd = '251';
|
6.71 ms (5.37%)
|
1 |
SELECT DISTINCT(UPPER(LEFT(p.`lastname`, 1))) as letter
FROM dvd_person dp, persons p, dvds d
WHERE dp.`idperson`=p.`idperson` AND d.`iddvd`=dp.`iddvd`
AND d.`publish`=1
GROUP BY p.`lastname`
ORDER BY letter
SELECT DISTINCT(UPPER(LEFT(p.`lastname`, 1))) as letter
FROM dvd_person dp, persons p, dvds d
WHERE dp.`idperson`=p.`idperson` AND d.`iddvd`=dp.`iddvd`
AND d.`publish`=1
GROUP BY p.`lastname`
ORDER BY letter;
|
4.80 ms (3.84%)
|
1 |
SELECT DISTINCT(p.`idperson`),p.`lastname`,p.`firstname`,p.`url_clean`
FROM dvd_person dp, persons p, dvds d
WHERE dp.`idperson`=p.`idperson` AND d.`iddvd`=dp.`iddvd`
AND d.`publish`=1
AND p.`lastname` REGEXP '^T'
ORDER BY p.`lastname`
SELECT DISTINCT(p.`idperson`),p.`lastname`,p.`firstname`,p.`url_clean`
FROM dvd_person dp, persons p, dvds d
WHERE dp.`idperson`=p.`idperson` AND d.`iddvd`=dp.`iddvd`
AND d.`publish`=1
AND p.`lastname` REGEXP '^T'
ORDER BY p.`lastname`;
|
4.08 ms (3.27%)
|
2 |
SELECT DISTINCT(dvds.iddvd), dvds.*
FROM `dvd_person` ,
`dvds`
WHERE 1 AND dvds.`publish`=1 AND dvd_person.`idperson` IN (4786,15013,29618,16735,5804,21163,4308,48825,14928,6513,59247,21411,21551,8550,3356,1076,15716,21166,3240,993,256,21162,21144,21508,18966,7645) AND dvds.`iddvd`=dvd_person.`iddvd`
GROUP BY dvds.iddvd
ORDER BY dvds.dateinsert
DESC
LIMIT 0,2000
SELECT DISTINCT(dvds.iddvd), dvds.*
FROM `dvd_person` ,
`dvds`
WHERE 1 AND dvds.`publish`=1 AND dvd_person.`idperson` IN (4786,15013,29618,16735,5804,21163,4308,48825,14928,6513,59247,21411,21551,8550,3356,1076,15716,21166,3240,993,256,21162,21144,21508,18966,7645) AND dvds.`iddvd`=dvd_person.`iddvd`
GROUP BY dvds.iddvd
ORDER BY dvds.dateinsert
DESC
LIMIT 0,2000;
|
1.32 ms (1.06%)
|
25 |
SELECT * FROM dvdzones WHERE iddvdzone=1
SELECT * FROM dvdzones WHERE iddvdzone=1;
|
1.22 ms (0.98%)
|
1 |
SELECT COUNT(DISTINCT(iddvd)) as total
FROM dvds
WHERE publish=1
SELECT COUNT(DISTINCT(iddvd)) as total
FROM dvds
WHERE publish=1;
|
1.07 ms (0.85%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=26;
|
0.98 ms (0.79%)
|
26 |
SELECT * FROM dvdformats WHERE iddvdformat=1
SELECT * FROM dvdformats WHERE iddvdformat=1;
|
0.97 ms (0.78%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=229
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=229;
|
0.93 ms (0.74%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=21;
|
0.78 ms (0.63%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=17;
|
0.78 ms (0.62%)
|
1 |
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10
SELECT * FROM bannieres
WHERE publish=1
AND valid=1
AND is_bottom=1
AND date_start<=NOW()
AND date_end>=NOW()
ORDER BY bannieres.order ASC
LIMIT 0,10;
|
0.73 ms (0.59%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=5;
|
0.70 ms (0.56%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=26;
|
0.69 ms (0.55%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=26;
|
0.68 ms (0.55%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=27;
|
0.68 ms (0.54%)
|
10 |
SELECT * FROM dvdtechnos WHERE iddvdtechno=1
SELECT * FROM dvdtechnos WHERE iddvdtechno=1;
|
0.67 ms (0.54%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=17;
|
0.66 ms (0.53%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=1;
|
0.65 ms (0.52%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=1;
|
0.65 ms (0.52%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=27;
|
0.64 ms (0.51%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=21;
|
0.63 ms (0.50%)
|
16 |
SELECT * FROM dvdtechnos WHERE iddvdtechno=2
SELECT * FROM dvdtechnos WHERE iddvdtechno=2;
|
0.62 ms (0.50%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=17;
|
0.62 ms (0.50%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=945
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=945;
|
0.62 ms (0.49%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=26;
|
0.61 ms (0.49%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=27;
|
0.60 ms (0.48%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=21;
|
0.60 ms (0.48%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=232
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=232;
|
0.60 ms (0.48%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=17;
|
0.59 ms (0.47%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=229 AND j2.idrole=25;
|
0.59 ms (0.47%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=28;
|
0.57 ms (0.46%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=21;
|
0.57 ms (0.46%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=229
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=229;
|
0.57 ms (0.46%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=1;
|
0.57 ms (0.46%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=112 AND j2.idrole=27;
|
0.57 ms (0.45%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=195
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=195;
|
0.56 ms (0.45%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=194
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=194;
|
0.54 ms (0.43%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=5;
|
0.53 ms (0.42%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=25;
|
0.52 ms (0.41%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=25;
|
0.51 ms (0.41%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=112 AND j2.idrole=21;
|
0.51 ms (0.41%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=112
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=112;
|
0.50 ms (0.40%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=17;
|
0.50 ms (0.40%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5119
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5119;
|
0.48 ms (0.38%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=229 AND j2.idrole=28;
|
0.47 ms (0.38%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=1;
|
0.47 ms (0.37%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=112
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=112;
|
0.46 ms (0.37%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=195
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=195;
|
0.46 ms (0.37%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=244
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=244;
|
0.45 ms (0.36%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=195 AND j2.idrole=28;
|
0.45 ms (0.36%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=26;
|
0.44 ms (0.35%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4485
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4485;
|
0.44 ms (0.35%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=5;
|
0.44 ms (0.35%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=26;
|
0.43 ms (0.35%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=26;
|
0.43 ms (0.34%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=31
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=31;
|
0.39 ms (0.31%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=21;
|
0.39 ms (0.31%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=233
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=233;
|
0.38 ms (0.30%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=194 AND j2.idrole=25;
|
0.38 ms (0.30%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=5;
|
0.37 ms (0.30%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=27;
|
0.37 ms (0.30%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=1960
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=1960;
|
0.36 ms (0.29%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=21;
|
0.36 ms (0.29%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5328
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5328;
|
0.35 ms (0.28%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=27;
|
0.35 ms (0.28%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=27;
|
0.34 ms (0.27%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=28;
|
0.34 ms (0.27%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=25;
|
0.34 ms (0.27%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=25;
|
0.34 ms (0.27%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=27;
|
0.33 ms (0.27%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=5;
|
0.33 ms (0.27%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=5;
|
0.33 ms (0.26%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=190
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=190;
|
0.33 ms (0.26%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=27;
|
0.33 ms (0.26%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=5;
|
0.33 ms (0.26%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=5;
|
0.33 ms (0.26%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=26;
|
0.32 ms (0.26%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=26;
|
0.32 ms (0.26%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=5;
|
0.32 ms (0.25%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=247
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=247;
|
0.31 ms (0.25%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=232 AND j2.idrole=28;
|
0.31 ms (0.25%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=1;
|
0.31 ms (0.25%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=5;
|
0.31 ms (0.25%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=25;
|
0.31 ms (0.25%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=17;
|
0.30 ms (0.24%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=1;
|
0.30 ms (0.24%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=1438
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=1438;
|
0.30 ms (0.24%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=28;
|
0.30 ms (0.24%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=32
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=32;
|
0.30 ms (0.24%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=26;
|
0.30 ms (0.24%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=28;
|
0.29 ms (0.24%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=5;
|
0.29 ms (0.23%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=17;
|
0.29 ms (0.23%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=26;
|
0.29 ms (0.23%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=27;
|
0.29 ms (0.23%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=190
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=190;
|
0.29 ms (0.23%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=17;
|
0.29 ms (0.23%)
|
1 |
SELECT * FROM dvdzones WHERE iddvdzone=3
SELECT * FROM dvdzones WHERE iddvdzone=3;
|
0.28 ms (0.23%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=170
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=170;
|
0.28 ms (0.23%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=1;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=28;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=1;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=26;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=26;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=233
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=233;
|
0.28 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=26;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=63
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=63;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=32
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=32;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=21;
|
0.27 ms (0.22%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5454
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5454;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=17;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=5;
|
0.27 ms (0.22%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=25;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=26;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=232
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=232;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=21;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=193
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=193;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=26;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=251
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=251;
|
0.27 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=5;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=28;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=17;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=194
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=194;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=27
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=27;
|
0.26 ms (0.21%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5333
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5333;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=5;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=26;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=26;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=28;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=27;
|
0.26 ms (0.21%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=1;
|
0.26 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=28;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=25;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=17;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=32 AND j2.idrole=27;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=193 AND j2.idrole=1;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=25;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=207
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=207;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=190 AND j2.idrole=28;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=1;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=170
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=170;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=189
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=189;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=26;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=26;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=27
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=27;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=26;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=28;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=27;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=193 AND j2.idrole=27;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=163 AND j2.idrole=21;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=1;
|
0.25 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=28;
|
0.24 ms (0.20%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=21;
|
0.24 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=235 AND j2.idrole=27;
|
0.24 ms (0.20%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=194 AND j2.idrole=17;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=21;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=27;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=5;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=170 AND j2.idrole=1;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=17;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=63
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=63;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=21;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=25;
|
0.24 ms (0.19%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5562
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5562;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=220
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=220;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=219
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=219;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=146
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=146;
|
0.24 ms (0.19%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5480
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5480;
|
0.24 ms (0.19%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=17;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=21;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=163 AND j2.idrole=17;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=1;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=25;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=5;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=146 AND j2.idrole=21;
|
0.23 ms (0.19%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=17;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=25;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=102
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=102;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=193
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=193;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=25;
|
0.23 ms (0.18%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4281
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4281;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=163
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=163;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=1;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=21;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=26;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=146 AND j2.idrole=17;
|
0.23 ms (0.18%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=102
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=102;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=5;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=219
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=219;
|
0.22 ms (0.18%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5574
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5574;
|
0.22 ms (0.18%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3301
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3301;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=17;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=63 AND j2.idrole=21;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=26;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=170 AND j2.idrole=28;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=17;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=27;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=5;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=163
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=163;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=63 AND j2.idrole=28;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=25;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=232 AND j2.idrole=25;
|
0.22 ms (0.18%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=190 AND j2.idrole=25;
|
0.22 ms (0.17%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=17;
|
0.22 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=235 AND j2.idrole=5;
|
0.22 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=27 AND j2.idrole=5;
|
0.22 ms (0.17%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=251 AND j2.idrole=17;
|
0.22 ms (0.17%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5629
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5629;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=26;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=102 AND j2.idrole=1;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=146
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=146;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=21;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=1;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=25;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=220
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=220;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=21;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=102 AND j2.idrole=28;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=196
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=196;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=5;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=17;
|
0.21 ms (0.17%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=17;
|
0.21 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=27;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=17;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=21;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=251
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=251;
|
0.20 ms (0.16%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5618
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5618;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=196
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=196;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=189 AND j2.idrole=28;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=251 AND j2.idrole=1;
|
0.20 ms (0.16%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5458
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5458;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=31 AND j2.idrole=21;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=207 AND j2.idrole=28;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=235
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=235;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=28;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=5;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=1;
|
0.20 ms (0.16%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5334
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5334;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=31 AND j2.idrole=28;
|
0.20 ms (0.16%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5535
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5535;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=31
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=31;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=189
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=189;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=21;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=189 AND j2.idrole=21;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=26;
|
0.20 ms (0.16%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=28;
|
0.19 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=1;
|
0.19 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=21;
|
0.19 ms (0.16%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=1;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=28;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=1;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=220 AND j2.idrole=25;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=219 AND j2.idrole=27;
|
0.19 ms (0.15%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4542
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=4542;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=27;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=1;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=1;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=28;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=27;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=26
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=26;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=5;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=27;
|
0.19 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=5;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=196 AND j2.idrole=25;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=220 AND j2.idrole=28;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=21;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=1;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=27 AND j2.idrole=17;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=27;
|
0.18 ms (0.15%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=28
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=233 AND j2.idrole=28;
|
0.18 ms (0.14%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=17
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=196 AND j2.idrole=17;
|
0.18 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=21
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=21;
|
0.18 ms (0.14%)
|
1 |
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=13
SELECT j1.idmultimedia,j1.sujet_titre,j1.url_clean,j1.status,j1.price ,j3.iddvd FROM theatreok_dev.multimedias j1, theatreok_dev.dvd_multimedia j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idmultimedia=j2.idmultimedia
AND j3.iddvd=13;
|
0.18 ms (0.14%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=13 AND j2.idrole=27;
|
0.18 ms (0.14%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3260
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3260;
|
0.18 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=1
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=1;
|
0.17 ms (0.14%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=6456
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=6456;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=207
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=207;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=244 AND j2.idrole=5;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=32 AND j2.idrole=25;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=247
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=247;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=207 AND j2.idrole=25;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=235
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=235;
|
0.17 ms (0.14%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=5
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=247 AND j2.idrole=5;
|
0.17 ms (0.13%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=219 AND j2.idrole=25;
|
0.17 ms (0.13%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=247 AND j2.idrole=27;
|
0.17 ms (0.13%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=244
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=244;
|
0.17 ms (0.13%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=195 AND j2.idrole=25;
|
0.16 ms (0.13%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=233 AND j2.idrole=25;
|
0.16 ms (0.13%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5557
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=5557;
|
0.16 ms (0.13%)
|
1 |
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=27
SELECT j1.idcontact,j1.organisation,j1.firstname,j1.lastname,j1.url_clean ,j3.iddvd FROM theatreok_dev.contacts j1, theatreok_dev.dvd_contact j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idcontact=j2.idcontact
AND j3.iddvd=244 AND j2.idrole=27;
|
0.16 ms (0.13%)
|
1 |
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=13
SELECT j1.idspectacle,j1.title,j1.url_clean ,j3.iddvd FROM theatreok_dev.spectacles j1, theatreok_dev.dvd_spectacle j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idspectacle=j2.idspectacle
AND j3.iddvd=13;
|
0.16 ms (0.13%)
|
1 |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=25
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=13 AND j2.idrole=25;
|
0.16 ms (0.13%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=589
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=589;
|
0.15 ms (0.12%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=716
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=716;
|
0.14 ms (0.12%)
|
1 |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3706
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=3706;
|