500 - JDatabaseMySQL::query: 1052 - Column 'block' in on clause is ambiguous SQL=SELECT subsel2.id, subsel2.title, subsel2.begin, subsel2.created, subsel2.modified, subsel2.travel, subsel2.removal, subsel2.verified, subsel2.experience, subsel2.salaryid, subsel2.salarywish, subsel2.userid, subsel2.block, subsel2.activation, subsel2.providername, subsel2.entrytype, subsel2.image, subsel2.status, GROUP_CONCAT(CONCAT('{"skillid":', ut.id, ',"skilltitle":"', ut.title, '","experienceid":', e.id, ',"experiencetitle":"', e.title, '"}') ORDER BY e.id DESC) AS skills, COUNT(e.id) AS numskills FROM ( SELECT subsel.id, subsel.title, subsel.begin, subsel.created, subsel.modified, subsel.travel, subsel.removal, subsel.verified, subsel.experience, subsel.salaryid, subsel.salarywish, subsel.userid, subsel.block, subsel.activation, subsel.providername, subsel.entrytype, (SELECT u.filename FROM itp_newel_uploads u WHERE u.itp_newel_candidates_id = subsel.id AND u.type = 3 ORDER BY ID DESC LIMIT 0,1) as `image`, IF(s.session_id IS NOT NULL, 1, 0) AS status FROM ( SELECT c.id AS id, c.title AS title, c.begin AS begin, c.created AS created, c.modified AS modified, c.travel AS travel, c.removal AS removal, c.verified AS verified, c.experience AS experience, bs.id AS salaryid, bs.title AS salarywish, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.block ELSE u3.block END AS block, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.activation ELSE u3.activation END AS activation, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.id ELSE u3.id END AS userid, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN NULL ELSE p.companyname END AS providername, "candidate" AS entrytype FROM itp_newel_usedtechnologies AS ut INNER JOIN itp_newel_usedtechnologies_has_itp_newel_candidates AS uthc ON uthc.itp_newel_usedtechnologies_id = ut.id INNER JOIN itp_newel_candidates AS c ON c.id = uthc.itp_newel_candidates_id AND c.published = 1 AND c.state = 1 INNER JOIN itp_newel_projectcategories_has_itp_newel_usedtechnologies AS pchut ON pchut.itp_newel_usedtechnologies_id = uthc.itp_newel_usedtechnologies_id INNER JOIN itp_newel_projectcategories AS pc ON pc.id = pchut.itp_newel_projectcategories_id AND pc.published = 1 LEFT JOIN itp_newel_applicants AS a ON a.id = c.itp_newel_applicants_id LEFT JOIN itp_users u2 ON u2.id = a.itp_users_id LEFT JOIN itp_newel_provider p ON p.id = c.itp_newel_provider_id LEFT JOIN itp_users u3 ON u3.id = p.itp_users_id LEFT JOIN itp_newel_basesalaries AS bs ON bs.id = c.itp_newel_basesalaries_id AND bs.published = 1 WHERE ut.id = 1159 AND ut.published = 1 GROUP BY c.id, c.title, c.begin, c.created, c.modified, c.travel, c.removal, c.verified, c.experience, bs.id, bs.title, c.itp_newel_applicants_id, u2.id, u2.block, u2.activation, p.companyname, u3.id, u3.block, u3.activation ) subsel LEFT JOIN itp_session AS s ON s.userid = subsel.userid WHERE subsel.block = 0 ) subsel2 LEFT JOIN itp_newel_usedtechnologies_has_itp_newel_candidates AS uthc ON uthc.itp_newel_candidates_id = subsel2.id LEFT JOIN itp_newel_usedtechnologies AS ut ON ut.id = uthc.itp_newel_usedtechnologies_id AND ut.published = 1 LEFT JOIN itp_newel_experiences AS e ON e.id = uthc.itp_newel_experiences_id AND e.published = 1 GROUP BY subsel2.id, subsel2.title, subsel2.begin, subsel2.created, subsel2.modified, subsel2.travel, subsel2.removal, subsel2.verified, subsel2.experience, subsel2.salaryid, subsel2.salarywish, subsel2.userid, subsel2.block, subsel2.activation, subsel2.providername, subsel2.entrytype, subsel2.image, subsel2.status

Die Seite kann nicht angezeigt werden, weil:

  1. Ein veraltetes Lesezeichen
  2. Eine Suchmaschine hat einen veralteten Index der Website
  3. Eine falsche Adresse
  4. Kein Zugriff auf diese Seite!
  5. Die angefragte Quelle wurde nicht gefunden!
  6. Während der Anfrage ist ein Fehler aufgetreten!

Bitte eine der folgenden Seiten ausprobieren:

Bei Problemen ist der Administrator dieser Website zuständig..

JDatabaseMySQL::query: 1052 - Column 'block' in on clause is ambiguous SQL=SELECT subsel2.id, subsel2.title, subsel2.begin, subsel2.created, subsel2.modified, subsel2.travel, subsel2.removal, subsel2.verified, subsel2.experience, subsel2.salaryid, subsel2.salarywish, subsel2.userid, subsel2.block, subsel2.activation, subsel2.providername, subsel2.entrytype, subsel2.image, subsel2.status, GROUP_CONCAT(CONCAT('{"skillid":', ut.id, ',"skilltitle":"', ut.title, '","experienceid":', e.id, ',"experiencetitle":"', e.title, '"}') ORDER BY e.id DESC) AS skills, COUNT(e.id) AS numskills FROM ( SELECT subsel.id, subsel.title, subsel.begin, subsel.created, subsel.modified, subsel.travel, subsel.removal, subsel.verified, subsel.experience, subsel.salaryid, subsel.salarywish, subsel.userid, subsel.block, subsel.activation, subsel.providername, subsel.entrytype, (SELECT u.filename FROM itp_newel_uploads u WHERE u.itp_newel_candidates_id = subsel.id AND u.type = 3 ORDER BY ID DESC LIMIT 0,1) as `image`, IF(s.session_id IS NOT NULL, 1, 0) AS status FROM ( SELECT c.id AS id, c.title AS title, c.begin AS begin, c.created AS created, c.modified AS modified, c.travel AS travel, c.removal AS removal, c.verified AS verified, c.experience AS experience, bs.id AS salaryid, bs.title AS salarywish, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.block ELSE u3.block END AS block, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.activation ELSE u3.activation END AS activation, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN u2.id ELSE u3.id END AS userid, CASE WHEN c.itp_newel_applicants_id IS NOT NULL THEN NULL ELSE p.companyname END AS providername, "candidate" AS entrytype FROM itp_newel_usedtechnologies AS ut INNER JOIN itp_newel_usedtechnologies_has_itp_newel_candidates AS uthc ON uthc.itp_newel_usedtechnologies_id = ut.id INNER JOIN itp_newel_candidates AS c ON c.id = uthc.itp_newel_candidates_id AND c.published = 1 AND c.state = 1 INNER JOIN itp_newel_projectcategories_has_itp_newel_usedtechnologies AS pchut ON pchut.itp_newel_usedtechnologies_id = uthc.itp_newel_usedtechnologies_id INNER JOIN itp_newel_projectcategories AS pc ON pc.id = pchut.itp_newel_projectcategories_id AND pc.published = 1 LEFT JOIN itp_newel_applicants AS a ON a.id = c.itp_newel_applicants_id LEFT JOIN itp_users u2 ON u2.id = a.itp_users_id LEFT JOIN itp_newel_provider p ON p.id = c.itp_newel_provider_id LEFT JOIN itp_users u3 ON u3.id = p.itp_users_id LEFT JOIN itp_newel_basesalaries AS bs ON bs.id = c.itp_newel_basesalaries_id AND bs.published = 1 WHERE ut.id = 1159 AND ut.published = 1 GROUP BY c.id, c.title, c.begin, c.created, c.modified, c.travel, c.removal, c.verified, c.experience, bs.id, bs.title, c.itp_newel_applicants_id, u2.id, u2.block, u2.activation, p.companyname, u3.id, u3.block, u3.activation ) subsel LEFT JOIN itp_session AS s ON s.userid = subsel.userid WHERE subsel.block = 0 ) subsel2 LEFT JOIN itp_newel_usedtechnologies_has_itp_newel_candidates AS uthc ON uthc.itp_newel_candidates_id = subsel2.id LEFT JOIN itp_newel_usedtechnologies AS ut ON ut.id = uthc.itp_newel_usedtechnologies_id AND ut.published = 1 LEFT JOIN itp_newel_experiences AS e ON e.id = uthc.itp_newel_experiences_id AND e.published = 1 GROUP BY subsel2.id, subsel2.title, subsel2.begin, subsel2.created, subsel2.modified, subsel2.travel, subsel2.removal, subsel2.verified, subsel2.experience, subsel2.salaryid, subsel2.salarywish, subsel2.userid, subsel2.block, subsel2.activation, subsel2.providername, subsel2.entrytype, subsel2.image, subsel2.status

Call stack
# Function Location
1 JSite->dispatch() /usr/www/users/itpro/index.php:46
2 JComponentHelper::renderComponent() /usr/www/users/itpro/includes/application.php:197
3 JComponentHelper::executeComponent() /usr/www/users/itpro/libraries/joomla/application/component/helper.php:351
4 require_once() /usr/www/users/itpro/libraries/joomla/application/component/helper.php:383
5 JController->execute() /usr/www/users/itpro/components/com_itprojekte/itprojekte.php:16
6 ItProjekteController->display() /usr/www/users/itpro/libraries/joomla/application/component/controller.php:761
7 JController->display() /usr/www/users/itpro/components/com_itprojekte/controller.php:51
8 ItprojekteViewSearch->display() /usr/www/users/itpro/libraries/joomla/application/component/controller.php:722
9 ItprojekteModelSearch->getItems() /usr/www/users/itpro/components/com_itprojekte/views/search/view.html.php:109
10 ItprojekteModelSearch->getCandidatesBySkill() /usr/www/users/itpro/components/com_itprojekte/models/search.php:629
11 JDatabase->loadObjectList() /usr/www/users/itpro/components/com_itprojekte/models/search.php:1651
12 JDatabaseMySQL->execute() /usr/www/users/itpro/libraries/joomla/database/database.php:1100
13 JError::raiseError() /usr/www/users/itpro/libraries/joomla/database/database/mysql.php:548
14 JError::raise() /usr/www/users/itpro/libraries/joomla/error/error.php:251