jonasraoni

<?php
print_r(optimizeCountQuery(
	'SELECT (SELECT drop FROM expensive WHERE true = ?) AS subquery
	FROM table
	WHERE (SELECT ?) = param
	ORDER BY not_needed_for_count, drop = ?',
	[true,'param', true]
));

/*

jonasraoni

<?php

/**
 * @file classes/migration/upgrade/v3_4_0/I8073_RemoveNotesWithoutQueriesAndRelatedObjects.php
 *
 * Copyright (c) 2014-2022 Simon Fraser University
 * Copyright (c) 2000-2022 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class I8073_RemoveNotesWithoutQueriesAndRelatedObjects

jonasraoni

<?php

/**
 * @file classes/search/ArticleSearchDAO.php
 *
 * Copyright (c) 2014-2021 Simon Fraser University
 * Copyright (c) 2003-2021 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class ArticleSearchDAO