Issue/1481 (Fulltext)/URI examples/direct db query
De Semantic MediaWiki - Sandbox
MariaDB [0210020150926]> SELECT DISTINCT
-> t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.smw_subobject AS so,t5.smw_sortkey AS sortkey
-> FROM
-> `02100_smw_object_ids` AS t5
-> INNER JOIN
-> `02100_smw_fpt_inst` AS t1 ON t5.smw_id=t1.s_id
-> INNER JOIN
-> `02100_smw_ft_search` AS t3 ON t1.s_id=t3.s_id
-> WHERE
-> (t1.o_id='5003' AND ((MATCH(t3.o_text) AGAINST ('ccc*' IN BOOLEAN MODE) AND t3.p_id=85))) AND t5.smw_iw!=':smw' AND t5.smw_iw!=':smw-delete' AND t5.smw_iw!=':smw-redi'
-> ORDER BY
-> t5.smw_sortkey ASC
-> LIMIT
-> 55
-> OFFSET
-> 0;
Empty set (0.00 sec)
MariaDB [0210020150926]> SELECT DISTINCT
-> t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.smw_subobject AS so,t5.smw_sortkey AS sortkey
-> FROM
-> `02100_smw_object_ids` AS t5
-> INNER JOIN
-> `02100_smw_fpt_inst` AS t1 ON t5.smw_id=t1.s_id
-> INNER JOIN
-> `02100_smw_ft_search` AS t3 ON t1.s_id=t3.s_id
-> WHERE
-> (t1.o_id='5003' AND ((MATCH(t3.o_text) AGAINST ('ccc*' IN BOOLEAN MODE) AND t3.p_id='85'))) AND t5.smw_iw!=':smw' AND t5.smw_iw!=':smw-delete' AND t5.smw_iw!=':smw-redi'
-> ORDER BY
-> t5.smw_sortkey ASC
-> LIMIT
-> 55
-> OFFSET
-> 0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '> t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.' at line 2