{"p":null,"res":null,"d":null,"limit":10,"number":4,"q":"SELECT modResource.id, modResource.parent,\n\t\t modResource.pagetitle,\n\t\t modResource.uri,\n\t\t modResource.publishedon,\n\t\t tvts.value AS ts,\n\t\t tvct.value AS ct,\n\t\t tvcc.value AS cc,\n\t\t tvtsur.value AS tsur,\n\t\t tvi.value AS image,\n\t\t tvnew.value AS isNew,\n\t\t tvbest.value AS isBest,\n\t\t tvsale.value AS isSale,\n\t\t tvgiftcheck.value AS giftCheck,\n\t\t MAX(shop.id) as maxshcid\n\t\tFROM\n\t\t modx_mkmagazin_site_content AS modResource\n\t\tJOIN \n\t\t modx_mkmagazin_shop_content shop ON (shop.resource_id = modResource.id AND shop.published = 1)\n\t\tJOIN\n\t\t modx_mkmagazin_site_content brand ON(\n\t\t\tmodResource.parent = brand.id AND brand.hidemenu = 0\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvts ON(\n\t\t\ttvts.contentid = modResource.id AND tvts.tmplvarid = 8\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvct ON(\n\t\t\ttvct.contentid = modResource.id AND tvct.tmplvarid = 11\n\t\t ) \n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvcc ON(\n\t\t\ttvcc.contentid = modResource.id AND tvcc.tmplvarid = 12 \n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvtsur ON(\n\t\t\ttvtsur.contentid = modResource.id AND tvtsur.tmplvarid = 18 \n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvi ON(\n\t\t\ttvi.contentid = modResource.id AND tvi.tmplvarid = 1\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvnew ON(\n\t\t\ttvnew.contentid = modResource.id AND tvnew.tmplvarid = 14\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvbest ON(\n\t\t\ttvbest.contentid = modResource.id AND tvbest.tmplvarid = 16\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvsale ON(\n\t\t\ttvsale.contentid = modResource.id AND tvsale.tmplvarid = 17\n\t\t )\n\t\tLEFT JOIN\n\t\t modx_mkmagazin_site_tmplvar_contentvalues tvgiftcheck ON(\n\t\t\ttvgiftcheck.contentid = modResource.id AND tvgiftcheck.tmplvarid = 46\n\t\t ) WHERE ( modResource.published = 1 AND modResource.template =2 ) GROUP BY id","total":662,"col":[{"id":"1057","t":"Agat \/ \u0410\u0433\u0430\u0442","p":["162"],"u":"katalog\/proizvoditeli\/cersanit\/agat.html","b":"","gf":"","gfs":"\u0441\u043a\u0438\u0434\u043a\u0430 \u043f\u0440\u0438 \u043f\u043e\u043a\u0443\u043f\u043a\u0435<\/span><\/span>","prd":"","pr":469,"i":"\/assets\/image-cache\/images\/cersanit\/agat\/agat-int_1404456364.5077436b.jpg","isnew":[""],"ts":["148"],"ct":["36","1206","37"],"cc":["99"],"tsur":["697"]},{"id":"2615","t":"ALBERO","p":["1253"],"u":"katalog\/proizvoditeli\/belleza\/albero-\/-albero.html","b":"","gf":"","gfs":"","prd":"","pr":584,"i":"\/assets\/image-cache\/images\/belezza\/albero\/albero_1477905658.5077436b.jpg","isnew":[""],"ts":["9"],"ct":["38","37"],"cc":["105","102"],"tsur":["696"]},{"id":"2467","t":"Allegro \/ \u0410\u043b\u043b\u0435\u0433\u0440\u043e","p":["1452"],"u":"katalog\/proizvoditeli\/gracia-ceramica\/allegro-\/-allegro.html","b":"","gf":"","gfs":"","prd":"","pr":809,"i":"\/assets\/image-cache\/images\/gracia ceramica\/allegro\/allegro-interer_1472045037.5077436b.jpg","isnew":[""],"ts":["982"],"ct":["1206","36","37"],"cc":["99","102"],"tsur":["697"]},{"id":"2439","t":"Amalfi \/ \u0410\u043c\u0430\u043b\u044c\u0444\u0438","p":["169"],"u":"katalog\/proizvoditeli\/shaxtinskaia-plitka\/amalfi.html","b":"","gf":"","gfs":"","prd":"","pr":629,"i":"\/assets\/image-cache\/images\/gracia ceramica\/amalfi\/amalfi_1452605398.5077436b.jpg","isnew":[""],"ts":["125"],"ct":["36","1206","37"],"cc":["99","2521"],"tsur":["697"]},{"id":"1994","t":"Amati \/ \u0410\u043c\u0430\u0442\u0438","p":["175"],"u":"katalog\/proizvoditeli\/azori\/amati-\/-amati.html","b":"","gf":"","gfs":"","prd":"","pr":599,"i":"\/assets\/image-cache\/images\/azori\/amati\/amati-ambra2_1468225792.5077436b.jpg","isnew":[""],"ts":["1221"],"ct":["36","35"],"cc":["99","118"],"tsur":["697"]},{"id":"1479","t":"Andes \/ \u0410\u043d\u0434\u044b","p":["169"],"u":"katalog\/proizvoditeli\/shaxtinskaia-plitka\/andes\/","b":"","gf":"","gfs":"","prd":"","pr":663,"i":"\/assets\/image-cache\/images\/gracia ceramica\/andes\/andyi_1456908104.5077436b.jpg","isnew":[""],"ts":["132"],"ct":["38"],"cc":["99","102"],"tsur":["698"]},{"id":"1455","t":"Angers \/ \u0410\u043d\u0436\u0435\u0440","p":["1452"],"u":"katalog\/proizvoditeli\/gracia-ceramica\/anzher-\/angers\/","b":"sale","gf":"","gfs":"","prd":"","pr":554,"i":"\/assets\/image-cache\/images\/gracia ceramica\/angers\/bgracia-anger-venge-enl_1452596563.5077436b.jpg","isnew":[""],"ts":["125"],"ct":["36","1206","37"],"cc":["99","105","102"],"tsur":["697"]},{"id":"2468","t":"Aquarelle \/ \u0410\u043a\u0432\u0430\u0440\u0435\u043b\u044c","p":["1452"],"u":"katalog\/proizvoditeli\/gracia-ceramica\/aquarelle-\/-aquarelle.html","b":"","gf":"","gfs":"","prd":"","pr":809,"i":"\/assets\/image-cache\/images\/gracia ceramica\/aquarelle\/aquarelle-interer_1472046313.5077436b.jpg","isnew":[""],"ts":["982"],"ct":["1206","36","37"],"cc":["118"],"tsur":["697"]},{"id":"2496","t":"Arabeski blue \/ \u0410\u0440\u0430\u0431\u0435\u0441\u043a\u0438 \u0441\u0438\u043d\u0438\u0439","p":["1452"],"u":"katalog\/proizvoditeli\/gracia-ceramica\/arabeski-blue-\/-arabeski-blue.html","b":"sale","gf":"","gfs":"","prd":"","pr":450,"i":"\/assets\/image-cache\/images\/gracia ceramica\/arabeski\/gracia-ceramica-arabeski-1_1452601921.5077436b.jpg","isnew":[""],"ts":["982"],"ct":["36","1206","37"],"cc":["44"],"tsur":["697"]},{"id":"2436","t":"Arabeski purple \/ \u0410\u0440\u0430\u0431\u0435\u0441\u043a\u0438 \u043f\u0443\u0440\u043f\u0443\u0440\u043d\u044b\u0439","p":["1452"],"u":"katalog\/proizvoditeli\/gracia-ceramica\/arabeski-purple-\/-arabeski-purple.html","b":"","gf":"","gfs":"","prd":"","pr":759,"i":"\/assets\/image-cache\/images\/gracia ceramica\/arabeski\/arabeskiarabeski_1452598642.5077436b.jpg","isnew":[""],"ts":["982"],"ct":["1206","36","37"],"cc":["2524"],"tsur":["697"]}]}