string(939) "SELECT p.id, p.url, p.brand_id, p.event_id, p.whom_id, p.name, p.annotation, p.body, p.position, p.created as created, p.visible, p.featured, p.meta_title, p.meta_keywords, p.meta_description, b.name as brand, b.url as brand_url, e.name as event, e.url as event_url, w.name as whom, w.url as whom_url FROM s_products p INNER JOIN s_products_categories pc ON pc.product_id = p.id AND pc.category_id in('42') LEFT JOIN s_brands b ON p.brand_id = b.id LEFT JOIN s_events e ON p.event_id = e.id LEFT JOIN s_whoms w ON p.whom_id = w.id LEFT JOIN s_variants v ON v.product_id = p.id WHERE 1 AND v.price > 0 AND (v.stock IS NULL OR v.stock > 0) AND p.visible=1 GROUP BY p.id ORDER BY p.position DESC LIMIT 0, 150 "