SELECT "shop_backend_product"."id", "shop_backend_product"."catalog_id", "shop_backend_product"."kind", "shop_backend_product"."manufacturer_id", "shop_backend_product"."unit_id", "shop_backend_product"."custom_id", "shop_backend_product"."name", "shop_backend_product"."aname", "shop_backend_product"."art", "shop_backend_product"."pprc", "shop_backend_product"."pcur_id", "shop_backend_product"."sk", "shop_backend_product"."sale", "shop_backend_product"."rprc", "shop_backend_product"."rcur_id", "shop_backend_product"."wprc", "shop_backend_product"."wcur_id", "shop_backend_product"."rmrg", "shop_backend_product"."wmrg", "shop_backend_product"."morder", "shop_backend_product"."hidden", "shop_backend_product"."hide_if_no", "shop_backend_product"."hide_mnf", "shop_backend_product"."export_ym", "shop_backend_product"."export_yd", "shop_backend_product"."replacement", "shop_backend_product"."discontinued", "shop_backend_product"."notice", "shop_backend_product"."delivery_cost", "shop_backend_product"."yd_name", "shop_backend_product"."yd_mnf", "shop_backend_product"."yd_art", "shop_backend_product"."mnfd", ( select SUM(remain.qua) from shop_backend_remain as remain
                                                INNER join shop_backend_storage as storage on storage.id=remain.storage_id where
                                                      remain.product_id=shop_backend_product.id and storage.local='f'

                                ) AS "additional_storage_count", ( select SUM(remain.qua) from shop_backend_remain as remain
                                                INNER join shop_backend_storage as storage on storage.id=remain.storage_id where
                                                      remain.product_id=shop_backend_product.id and storage.local='t'

                                ) AS "main_storage_count", "shop_backend_manufacturer"."id", "shop_backend_manufacturer"."custom_id", "shop_backend_manufacturer"."sname", "shop_backend_manufacturer"."fname", "shop_backend_manufacturer"."url", "shop_backend_manufacturer"."dtime", "shop_backend_manufacturer"."zero_price_msg", "shop_backend_manufacturer"."ym_min_sum", "shop_backend_manufacturer"."hide_wprc", "shop_backend_manufacturer"."action_price_min", "shop_backend_manufacturer"."action_margin_min", "shop_backend_manufacturer"."action_price_percent", "shop_backend_manufacturer"."catalog_id" FROM "shop_backend_product" INNER JOIN "shop_backend_manufacturer" ON ( "shop_backend_product"."manufacturer_id" = "shop_backend_manufacturer"."id" ) WHERE ("shop_backend_product"."sk" > 0 AND "shop_backend_product"."catalog_id" IN (35213, 35151, 35207, 502095, 773541, 773544, 773546, 773547, 773548, 773550)) ORDER BY "shop_backend_product"."name" ASC, "shop_backend_product"."aname" ASC; args=('f', 't', Decimal('0'), 35213, 35151, 35207, 502095, 773541, 773544, 773546, 773547, 773548, 773550)