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

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

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



	ПОШУК

АВТОРУ:

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

	Пароль



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

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

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 = '2185'
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 = '4631'
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 = '254'
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 = '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 = '271'
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 = '980'
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 = '220'
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 = '427'
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 = '7956'
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 = '3687'
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 = '5634'
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 = '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 = '5334'
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 = '3846'
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 = '6169'
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 = '356'
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 = '662'
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 = '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 = '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 = '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'

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

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 = '8859'
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 = '4404'
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 = '12272'
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 = '12291'
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 = '10083'
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 = ''
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 = '11145'
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 = '6278'
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 = '1639'
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 = '6498'
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 = '8327'
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'

Вікторія Коновалець
Свіжі твори

Сонце Місяць
Свіжі твори

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

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

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

Ірина Новіцька
Свіжі твори

Юлія-Ванда Мусаковська
Свіжі твори

Володимир Вакуленко-К.
Свіжі твори

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

Михайло Карповий
Свіжі твори

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

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

Наталка Тактреба
Свіжі твори

Maria Goncharenko
Свіжі твори

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

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

Антоніна Спірідончева
Свіжі твори

div4yna_zirka
Свіжі твори

***
Свіжі твори

Демо
Свіжі твори

Валерія
Свіжі твори

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

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

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

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

Наталка Янушевич
Свіжі твори

Ніна Яворська
Свіжі твори

Леся Одинець
Свіжі твори

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

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

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


Свіжі твори

Шон Маклех
Свіжі твори

Надія Позняк
Свіжі твори

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

Leonidius Pr.
Свіжі твори

Анатолій Черняхівський
Свіжі твори

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

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

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

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

Що почитати

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

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

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

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