| Error: Query (Logged) |
/variants/0000009471 returned error in code block Unknown.
Query :
SELECT CONCAT(c.`hg38_id_ncbi`, ":", vog.`VariantOnGenome/DNA`) AS VOG_DNA,
CONCAT(t.geneid, "(", t.id_ncbi, "):", vot.`VariantOnTranscript/DNA`) AS VOT_DNA
FROM lovd_variants AS vog
INNER JOIN lovd_chromosomes AS c ON (vog.chromosome = c.name)
LEFT OUTER JOIN lovd_variants_on_transcripts AS vot ON (vog.id = vot.id)
LEFT OUTER JOIN lovd_transcripts AS t ON (vot.transcriptid = t.id)
LEFT OUTER JOIN lovd_variants_on_transcripts AS vot_count ON (t.id = vot_count.transcriptid)
WHERE vog.id = ? AND (? = 1 OR vog.statusid >= ?)
GROUP BY vog.id, vot.transcriptid
ORDER BY COUNT(vot_count.id) DESC, t.id ASC
Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine |
|
|
