SQL: SELECT a.Id, count(v2l.IdVariant) as cnt
FROM
shop_article a
INNER JOIN shop_art2lang a2l ON a2l.IdArticle=a.Id AND
a2l.IdLanguage=1 AND
a2l.Flags & 1
LEFT JOIN shop_variant v ON a.Id=v.IdArticle
LEFT JOIN shop_var2lang v2l ON v2l.IdVariant=v.Id AND
v2l.IdLanguage=1 AND
v2l.Flags & 1
GROUP BY a.Id
2006: MySQL server has gone away-v dotazu: question from /mnt/storage2/ns2-vhosts/nejlevnejsi-barvy-laky.cz/web/www/_shop/articlesCount1.php on line 50SQL: SELECT *
FROM template_container WHERE (1=1) AND IdParent = 962 AND Flags & 1
ORDER BY colOrder ASC 2006: MySQL server has gone away-v dotazu: select properties of object template_containerSQL: SELECT * FROM template_container2lang
WHERE IdContainer=540 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 540 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=19
WHERE tm.Id=18 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=521 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 521 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=26
WHERE tm.Id=26 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=976 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 976 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=17
WHERE tm.Id=16 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=523 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 523 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT cachedata, userdata, expires
FROM cache
WHERE id = '1d08e79958c1c2970c05f4dfc0c736be' AND cachegroup = 'Container/Menu/Horizontal' 2006: MySQL server has gone away-v dotazu: SQL: UPDATE cache
SET changed = (NOW() + 0), hits=hits+1
WHERE id = '1d08e79958c1c2970c05f4dfc0c736be' AND cachegroup = 'Container/Menu/Horizontal' 2006: MySQL server has gone away-v dotazu: SQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=3
WHERE tm.Id=3 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=524 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 524 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=17
WHERE tm.Id=16 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=538 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 538 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=17
WHERE tm.Id=16 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=975 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 975 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=1
WHERE tm.Id=1 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=992 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 992 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=1
WHERE tm.Id=1 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=545 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 545 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT cachedata, userdata, expires
FROM cache
WHERE id = 'ee74a8414af31410430acd950c90ebce' AND cachegroup = 'Container/Section' 2006: MySQL server has gone away-v dotazu: SQL: UPDATE cache
SET changed = (NOW() + 0), hits=hits+1
WHERE id = 'ee74a8414af31410430acd950c90ebce' AND cachegroup = 'Container/Section' 2006: MySQL server has gone away-v dotazu: SQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=1
WHERE tm.Id=1 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=1002 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 1002 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=1
WHERE tm.Id=1 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT * FROM template_container2lang
WHERE IdContainer=957 AND
IdLanguage=1 2006: MySQL server has gone away-v dotazu: select properties of object CTemplate_Container2LangSQL: SELECT *
FROM template_container_set WHERE (1=1) AND IdContainer = 957 AND IdLanguage = 1 2006: MySQL server has gone away-v dotazu: select properties of object template_cssSQL: SELECT cachedata, userdata, expires
FROM cache
WHERE id = 'f39b6da6e51ada83d4b245ce7a23ce9e' AND cachegroup = 'Container/Section' 2006: MySQL server has gone away-v dotazu: SQL: UPDATE cache
SET changed = (NOW() + 0), hits=hits+1
WHERE id = 'f39b6da6e51ada83d4b245ce7a23ce9e' AND cachegroup = 'Container/Section' 2006: MySQL server has gone away-v dotazu: SQL: SELECT tm.File, tm.Name as ModuleName, tt.Filename
FROM template_module tm
INNER JOIN template_template tt ON tt.IdModule = tm.Id AND tt.Id=1
WHERE tm.Id=1 2006: MySQL server has gone away-v dotazu: select template_and_module to divSQL: SELECT cachedata, userdata, expires
FROM cache
WHERE id = '84ac8fe902275b3f0a1cc9340efcbee3' AND cachegroup = 'Page/tme' 2006: MySQL server has gone away-v dotazu: SQL: UPDATE cache
SET changed = (NOW() + 0), hits=hits+1
WHERE id = '84ac8fe902275b3f0a1cc9340efcbee3' AND cachegroup = 'Page/tme' 2006: MySQL server has gone away-v dotazu: SQL: REPLACE INTO cache (
userdata,
cachedata,
expires,
id,
cachegroup,
hits)
VALUES ('', '', 1685533055, '84ac8fe902275b3f0a1cc9340efcbee3', 'Page/tme', 0) 2006: MySQL server has gone away-v dotazu: Nejlevnější Barvy Laky- Nejlevnější-Barvy-Laky.cz
+420 777 100 004