Проблема с запросом [mysql]
в чем ошибка?
структуры таблиц:
Код:
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 - игнорируется |
