cached query: SELECT
shipping_status_name,
shipping_status_image,shipping_status_id
FROM shipping_status
where language_id = '1' cached query: SELECT *
FROM
currencies cached query: SELECT *
FROM
customers_status
WHERE
customers_status_id = '1' AND language_id = '1' cached query: SELECT tax_class_id as class FROM tax_class cached query: select * FROM products p,
products_description pd
where p.products_status = '1'
and p.products_id = '0'
and pd.products_id = p.products_id
and pd.language_id = '1' cached query: select c.categories_id,
cd.categories_name,
c.parent_id from categories c, categories_description cd
where c.categories_status = '1'
and c.parent_id = '0'
and c.categories_id = cd.categories_id
and cd.language_id='1'
order by sort_order, cd.categories_name cached query: select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.parent_id = '10000' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name cached query: select categories_url from categories where categories_id="" cached query: select t.topics_id, td.topics_name, t.parent_id from topics t, topics_description td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '1' order by sort_order, td.topics_name cached query: select distinct m.manufacturers_image, m.manufacturers_id, m.manufacturers_name from manufacturers as m, products as p where m.manufacturers_id=p.manufacturers_id order by m.manufacturers_name, m.manufacturers_image cached query: SELECT
content_id,
categories_id,
parent_id,
content_title,
content_url,
content_group
FROM content_manager
WHERE languages_id='1'
and file_flag=0 and content_status=1 order by sort_order cached query: select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '315' and languages_id = '1'
cached query: select cm.content_heading, cm.content_meta_title, cm.content_meta_description, cm.content_meta_keywords from content_manager cm where cm.content_group = '5' and cm.languages_id = '1'
cached query: SELECT
content_title,
content_heading,
content_text,
content_file
FROM content_manager
WHERE content_group='5'
AND languages_id='1' cached query: SELECT * FROM
products p
LEFT JOIN manufacturers AS m
ON m.manufacturers_id = p.manufacturers_id,
products_description pd
WHERE
p.products_id = pd.products_id and p.products_startpage = '1'
AND p.products_status = '1'
AND pd.language_id = '1'
ORDER BY p.products_startpage_sort ASC limit 12 cached query: SELECT distinct * FROM
products p left join products_description pd on pd.products_id = p.products_id,
manufacturers m,
featured f where
p.products_id=f.products_id and
m.manufacturers_id=p.manufacturers_id
and p.products_status = '1' and f.status = '1' and pd.language_id = '1'
order by p.products_date_added DESC limit 9 cached query:
SELECT
news_id,
headline,
content,
date_added
FROM latest_news
WHERE
status = '1'
and language = '1'
ORDER BY date_added DESC
LIMIT 2
cached query: select p.products_id,
pd.products_name,
products_date_available as date_expected from products p, products_description pd
where to_days(products_date_available) >= to_days(now())
and p.products_id = pd.products_id
and pd.language_id = '1'
order by products_name desc
limit 10 cached query: select c.categories_image, c.categories_id, cd.categories_name FROM categories c left join categories_description cd on c.categories_id = cd.categories_id WHERE c.categories_status = '1' and cd.language_id = 1 and c.parent_id = '0' order by c.sort_order ASC
