我如何才能让Zend_Db仅从大型查询中选择一列？
|
我在SQL中有一个相当复杂的查询，该查询对两个表进行计数。查询应如下所示：
SELECT
((SELECT COUNT(DISTINCT(pages.id)) AS `count`
FROM `pages`
INNER JOIN `pageRegions` ON pageRegions.pageId = pages.id
WHERE (MATCH (pages.name, pageRegions.contents) AGAINST (\'+keyword*\' IN BOOLEAN MODE))) +
(SELECT COUNT(documents.id) AS `count`
FROM `documents`
INNER JOIN `files` ON files.id = documents.file
WHERE (MATCH (documents.name,
files.name,
files.extracted_text) AGAINST (\'+keyword*\' IN BOOLEAN MODE)))) AS count
$total_count_select = $PagesTable->getAdapter()
->query(\'((\' . $pages_total_count_select . \') +
(\' . $legal_resources_total_count_select . \')
) AS count\');
$pages_total_count_select
$legal_resources_total_count_select
Zend_Db_Select
columns()
$legal_resources_total_count_select->columns(\'COUNT(documents.id) AS count\');
SELECT ((SELECT `pages`.*,
((1.3 * (MATCH(pages.name) AGAINST (\'+keyword*\' IN BOOLEAN MODE))) +
(0.8 * (MATCH(pageRegions.contents) AGAINST (\'+keyword*\' IN BOOLEAN MODE)))) AS `score`,
`pages`.`name` AS `page_name`,
`pages`.`id` AS `page_id`,
`pageRegions`.*,
COUNT(DISTINCT(pages.id)) AS `count`
FROM `pages`
INNER JOIN `pageRegions` ON pageRegions.pageId = pages.id
WHERE (MATCH (pages.name, pageRegions.contents) AGAINST (\'+keyword*\' IN BOOLEAN MODE))
ORDER BY `score` DESC)
+
(SELECT `documents`.*,
((1.3 * (MATCH(documents.title) AGAINST (\'+keyword*\' IN BOOLEAN MODE))) +
(0.8 * (MATCH(documents.short_description, files.NAME, files.extracted_text) AGAINST (\'+keyword*\' IN BOOLEAN MODE)))) AS `score`,
`files`.*,
COUNT(documents.id) AS `count`
FROM `documents`
INNER JOIN `files` ON files.id = documents.file
WHERE (MATCH (documents.title, documents.short_description, files.name, files.extracted_text) AGAINST (\'+keyword*\' IN BOOLEAN MODE))
ORDER BY `score` DESC)
) AS COUNT
没有找到相关结果
已邀请:
1 个回复
济畦刨
的代码的一部分。 您在构建这些参数的过程中错过了一个参数，该参数是您想要的列数组，如果不给它，它将占用表格*。 因此，只需检查创建select的方式并添加一个带有空数组的参数即可。 更新： 所以你也是：重做一次之后，使用Zend_Db_Table（此处为$ this）重做一次调用，您可以在此处指定列，因此可以使用一个空数组或唯一的数组：