SELECT c.id, c.name AS name FROM nom_shabloni AS c ORDER BY name ASCSELECT p.id, p.catno, p.pprodid, p.prtype, p.barcode, p.catalogid, p.shablonid2010, p.kcatalogid, p.markid, p.thumb, p.image, p.scheme, p.in_warehouse, p.is_tradernet_bg AS is_tradernet, p.is_catalog, p.sort, p.added, p.modified, p.prstatus, p.quantity, p.quantity1, p.weight, p.weight_bruto, p.weight_neto, p.obem, p.is_dobavki, pd.name AS name, pd.description AS description, p.coponid AS coponid, p.copon_type AS copon_type, p.copon_disc AS copon_disc, p.start_copon AS start_copon, p.end_copon AS end_copon, pp.request_for_price, pp.recommendatory_price, pp.promotional_price, pp.bulk_price, pp.is_available, pp.is_promotional, pp.is_bulk, pp.currency, pp.pg1 FROM products AS p LEFT JOIN products_descr_bg as pd ON p.id=pd.p_id RIGHT JOIN prices_bg as pp ON p.id = pp.p_id WHERE p.pprodid='0' AND (p.is_tradernet_bg='1') AND (pp.is_available='1') AND p.company_id='0' GROUP BY p.id ORDER BY p.added DESC
Нови
