string(716) " FROM alterstarshop_shop_products p LEFT JOIN alterstarshop_shop_producers pr ON p.id_producer=pr.id LEFT JOIN alterstarshop_shop_cat k ON p.id_cat=k.id WHERE 1 AND k.status=1 AND (k.data_start<=NOW() OR k.data_start='0000-00-00 00:00:00') AND (k.data_stop>=NOW() OR k.data_stop='0000-00-00 00:00:00') AND k.lang='1' AND (p.name LIKE '%A004TR5894%' OR p.name LIKE '%A004TR5894%' OR p.symbol LIKE '%A004TR5894%' OR (SELECT COUNT(r.id) FROM alterstarshop_shop_products_numery r WHERE r.id_product=p.id AND ( r.tresc='a004tr5894' OR r.tresc='A004TR5894' ) )>0) AND p.status=1 AND (p.data_start<=NOW() OR p.data_start='0000-00-00 00:00:00') AND (p.data_stop>=NOW() OR p.data_stop='0000-00-00 00:00:00') AND p.lang='1'"
