SQL=SELECT COUNT(*) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.sizes != '' AND i.size_range !='' AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-08-02 03:36:03' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-08-02 03:36:03' ) AND c.id IN (28,31,34,35,36,37,44,50,52,68) AND ( i.`collection_id` = 44 OR i.`collection_id` = 47 OR i.`collection_id` = 48) AND ( (i.`color_id` LIKE '%,26,%' OR i.`color_id` = 26) ) AND ( i.tm='Red-n-Rock\'s' OR i.tm='RUSTEAM') AND ( i.sizes LIKE '%44%' OR i.sizes LIKE '%48%' OR i.sizes LIKE '%54%' OR i.sizes LIKE '%62%' ) AND i.material IN (5,25,26,7,8,9,10,11,20,23,24,28,29,2,3,27)
| Call stack | ||
| # | Function | Location |
| 1 | JApplicationCms->execute() | /index.php:57 |
| 2 | JApplicationSite->doExecute() | /libraries/cms/application/cms.php:261 |
| 3 | JApplicationSite->dispatch() | /libraries/cms/application/site.php:230 |
| 4 | JComponentHelper::renderComponent() | /libraries/cms/application/site.php:191 |
| 5 | JComponentHelper::executeComponent() | /libraries/cms/component/helper.php:380 |
| 6 | require_once() | /libraries/cms/component/helper.php:405 |
| 7 | JControllerLegacy->execute() | /components/com_k2/k2.php:65 |
| 8 | K2ControllerItemlist->display() | /libraries/legacy/controller/legacy.php:703 |
| 9 | K2Controller->display() | /components/com_k2/controllers/itemlist.php:49 |
| 10 | JControllerLegacy->display() | /components/com_k2/controllers/controller.php:20 |
| 11 | K2ViewItemlist->display() | /libraries/legacy/controller/legacy.php:665 |
| 12 | K2ModelItemlist->getTotal() | /components/com_k2/views/itemlist/view.html.php:497 |
| 13 | JDatabaseDriver->loadResult() | /components/com_k2/models/itemlist.php:894 |
| 14 | JDatabaseDriverMysqli->execute() | /libraries/joomla/database/driver.php:1728 |