Новогодние украшения

SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'

SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SELECT *
FROM language
WHERE status = '1'

SELECT *
FROM currency

SELECT *
FROM weight_class wc

SELECT *
FROM length_class mc

SELECT *
FROM url_alias
WHERE keyword IN ('novogodniy_dekor')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND p2c.category_id = '934'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT DISTINCT p2c.category_id, c.name as name, c.image as image, c.parent_id, c1.name as name_parent
FROM product_to_category p2c
LEFT JOIN category c ON (p2c.category_id = c.category_id)
LEFT JOIN category c1 ON (c.parent_id = c1.category_id)
WHERE p2c.product_id IN ('3906','3908','3926','3927','23549','23552','23553','23554','23555','23556','23557','23558','23559','23563','23564','23572','23575','23577','23623','23624','23626','24287','24317','73383','73386','73388','73390','73394','73398','73399','73400','73401','73403','73404','73408','73410','73411','73415','73470','73478','76206','76211','76282') AND p2c.main_category='1' AND p2c.store_id = '0' GROUP BY p2c.category_id
ORDER BY c.sort_order, c1.sort_order

SELECT *
FROM product_image
WHERE product_id = '23623'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23623'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23623')

SELECT *
FROM product_image
WHERE product_id = '73399'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73399'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73399')

SELECT *
FROM product_image
WHERE product_id = '23555'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23555'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23555')

SELECT *
FROM product_image
WHERE product_id = '76206'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '76206'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=76206')

SELECT *
FROM product_image
WHERE product_id = '23624'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23624'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23624')

SELECT *
FROM product_image
WHERE product_id = '73400'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73400'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73400')

SELECT *
FROM product_image
WHERE product_id = '23556'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23556'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23556')

SELECT *
FROM product_image
WHERE product_id = '76211'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '76211'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=76211')

SELECT *
FROM product_image
WHERE product_id = '23626'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23626'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23626')

SELECT *
FROM product_image
WHERE product_id = '73401'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73401'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73401')

SELECT *
FROM product_image
WHERE product_id = '23557'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23557'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23557')

SELECT *
FROM product_image
WHERE product_id = '76282'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '76282'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=76282')

SELECT *
FROM product_image
WHERE product_id = '24287'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '24287'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=24287')

SELECT *
FROM product_image
WHERE product_id = '3906'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3906'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3906')

SELECT *
FROM product_image
WHERE product_id = '73403'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73403'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73403')

SELECT *
FROM product_image
WHERE product_id = '23558'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23558'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23558')

SELECT *
FROM product_image
WHERE product_id = '24317'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '24317'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=24317')

SELECT *
FROM product_image
WHERE product_id = '3908'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3908'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3908')

SELECT *
FROM product_image
WHERE product_id = '73404'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73404'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73404')

SELECT *
FROM product_image
WHERE product_id = '23559'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23559'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23559')

SELECT *
FROM product_image
WHERE product_id = '73383'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73383'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73383')

SELECT *
FROM product_image
WHERE product_id = '3926'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3926'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3926')

SELECT *
FROM product_image
WHERE product_id = '73408'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73408'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73408')

SELECT *
FROM product_image
WHERE product_id = '23563'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23563'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23563')

SELECT *
FROM product_image
WHERE product_id = '73386'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73386'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73386')

SELECT *
FROM product_image
WHERE product_id = '3927'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3927'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3927')

SELECT *
FROM product_image
WHERE product_id = '73410'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73410'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73410')

SELECT *
FROM product_image
WHERE product_id = '23564'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23564'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23564')

SELECT *
FROM product_image
WHERE product_id = '73388'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73388'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM product_image
WHERE product_id = '23549'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23549'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23549')

SELECT *
FROM product_image
WHERE product_id = '73411'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73411'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73411')

SELECT *
FROM product_image
WHERE product_id = '23572'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23572'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23572')

SELECT *
FROM product_image
WHERE product_id = '73390'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73390'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73390')

SELECT *
FROM product_image
WHERE product_id = '23552'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23552'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23552')

SELECT *
FROM product_image
WHERE product_id = '73415'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73415'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73415')

SELECT *
FROM product_image
WHERE product_id = '23575'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23575'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23575')

SELECT *
FROM product_image
WHERE product_id = '73394'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73394'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73394')

SELECT *
FROM product_image
WHERE product_id = '23553'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23553'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23553')

SELECT *
FROM product_image
WHERE product_id = '73470'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73470'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73470')

SELECT *
FROM product_image
WHERE product_id = '23577'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23577'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23577')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT a.name, a.attribute_id,pa.attribute_value_id
FROM attribute a
LEFT JOIN product_attribute pa on pa.attribute_id=a.attribute_id
WHERE a.use_in_filter='1' and pa.store_id='0' and pa.product_id IN('3906','3908','3926','3927','23549','23552','23553','23554','23555','23556','23557','23558','23559','23563','23564','23572','23575','23577','23623','23624','23626','24287','24317','73383','73386','73388','73390','73394','73398','73399','73400','73401','73403','73404','73408','73410','73411','73415','73470','73478','76206','76211','76282') group by a.attribute_id

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('3906','3908','3926','3927','23549','23552','23553','23554','23555','23556','23557','23558','23559','23563','23564','23572','23575','23577','23623','23624','23626','24287','24317','73383','73386','73388','73390','73394','73398','73399','73400','73401','73403','73404','73408','73410','73411','73415','73470','73478','76206','76211','76282') and p2s.status = '1' and p2s.store_id='0'

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('3906','3908','3926','3927','23549','23552','23553','23554','23555','23556','23557','23558','23559','23563','23564','23572','23575','23577','23623','23624','23626','24287','24317','73383','73386','73388','73390','73394','73398','73399','73400','73401','73403','73404','73408','73410','73411','73415','73470','73478','76206','76211','76282') and p2s.status = '1' and p2s.store_id='0'

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1' AND c.top='1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='934' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '934' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM extension
WHERE `type` = 'total'

SELECT *
FROM extension
WHERE `type` = 'total'