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

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

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



	ПОШУК

АВТОРУ:

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

	Пароль



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

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

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 = '193'
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 = '497'
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 = '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 = '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 = '375'
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 = '74'
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 = '48'
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 = '390'
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 = '2390'
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 = '2616'
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 = '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 = '554'
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 = '849'
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 = '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 = '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 = '4463'
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 = '2536'
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 = '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 = '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 = '529'
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 = '5371'
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 = '3149'
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 = '4374'
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 = '1211'
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 = '1932'
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 = '5855'
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 = ''
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 = '12399'
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'

Василь Триндюк
Свіжі твори

Володимир Чернишенко
Свіжі твори

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

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

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

Дана Рудик
Свіжі твори

Vita
Свіжі твори

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

Третє Я (колишній ТШЗ)
Свіжі твори

Silverwolf
Свіжі твори

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

Сергій Аркуша
Свіжі твори

Любов Лібуркіна
Свіжі твори

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

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

Мирослава
Свіжі твори

Діма Княжич
Свіжі твори

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

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

Влад Савенок
Свіжі твори

Микола Мисковець
Свіжі твори

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

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

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

Тед Лещак
Свіжі твори

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

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

Галина І
Свіжі твори

Lina Litvinova
Свіжі твори

Палко
Свіжі твори

scatterbrain
Свіжі твори

Залєвський Петро
Свіжі твори

Євгенія Люба
Свіжі твори

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


Свіжі твори

Уляна Янко
Свіжі твори

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

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

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

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

Що почитати

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

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

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

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