Главная » Аналитика » Рефрактометры карманные

Поративные рефрактометры Atago

SELECT sc.*, photos.value as photos,vendor.value as vendor,price.value as price FROM `analyt_icspb`.`modx_site_content` sc LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` photos ON photos.contentid=sc.id AND photos.tmplvarid=3 LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` vendor ON vendor.contentid=sc.id AND vendor.tmplvarid=8 LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` price ON price.contentid=sc.id AND price.tmplvarid=10 WHERE sc.template!=5 AND sc.template!=29 AND sc.template!=0 AND sc.template!=28 AND sc.deleted=0 AND sc.published=1 AND FIND_IN_SET(sc.parent, "277,394,821,807,808,395,809,396,810,397,399,811,400,401,402,63") ORDER BY pub_date DESC LIMIT 0,42
SELECT COUNT(*) as count, sc.id as id FROM `analyt_icspb`.`modx_site_content` sc LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` photos ON photos.contentid=sc.id AND photos.tmplvarid=3 LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` vendor ON vendor.contentid=sc.id AND vendor.tmplvarid=8 LEFT OUTER JOIN `analyt_icspb`.`modx_site_tmplvar_contentvalues` price ON price.contentid=sc.id AND price.tmplvarid=10 WHERE sc.template!=5 AND sc.template!=29 AND sc.template!=0 AND sc.template!=28 AND sc.deleted=0 AND sc.published=1 AND FIND_IN_SET(sc.parent, "277,394,821,807,808,395,809,396,810,397,399,811,400,401,402,63")