1 |
1.07 ms |
SELECT COUNT(DISTINCT(iddvd)) as total
FROM dvds
WHERE publish=1
SELECT COUNT(DISTINCT(iddvd)) as total
FROM dvds
WHERE publish=1;
|
2 |
8.92 ms |
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;
|
3 |
5.08 ms |
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 '^U'
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 '^U'
ORDER BY p.`lastname`;
|
4 |
1.07 ms |
SELECT DISTINCT(dvds.iddvd), dvds.*
FROM `dvd_person` ,
`dvds`
WHERE 1 AND dvds.`publish`=1 AND dvd_person.`idperson` IN (65063,3441) 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 (65063,3441) AND dvds.`iddvd`=dvd_person.`iddvd`
GROUP BY dvds.iddvd
ORDER BY dvds.dateinsert
DESC
LIMIT 0,2000;
|
5 |
0.04 ms |
SELECT DISTINCT(dvds.iddvd), dvds.*
FROM `dvd_person` ,
`dvds`
WHERE 1 AND dvds.`publish`=1 AND dvd_person.`idperson` IN (65063,3441) 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 (65063,3441) AND dvds.`iddvd`=dvd_person.`iddvd`
GROUP BY dvds.iddvd
ORDER BY dvds.dateinsert
DESC
LIMIT 0,2000;
|
6 |
0.29 ms |
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 = '247';
|
7 |
0.16 ms |
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 = '247';
|
8 |
0.05 ms |
SELECT * FROM dvdzones WHERE iddvdzone=1
SELECT * FROM dvdzones WHERE iddvdzone=1;
|
9 |
0.03 ms |
SELECT * FROM dvdtechnos WHERE iddvdtechno=1
SELECT * FROM dvdtechnos WHERE iddvdtechno=1;
|
10 |
0.03 ms |
SELECT * FROM dvdformats WHERE iddvdformat=1
SELECT * FROM dvdformats WHERE iddvdformat=1;
|
11 |
0.27 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.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;
|
12 |
0.27 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.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;
|
13 |
0.16 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.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;
|
14 |
0.19 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.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;
|
15 |
0.13 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.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;
|
16 |
0.20 ms |
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;
|
17 |
0.14 ms |
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;
|
18 |
0.15 ms |
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;
|
19 |
0.23 ms |
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;
|
20 |
0.17 ms |
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;
|
21 |
0.17 ms |
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 = '77';
|
22 |
0.25 ms |
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 = '77';
|
23 |
0.03 ms |
SELECT * FROM dvdzones WHERE iddvdzone=1
SELECT * FROM dvdzones WHERE iddvdzone=1;
|
24 |
0.03 ms |
SELECT * FROM dvdtechnos WHERE iddvdtechno=2
SELECT * FROM dvdtechnos WHERE iddvdtechno=2;
|
25 |
0.02 ms |
SELECT * FROM dvdformats WHERE iddvdformat=1
SELECT * FROM dvdformats WHERE iddvdformat=1;
|
26 |
0.21 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=77 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=77 AND j2.idrole=26;
|
27 |
0.16 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=77 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=77 AND j2.idrole=21;
|
28 |
0.16 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=77 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=77 AND j2.idrole=1;
|
29 |
0.13 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=77 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=77 AND j2.idrole=25;
|
30 |
0.14 ms |
SELECT j1.idperson,j1.lastname,j1.firstname,j1.url_clean,j1.valid ,j3.iddvd FROM theatreok_dev.persons j1, theatreok_dev.dvd_person j2, theatreok_dev.dvds j3
WHERE j3.iddvd=j2.iddvd
AND j1.idperson=j2.idperson
AND j3.iddvd=77 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=77 AND j2.idrole=5;
|
31 |
0.14 ms |
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=77 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=77 AND j2.idrole=27;
|
32 |
0.13 ms |
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=77
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=77;
|
33 |
0.20 ms |
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=2022
SELECT t.title FROM texts t, text_spectacle ts
WHERE t.idtext=ts.idtext AND ts.idspectacle=2022;
|
34 |
0.15 ms |
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=77
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=77;
|
35 |
0.14 ms |
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=77 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=77 AND j2.idrole=17;
|
36 |
0.13 ms |
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=77 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=77 AND j2.idrole=28;
|
37 |
0.64 ms |
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;
|