[Sheryld]

в чем ошибка?

структуры таблиц:

CREATE TABLE game_genre (
  g_g_ID int(11) NOT NULL default '0',
  g_g_TITLE varchar(255) NOT NULL default '',
  PRIMARY KEY  (g_g_ID)
) TYPE=MyISAM;

CREATE TABLE game_item (
  g_i_ID int(11) NOT NULL auto_increment,
  g_g_ID int(11) NOT NULL default '0',
  g_i_TITLE text NOT NULL,
  g_i_DESC text NOT NULL,
  g_i_DEF_SCR_PATH text NOT NULL,
  g_i_CODE int(11) NOT NULL default '0',
  g_i_RUSS int(11) NOT NULL default '0',
  g_i_RECOMMEND int(11) NOT NULL default '0',
  PRIMARY KEY  (g_i_ID)
) TYPE=MyISAM;

CREATE TABLE game_item_phone (
  g_i_ID int(11) NOT NULL default '0',
  g_phn_ID int(11) NOT NULL default '0'
) TYPE=MyISAM

CREATE TABLE game_phone (
  g_phn_ID int(11) NOT NULL auto_increment,
  g_phn_TITLE varchar(255) NOT NULL default '',
  PRIMARY KEY  (g_phn_ID)
) TYPE=MyISAM;

запрос:

SELECT DISTINCT gi.g_i_ID, gi.g_g_ID, gi.g_i_TITLE, gi.g_i_DESC, gi.g_i_CODE, gi.g_i_DEF_SCR_PATH
FROM game_item_phone
as phn
inner join game_item
as gi
on gi.g_i_ID = phn.g_i_ID
inner join game_genre gg
on gi.g_g_ID = gg.g_g_ID
where phn.g_phn_ID = 100
and gi.g_i_TITLE
like "%a%"
or gi.g_i_DESC
like "%a%"
ORDER BY gi.g_i_TITLE
asc

условие phn.g_phn_ID = 100 - игнорируется