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

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

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



	ПОШУК

АВТОРУ:

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

	Пароль



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

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

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 = '876'
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 = '2919'
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 = '2162'
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 = '2556'
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 = '57'
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 = '1352'
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 = '2098'
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 = '3514'
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 = '3274'
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 = '2423'
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 = '3895'
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 = '1773'
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 = '4022'
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 = '1399'
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 = '2030'
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 = '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 = '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 = '4083'
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 = '4568'
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 = '2380'
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 = '4829'
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 = '4215'
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 = '7603'
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 = '319'
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 = '5150'
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 = '5081'
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 = '214'
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 = '5945'
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 = '4338'
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 = '921'
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 = '6874'
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 = '11231'
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'

Галина Михайловська
Свіжі твори

Володимир Сірий
Свіжі твори

Наталка Ліщинська
Свіжі твори

Стах
Свіжі твори

Камаєв Юрій Статус: Історик
Свіжі твори

Олесь
Свіжі твори

Дара К.
Свіжі твори


Свіжі твори

Климентій Осика-Маєвський, граф
Свіжі твори

Софія Кримовська
Свіжі твори

KF
Свіжі твори

Росткович Олег
Свіжі твори

Зоряна Львів
Свіжі твори

Микола Цибенко
Свіжі твори

Петро Муравій
Свіжі твори

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

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

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

коник єгор
Свіжі твори

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

Юрій Кирик
Свіжі твори

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

Валерій Голуб
Свіжі твори

Олександр Зубрій
Свіжі твори

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

Ганна Осмоловська
Свіжі твори

Михайло Гафія Трайста
Свіжі твори

Віктор Чубенко
Свіжі твори

koka cherkaskij
Свіжі твори

Ганзенко Олексій
Свіжі твори

Той, що греблі рве
Свіжі твори

Tamara Shevchenko
Свіжі твори

Юрко Позаяк
Свіжі твори

Віктор Насипаний
Свіжі твори

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

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

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

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

Що почитати

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

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

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

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