Поиск в разделах:

Агентства недвижимости

Связанные категории


SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__categories` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.access IN (1,1,9)
  AND t0.storage_location = "joomla_category"
  AND t1.id IN ('85','87','88')
  AND t1.published = '1'
ORDER BY t1.title ASC

SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__categories` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.access IN (1,1,9)
  AND t0.storage_location = "joomla_category"
  AND t1.id IN ('85','87','88')
  AND t1.published = '1'

0.001 seconds (0.001); 24.73 MB (24.734) - afterSearch [Cache=OFF] = 3 results.
0.012 seconds (0.011); 24.92 MB (0.185) - afterRender [Cache=OFF]