/web/en/products/maintenance-and-chemistry/pool-chemicals/chlorine-products
Table 'vagnerpool_micro.sys_1_webproductkatalog_eur' doesn't exist
dotaz: SELECT SQL_CALC_FOUND_ROWS
      vagnerpool_shared.sys_webproduct.*,
      vagnerpool_micro.sys_1_webproductseason.*,
      vagnerpool_shared.sys_webproduct.webproduct_id as ltext
      ,vagnerpool_micro.sys_1_webproductkatalog_eur.cena as cena,vagnerpool_micro.sys_1_webproductkatalog_eur.dph,vagnerpool_micro.sys_1_webproductkatalog_eur.mena,
      K.cena as katalog_cena,K.dph as katalog_dph,K.mena as katalog_mena
    FROM vagnerpool_shared.sys_webproduct
    JOIN vagnerpool_micro.sys_1_webproductseason ON vagnerpool_micro.sys_1_webproductseason.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
    JOIN vagnerpool_shared.sys_webproductwebcat ON (vagnerpool_shared.sys_webproductwebcat.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id AND vagnerpool_shared.sys_webproductwebcat.webcat_id IN (318,318))
    
     LEFT JOIN vagnerpool_micro.sys_1_webproductkatalog_eur ON vagnerpool_micro.sys_1_webproductkatalog_eur.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
    LEFT JOIN vagnerpool_micro.sys_1_webproductkatalog_eur K ON K.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
     LEFT JOIN vagnerpool_shared.sys_webproductwebcatorderno ON vagnerpool_shared.sys_webproductwebcatorderno.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id AND vagnerpool_shared.sys_webproductwebcatorderno.webcat_id=292
    LEFT JOIN vagnerpool_micro.sys_1_prodejnost365 ON vagnerpool_micro.sys_1_prodejnost365.PRODEJ365_IDPROD=vagnerpool_shared.sys_webproduct.POL_ID
    WHERE
      vagnerpool_micro.sys_1_webproductseason.aktivninawebu=1 AND
    (
      
      vagnerpool_shared.sys_webproduct.webproduct_id NOT IN (SELECT vagnerpool_micro.sys_1_webproductseznamwebproduct.webproduct_id 
        FROM vagnerpool_micro.sys_1_webproductseznamwebproduct
        JOIN vagnerpool_micro.sys_1_webproductseznam ON vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznamwebproduct.webproductseznam_id 
        JOIN vagnerpool_micro.sys_1_webproductprotect ON vagnerpool_micro.sys_1_webproductprotect.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id AND vagnerpool_micro.sys_1_webproductprotect.nelzeobjednat=0)
      
      
      
      OR
      
      vagnerpool_shared.sys_webproduct.webproduct_id IN (SELECT vagnerpool_micro.sys_1_webproductseznamwebproduct.webproduct_id 
        FROM vagnerpool_micro.sys_1_webproductseznamwebproduct
        JOIN vagnerpool_micro.sys_1_webproductseznam ON vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznamwebproduct.webproductseznam_id 
        JOIN vagnerpool_micro.sys_1_webproductprotect ON vagnerpool_micro.sys_1_webproductprotect.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id
        JOIN vagnerpool_micro.sys_1_odberatelseznam ON vagnerpool_micro.sys_1_odberatelseznam.odberatelseznam_id=vagnerpool_micro.sys_1_webproductprotect.odberatelseznam_id
        WHERE vagnerpool_micro.sys_1_webproductprotect.active=1 AND vagnerpool_micro.sys_1_webproductprotect.filtered=1 AND vagnerpool_micro.sys_1_webproductprotect.filteredopts3=1)
      
      OR
      
      vagnerpool_shared.sys_webproduct.webproduct_id IN (SELECT vagnerpool_micro.sys_1_webproductseznamwebproduct.webproduct_id 
        FROM vagnerpool_micro.sys_1_webproductseznamwebproduct
        JOIN vagnerpool_micro.sys_1_webproductseznam ON vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznamwebproduct.webproductseznam_id 
        JOIN vagnerpool_micro.sys_1_webproductprotect ON vagnerpool_micro.sys_1_webproductprotect.webproductseznam_id=vagnerpool_micro.sys_1_webproductseznam.webproductseznam_id
        /*JOIN vagnerpool_micro.sys_1_odberatelseznam ON vagnerpool_micro.sys_1_odberatelseznam.odberatelseznam_id=vagnerpool_micro.sys_1_webproductprotect.odberatelseznam_id*/
        WHERE vagnerpool_micro.sys_1_webproductprotect.active=1 AND vagnerpool_micro.sys_1_webproductprotect.filtered=0 AND vagnerpool_micro.sys_1_webproductprotect.filteredopts1=1)
      
        
    ) AND vagnerpool_shared.sys_webproduct.POL_ID NOT LIKE "%DAR" AND vagnerpool_shared.sys_webproduct.webproduct_id IN (SELECT wpwc.webproduct_id 
      FROM vagnerpool_shared.sys_webproductwebcat wpwc WHERE wpwc.webcat_id IN (SELECT wc.webcat_id FROM vagnerpool_shared.sys_webcat wc
        WHERE wc.filtered=0
        
         OR wc.filtered=2  
      )
    )
    GROUP BY vagnerpool_shared.sys_webproduct.webproduct_id
    ORDER BY
      -vagnerpool_shared.sys_webproductwebcatorderno.orderno DESC,vagnerpool_shared.sys_webproduct.POL_ID ASC
    LIMIT 0,15