|
|
| Авторів: |
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 = '183'
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 = '1316'
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 = '205'
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 = '148'
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 = '395'
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 = '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 = '195'
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 = '795'
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 = '63'
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 = '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 = '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 = '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 = '171'
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 = '3489'
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 = '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 = '442'
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 = '124'
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 = '1042'
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 = '152'
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 = '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 = '238'
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 = '37'
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 = '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 = '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 = '2237'
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 = '221'
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 = '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 = '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 = '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 = '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 = '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 = '1052'
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 = '761'
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 = '1355'
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 = '572'
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 = '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 = '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 = '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 = '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 = '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 = '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 = '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 = '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 = ''
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'
|
|