1-Qry nicht gefunden: 0/3
Error-SQL:
Column 'sel' in having clause is ambiguous
SELECT *,(Select Max(termin.Dat) from position,termin where position.Del='' and termin.Del='' and termin.ID=position.TrmID and RepID=repertoire.ID and (TIMESTAMPDIFF(MONTH,termin.Dat,curdate())<14) and ((termin.Typ='K') or (termin.Typ='P'))) as MaxDat from repertoire LEFT JOIN adressen AS komponist ON ((komponist.ID=repertoire.Komponist) AND ((repertoire.Komponist <> 0) or (repertoire.Komponist <> '')) AND (komponist.Del='')) LEFT JOIN adressen AS author ON ((author.ID=repertoire.Author) AND ((repertoire.Author <> 0) or (repertoire.Author <> '')) AND (author.Del='')) WHERE repertoire.Del="" AND Nr<>'' HAVING sel="new" ORDER BY repertoire.RecInst DESC
Array
(
[id] => 1008
[timestamp] => 2020-09-08 16:28:33
[recinst] => 2020-04-13 09:31:40
[del] =>
[recowner] => cs
[recgroup] =>
[recuser] => cs
[recserver] =>
[reclast] => 2020-09-08 16:28:33
[typ] => T
[aktiv] => on
[posid] => 0
[important] =>
[draft] => 0000-00-00 00:00:00
[ready] => 2020-04-15 11:35:56
[spell] => 2020-04-15 11:35:57
[pass] => 0000-00-00 00:00:00
[corr] =>
[hide] =>
[noprint] =>
[page] => songs
[sub] =>
[grp] =>
[container] =>
[col] =>
[topcol] => 0
[scol] => 0
[offset] =>
[rowopen] =>
[colopen] =>
[textopen] =>
[cap] => 0
[art] => 0
[artadd] =>
[par] => 0
[pos] => 10
[item] => 0
[layout] =>
[tdat] => 0000-00-00
[dat] => 0000-00-00
[condat] => 0000-00-00 00:00:00
[updat] => 0000-00-00 00:00:00
[waitdat] => 0000-00-00 00:00:00
[main] =>
[donext] =>
[dofooter] =>
[doform] =>
[fld] =>
[gblvar] =>
[submit] =>
[need] =>
[alias] =>
[doctyp] =>
[docselecttyp] =>
[docselectvar] =>
[docselect] =>
[docread] =>
[keystr] =>
[keycon] =>
[state] =>
[source] =>
[struct] => tab
[structsel] =>
[srructfld] =>
[frame] => tab
[inputtyp] =>
[bold] =>
[italic] =>
[align] =>
[margin] =>
[width] => 0
[top] => 0
[bottom] => 0
[titlecolor] =>
[titlebackground] =>
[color] =>
[background] =>
[topbackground] =>
[linebreak] => on
[class] =>
[style] =>
[htmid] =>
[name] =>
[box] =>
[download] =>
[sidebar] =>
[langsel] =>
[fixval] =>
[title_de] =>
[title_fr] =>
[title_nl] =>
[title_en] =>
[de] =>
[fr] =>
[nl] =>
[en] =>
[desc_de] =>
[desc_fr] =>
[desc_nl] =>
[desc_en] =>
[do_desc] =>
[pos_de] => 0
[pos_fr] => 0
[pos_nl] => 0
[pos_en] => 0
[tag_de] =>
[tag_fr] =>
[tag_nl] =>
[tag_en] =>
[keyw_de] =>
[keyw_fr] =>
[keyw_nl] =>
[keyw_en] =>
[accusative_de] =>
[dative_de] =>
[ref] =>
[reflang] =>
[reforg] =>
[refdoc] =>
[email] =>
[fldpos] =>
[info] =>
[title_fill] => fnc
[title_fnc] => rep_nr
[title_format] =>
[title_size] =>
[title_style] =>
[title_break] =>
[title_pos] =>
[text_fill] => var
[text_fnc] => Title
[text_format] =>
[text_size] =>
[text_break] =>
[text_pos] =>
[info_fill] => fnc
[info_fnc] => mgv_komponist
[info_format] =>
[info_size] => s
[info_pos] =>
[desc_fill] =>
[desc_fnc] =>
[desc_format] =>
[desc_style] =>
[desc_size] =>
[desc_break] =>
[desc_pos] =>
[img_fill] =>
[img_format] =>
[img_fit] =>
[img_size] =>
[img_cache] =>
[img_pos] =>
[ref_fill] => var
[ref_format] =>
[ref_doc] => song
[ref_fnc] => Nr
[wrap_fld] =>
[wrap_fnc] =>
[wrap_ref] =>
[break] =>
[view] =>
[bool] =>
[cond] =>
[unit] =>
[initfnc] =>
[showfnc] =>
[updatefnc] =>
[fill] => db
[filltyp] => tab
[fillsort] =>
[fillfnc] =>
[fillvar] =>
[param] =>
[errcon] =>
[db] => repertoire
[dbkey] =>
[dbquery] => Nr<>''
[dbsort] => $sort
[dbhaving] => $sel
[dbextfld] => (Select Max(termin.Dat) from position,termin where position.Del='' and termin.Del='' and termin.ID=position.TrmID and RepID=repertoire.ID and (TIMESTAMPDIFF(MONTH,termin.Dat,curdate())<14) and ((termin.Typ='K') or (termin.Typ='P'))) as MaxDat
[dbjoin] => LEFT JOIN adressen AS komponist ON ((komponist.ID=repertoire.Komponist) AND ((repertoire.Komponist <> 0) or (repertoire.Komponist <> '')) AND (komponist.Del=''))
LEFT JOIN adressen AS author ON ((author.ID=repertoire.Author) AND ((repertoire.Author <> 0) or (repertoire.Author <> '')) AND (author.Del=''))
[path] =>
[dir] =>
[sdir] =>
[file] =>
[fldlst] => title
[annex] =>
[annexlst] =>
[text] =>
[title] =>
[desc] =>
)