rendered paste bodyWarning: mysql error: Unknown column 'a.nbreads' in 'field list' in query:
select distinct s.`page`, s.`location`, s.`last_update`, s.`count`,
a.`heading`,a.`nbreads`,a.`publishDate`,a.`title` from
`tiki_searchindex` s, `tiki_articles` a where `searchword` in
(?) and
s.`location`='article' and
s.`page`=a.`articleId` order by `nbreads` desc
mysql> desc tiki_searchindex;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| searchword | varchar(80) | NO | PRI | | |
| location | varchar(80) | NO | PRI | | |
| page | varchar(255) | NO | PRI | | |
| count | int(11) | NO | | 1 | |
| last_update | int(11) | NO | MUL | 0 | |
+-------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> desc tiki_articles;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| articleId | int(8) | NO | PRI | NULL | auto_increment |
| topline | varchar(255) | YES | | NULL | |
| title | varchar(80) | YES | MUL | NULL | |
| subtitle | varchar(255) | YES | | NULL | |
| linkto | varchar(255) | YES | | NULL | |
| lang | varchar(16) | YES | | NULL | |
| state | char(1) | YES | | s | |
| authorName | varchar(60) | YES | | NULL | |
| topicId | int(14) | YES | | NULL | |
| topicName | varchar(40) | YES | | NULL | |
| size | int(12) | YES | | NULL | |
| useImage | char(1) | YES | | NULL | |
| image_name | varchar(80) | YES | | NULL | |
| image_caption | text | YES | | NULL | |
| image_type | varchar(80) | YES | | NULL | |
| image_size | int(14) | YES | | NULL | |
| image_x | int(4) | YES | | NULL | |
| image_y | int(4) | YES | | NULL | |
| image_data | longblob | YES | | NULL | |
| publishDate | int(14) | YES | | NULL | |
| expireDate | int(14) | YES | | NULL | |
| created | int(14) | YES | | NULL | |
| heading | text | YES | MUL | NULL | |
| body | text | YES | MUL | NULL | |
| hash | varchar(32) | YES | | NULL | |
| author | varchar(200) | YES | MUL | NULL | |
| reads | int(14) | YES | MUL | NULL | |
| votes | int(8) | YES | | NULL | |
| points | int(14) | YES | | NULL | |
| type | varchar(50) | YES | | NULL | |
| rating | decimal(3,2) | YES | | NULL | |
| isfloat | char(1) | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
32 rows in set (0.00 sec)