All individuals with variants in gene HERC2

Error: Query (Logged)
/individuals/HERC2 returned error in code block Individual::viewList().
Query : SELECT SQL_CALC_FOUND_ROWS i.*, i.id AS individualid, GROUP_CONCAT(DISTINCT d.id) AS diseaseids, GROUP_CONCAT(DISTINCT IF(CASE d.symbol WHEN "-" THEN "" ELSE d.symbol END = "", d.name, d.symbol) ORDER BY (d.symbol != "" AND d.symbol != "-") DESC, d.symbol, d.name SEPARATOR ", ") AS diseases_, GROUP_CONCAT(DISTINCT s2g.geneid ORDER BY s2g.geneid SEPARATOR ", ") AS genes_screened_, COUNT(DISTINCT vog.id) AS variants_, uo.name AS owned_by_, CONCAT_WS(";", uo.id, uo.name, uo.email, uo.institute, uo.department, IFNULL(uo.countryid, "")) AS _owner, ds.name AS status, GROUP_CONCAT(DISTINCT p.`Phenotype/Additional` ORDER BY p.`Phenotype/Additional` SEPARATOR ", ") AS phenotypes_ FROM lovd_v3_individuals AS i LEFT OUTER JOIN lovd_v3_individuals2diseases AS i2d ON (i.id = i2d.individualid) LEFT OUTER JOIN lovd_v3_diseases AS d ON (i2d.diseaseid = d.id) LEFT OUTER JOIN lovd_v3_screenings AS s ON (i.id = s.individualid) LEFT OUTER JOIN lovd_v3_screenings2variants AS s2v ON (s2v.screeningid = s.id) LEFT OUTER JOIN lovd_v3_variants AS vog ON (s2v.variantid = vog.id AND (vog.statusid >= 7)) LEFT OUTER JOIN lovd_v3_screenings2genes AS s2g ON (s.id = s2g.screeningid) LEFT OUTER JOIN lovd_v3_variants_on_transcripts AS vot ON (vog.id = vot.id) LEFT OUTER JOIN lovd_v3_users AS uo ON (i.owned_by = uo.id) LEFT OUTER JOIN lovd_v3_data_status AS ds ON (i.statusid = ds.id) LEFT OUTER JOIN lovd_v3_phenotypes AS p ON (i.id = p.individualid AND (p.statusid >= 7)) WHERE (i.statusid >= 7) AND (t.geneid = ?) GROUP BY i.id ORDER BY i.id ASC LIMIT 0
Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.geneid' in 'WHERE'

  Powered by LOVD v.3.0 Build 30
LOVD software ©2004-2024 Leiden University Medical Center 		There are currently no updates.