Автори | Гоголівська академія

Українська банерна мережа

Украинская Баннерная Сеть



	ПОШУК

АВТОРУ:

	Ім’ я користувача

	Пароль



Бажаєте зареєструватися? Забули пароль?

Гоголівський ФОРУМ

AlmaNAH

Наша статистика

Авторів:	2710
Творів:	52097
Рецензій:	96321

Наша кнопка

Код:

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '180'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2663'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2176'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '3153'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2632'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2559'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2344'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '383'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1051'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2161'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1096'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '2106'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1867'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '178'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1295'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1557'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '940'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1160'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '351'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1328'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1180'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '457'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '699'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '715'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '631'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '609'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '580'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '561'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '262'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '1810'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '454'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Ошибка при запросе:

SELECT creatives.TID,
creatives.CID,
creatives.adding_date,
creatives.header,
categories.name as cname,
genres.name as zname,
COUNT(reviews.TID) as rcount,
fav_creatives.FID
 FROM creatives
 LEFT JOIN categories ON categories.CID = creatives.CID
 LEFT JOIN genres ON genres.ZID = creatives.ZID
 LEFT JOIN reviews ON creatives.TID = reviews.TID
 LEFT JOIN fav_creatives ON fav_creatives.TID = creatives.TID
 WHERE creatives.UID = '142'
AND creatives.hidden <> 'y'
 GROUP BY creatives.TID 
 ORDER BY `adding_date` DESC
				LIMIT 0,2

Ответ MySQL:
1054 Unknown column 'categories.name' in 'field list'

Yephrem Patsyukevitch
Свіжі твори

П.Домаха
Свіжі твори

Уляна Галич (Консуело)
Свіжі твори

Борис Бібіков
Свіжі твори

NATALKA DOLIAK
Свіжі твори

оксана радушинська
Свіжі твори

Богдан Коломійчук
Свіжі твори

Костенко Олександр
Свіжі твори

Роман RemiK Котик
Свіжі твори

Ельвіра
Свіжі твори

Володимир ЧИТАЙ
Свіжі твори

наталя терещенко
Свіжі твори

Зоряна Биндас
Свіжі твори

Юлія Петрусенко - Левківська
Свіжі твори

Ніка Новікова
Свіжі твори

Зоряна Замкова
Свіжі твори

Жан
Свіжі твори

Антоніна Аністратенко
Свіжі твори

Аня Хромова
Свіжі твори

Дарця Борхес
Свіжі твори

Саніна Аня
Свіжі твори

Vasyl R
Свіжі твори

Tatchyn
Свіжі твори

Наталя Клименко
Свіжі твори

Микола Шпаковський
Свіжі твори

Дмитро Kуракін
Свіжі твори

Олександр Корж
Свіжі твори

Тарас В'єнц
Свіжі твори

Савур (а був колись Халва)
Свіжі твори

Василь Тибель
Свіжі твори

Ганна Осадко
Свіжі твори

Татчин
Свіжі твори

| | | [ Лімерики] | | | |

Згенеровано за 1.5704729557037 сек.

Усі права застережено.
Всі права на сайт належать ТОВ «Джерела М»
Авторські права на твори та рецензії належать їх авторам.
Дизайн та програмування KP-design

Часопис української культури

Що почитати

• Погляд на світ через призму пародії.
«Прометей поміж грудей» – тільки ця провокативна назва збірки чого варта! І це не натяк, це те, про …→

• День Соборності України
Вітаємо всіх з днем Соборності! Бажаємо нашій державі незламності, непохитності, витримки та величчі! …→

• Українські традиції та звичаї
Друзі! На сайті “Онлайн Криївка” є дуже цікава добірка книг про українські традиції та звичаї. …→

• Графічний роман “Серед овець”
Графічний роман Корешкова Олександра «Серед овець», можна було б сміливо віднести до антиутопії, як …→