Qry nicht gefunden: 0/3Error-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] => [typselect] => [docselect] => [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] => [title_start] => [title_end] => [desc] => )
Repertoire - MGV Raeren