SELECT |
tx_sgglossary_entries.*
|
FROM |
tx_sgglossary_entries
|
UIDonly |
tx_sgglossary_entries.uid
|
WHERE |
word REGEXP '^[a��]' AND tx_sgglossary_entries.deleted=0 AND tx_sgglossary_entries.pid IN (122) AND tx_sgglossary_entries.hidden=0
|
GROUP |
tx_sgglossary_entries.uid
|
ORDER |
word
|
LIMIT |
|
q[] |
abc |
word REGEXP '^[a��]'
|
enc_delete |
tx_sgglossary_entries.deleted=0
|
enc_pidlist |
tx_sgglossary_entries.pid IN (122)
|
enc_hidden_3 |
tx_sgglossary_entries.hidden=0
|
|
pg |
0
|
maxPP |
10
|
doTotalList |
|
doGetMaxList |
10000
|
FULL_QUERY |
SELECT tx_sgglossary_entries.* FROM tx_sgglossary_entries WHERE word REGEXP '^[a��]' AND tx_sgglossary_entries.deleted=0 AND tx_sgglossary_entries.pid IN (122) AND tx_sgglossary_entries.hidden=0 GROUP BY tx_sgglossary_entries.uid
|