SELECT id,name FROM yarm_katalog WHERE top=0 AND type>0 AND hide=0 ORDER BY ord,id
SELECT t.id topid, t.name topname, c.id id, c.name name, c.link link FROM yarm_katalog t LEFT JOIN yarm_katalog c ON c.top=t.id WHERE t.top=0 AND t.type=0 AND t.hide=0 AND c.hide=0 ORDER BY t.ord,t.id,c.ord,c.id


select content from yarm_text where id=3

SELECT distinct LEFT(name,1) as lchar FROM yarm_slovar ORDER BY lchar



SELECT id,name FROM yarm_slovar WHERE LEFT(name,1) like 'И' OR LEFT(name,1) like 'И' ORDER BY name



, admin@kb-yarmarka.ru
© "", 2003-2006 ""

Created by Antarex
select content from yarm_text where id=4