SQL复制代码 xxxxxxxxxx SELECT * FROM blocks WHERE root_id LIKE '♂' AND type = 'h' ORDER BY random() LIMIT 1 SQL复制代码 xxxxxxxxxx select * from blocks markdown like '%唯物主义%' and type ='p' ORDER BY updated desc Plain Text复制代码 xxxxxxxxxx SELECT * FROM blocks WHERE (id in (select parent_id from blocks where type !='l' ) and type='i' and subtype = 't' and markdown like '%[ ]%') order by random() limit 15 Plain Text复制代码 xxxxxxxxxx SELECT * FROM blocks WHERE (id in (select parent_id from blocks where type !='l' ) and type='i' and subtype = 't' and markdown like '%[x]%') order by random() limit 15 Plain Text复制代码 xxxxxxxxxx select * from blocks where updated like '%202108%' order by created desc Plain Text复制代码 xxxxxxxxxx select * from blocks where updated > '20210801' and updated < '20211031' order by random() limit 10 Plain Text复制代码 xxxxxxxxxx select * from blocks where (created like '%202108%' or created like '%202109%' or created like '%202110%') order by random() limit 10 Plain Text复制代码 xxxxxxxxxx select * from blocks where markdown like '%海%' and type = 'p' and (created like '%202108%' or created like '%202109%' or created like '%202110%') order by random() limit 10 Plain Text复制代码 xxxxxxxxxx '%((% "%"))%' Plain Text复制代码 xxxxxxxxxx '%[%](%)%' Plain Text复制代码 xxxxxxxxxx '%**%**%' Plain Text复制代码 xxxxxxxxxx '%*%*%' Plain Text复制代码 xxxxxxxxxx '%<u>%</u>%' Plain Text复制代码 xxxxxxxxxx '%~~%~~%' Plain Text复制代码 xxxxxxxxxx '%==%==%' Plain Text复制代码 xxxxxxxxxx '%^%^%' Plain Text复制代码 xxxxxxxxxx '%~%~%' Plain Text复制代码 xxxxxxxxxx '%<kbd>%</kbd>%' Plain Text复制代码 xxxxxxxxxx %#%#% Plain Text复制代码 xxxxxxxxxx %`%`% Plain Text复制代码 xxxxxxxxxx %$%$% Plain Text复制代码 xxxxxxxxxx markdown like '%*%*%' Plain Text复制代码 xxxxxxxxxx markdown like '%*%*%' and markdown not like '%**%**%' Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"color: var(--b3-font-color13);\"}" Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"background-color: var(--b3-font-background5);\"}" Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"text-shadow: 0px 0px 0.1em, 0px 0px 0.3em;\"}" Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"-webkit-text-stroke: 0.2px var(--b3-theme-on-background); -webkit-text-fill-color: transparent;\"}" Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"background-image: linear-gradient(to right, var(--b3-theme-primary), var(--b3-theme-error)); -webkit-background-clip: text; color: transparent;\"}" Plain Text复制代码 xxxxxxxxxx "Data": "{: style=\"text-shadow: 1px 1px var(--b3-border-color), 2px 2px var(--b3-border-color), 3px 3px var(--b3-border-color), 4px 4px var(--b3-border-color);\"}" Plain Text复制代码 xxxxxxxxxx and path like '%.action{.id}%' and root_id != '.action{.id}' SQL复制代码 xxxxxxxxxx select * from blocks where id in (select block_id from attributes where name = 'custom-function' and value = '挖空') |
|