| $q |
| SELECT |
tx_sgglossary_entries.uid,tx_sgglossary_entries.word,tx_sgglossary_entries.description,tx_sgglossary_entries.hidden,tx_sgglossary_entries.crfeuser_id
|
| FROM |
tx_sgglossary_entries
|
| UIDonly |
tx_sgglossary_entries.uid,tx_sgglossary_entries.word,tx_sgglossary_entries.description,tx_sgglossary_entries.hidden,tx_sgglossary_entries.crfeuser_id
|
| WHERE |
word REGEXP '^[xxx-val-xxx]' AND tx_sgglossary_entries.deleted=0 AND tx_sgglossary_entries.pid IN (171) AND tx_sgglossary_entries.hidden=0
|
| GROUP |
tx_sgglossary_entries.uid
|
| ORDER |
word
|
| LIMIT |
|
| q[] |
| abc |
word REGEXP '^[xxx-val-xxx]'
|
| enc_delete |
tx_sgglossary_entries.deleted=0
|
| enc_pidlist |
tx_sgglossary_entries.pid IN (171)
|
| enc_hidden_3 |
tx_sgglossary_entries.hidden=0
|
|
| pg |
0
|
| maxPP |
30
|
| doTotalList |
|
| doGetMaxList |
10000
|
| FULL_QUERY |
SELECT tx_sgglossary_entries.uid,tx_sgglossary_entries.word,tx_sgglossary_entries.description,tx_sgglossary_entries.hidden,tx_sgglossary_entries.crfeuser_id
FROM tx_sgglossary_entries
WHERE
word REGEXP '^[xxx-val-xxx]' AND tx_sgglossary_entries.deleted=0 AND tx_sgglossary_entries.pid IN (171) AND tx_sgglossary_entries.hidden=0
GROUP BY tx_sgglossary_entries.uid
|
|