string(46) "SELECT `id` FROM `section` WHERE `path`='news'"
string(39) "SELECT param FROM `section` WHERE id=11"
string(48) "SELECT param FROM `section_present` WHERE id1=11"
string(270) "SELECT a.name AS current_name, b.name AS parent_name, a.id_parent AS parent_id, a.module AS current_module, a.path AS current_path FROM section AS a LEFT JOIN section AS b ON a.id_parent=b.id LEFT JOIN meta_tags as m ON a.id = m.id_section and m.id_item=0 WHERE a.id=11"
string(47) "SELECT * FROM `meta_tags` WHERE `id_section`=11"
string(46) "SELECT * FROM `meta_tags` WHERE `id_section`=1"
string(102) "SELECT sp.id2 AS id, s.module FROM section AS s, section_present AS sp WHERE sp.id1=11 AND sp.id2=s.id"
string(44) "SELECT `module` FROM `section` WHERE `id`=11"
string(44) "SELECT `module` FROM `section` WHERE `id`=11"
string(67) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='27'"
string(67) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='60'"
string(67) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='36'"
string(1466) "SELECT subq.*, CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer, s.corporative,
(SELECT t.id FROM `seminars` AS s1 LEFT JOIN `seminars_trainers` AS str ON str.id_seminars = s1.id, `trainers` AS t
WHERE t.id = str.id_trainers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `seminars` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `seminars_date` AS sd, `seminars_type` AS st, `users` AS u
WHERE u.company<>"" AND s.active=1 AND sd.id_seminars = s.id AND sd.id =
(SELECT id FROM seminars_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_seminars = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq
LEFT JOIN `seminars_trainers` AS str2 ON str2.id_seminars = subq.id LEFT JOIN `trainers` AS t2
ON t2.id = str2.id_trainers WHERE t2.id=id_trainer ORDER BY RAND() LIMIT 1"
string(67) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='55'"
string(1444) "SELECT subq.* , CONCAT(t2.lname, " ", t2.fname) AS name_trainer, t2.foto
FROM
(SELECT s.id, c.name AS city, s.active, s.name, st.name AS `type`, sd.date_start, sd.date_end, u.company, u.id AS id_organizer,
(SELECT t.id FROM `conferences` AS s1 LEFT JOIN `conferences_speakers` AS str ON str.id_conferences = s1.id, `speakers` AS t
WHERE t.id = str.id_speakers AND s1.id = s.id AND t.active=1 ORDER BY RAND() LIMIT 1) AS id_trainer
FROM `conferences` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `conferences_date` AS sd, `conferences_type` AS st, `users` AS u
WHERE company<>"" AND s.active=1 AND sd.id_conferences = s.id AND sd.id =
(SELECT id FROM conferences_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_conferences = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY sd.date_start LIMIT 5) AS subq LEFT JOIN `conferences_speakers` AS str2 ON str2.id_conferences = subq.id LEFT JOIN `speakers` AS t2
ON t2.id = str2.id_speakers AND t2.id=id_trainer ORDER BY RAND() LIMIT 1"
string(68) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='128'"
string(775) "SELECT s.id, s.active, s.name, st.name AS `type` , sd.date_start, sd.date_end, u.company, u.id AS id_organizer
FROM `exhibitions` AS s LEFT JOIN `places` AS p ON p.id=s.id_place LEFT JOIN `geo_city` AS c ON `p`.id_city=c.id, `exhibitions_date` AS sd, `exhibitions_type` AS st, `users` AS u
WHERE company<>"" AND s.active=1 AND sd.id_exhibitions = s.id AND sd.id =
(SELECT id FROM exhibitions_date AS sd1 WHERE sd1.date_start > NOW() AND sd1.id_exhibitions = s.id ORDER BY sd1.date_start LIMIT 1)
AND s.id_type = st.id AND u.id = s.id_user AND sd.date_start > NOW( ) + INTERVAL 1 DAY
ORDER BY RAND() LIMIT 1"
string(68) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='144'"
string(57) "SELECT * FROM `counters` WHERE `active`="1" ORDER BY `id`"
string(68) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`='146'"
string(65) "SELECT `param` FROM `section_present` WHERE `id1`=11 AND `id2`=11"
string(97) "SELECT SQL_CALC_FOUND_ROWS * FROM `news` WHERE `active`="1" AND ((`role`&8)=8 OR 8=1) LIMIT 0, 10"
string(19) "SELECT FOUND_ROWS()"
string(55) "SELECT * FROM `permissions` WHERE ("8" & `role`)=`role`"
string(63) "SELECT id FROM `section` WHERE param LIKE "%seminars_category%""
string(321) "SELECT s.module,s.id, s.name, s.visible, s.static, s.sys, s.id_parent, s.path, s.alias, s.count, s.count_open, s.count_last, s.count_corporative, s.count_corporative_open, s.count_corporative_last FROM section s LEFT JOIN meta_tags m ON s.id = m.id_section and m.id_item=0
ORDER BY s.priority"
string(84) "SELECT id, name, path FROM `section` WHERE `param` LIKE "%menu%" ORDER BY `priority`"
Семинары, тренинги и конференции в Москве, России: личностный рост, повышение продаж, обучение персонала, ведение переговоров.
AllEvents.ru