Error No: 1242 - MySQL error Subquery returns more than 1 row
Query:
SELECT p.picture_id as picture_id, b.b_picture_id as b_picture_id, p.location as t_location, b.location as b_location FROM picturetag pt LEFT JOIN picture p ON p.picture_id=pt.picture_id LEFT JOIN b_picture b ON b.b_picture_id=pt.b_picture_id WHERE pt.tag_id=6136 AND pt.picturetag_id > (SELECT picturetag_id FROM picturetag WHERE picture_id=985946 AND tag_id=6136) GROUP BY pt.b_picture_id,pt.picture_id ORDER BY pt.picturetag_id ASC LIMIT 1
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(121): Mysql->execute('\n SE...', 0)
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(4545): PictureTag->getNext('985946', '6136', 'picture_id')
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->t_picture()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main}Error No: 1242 - MySQL error Subquery returns more than 1 row
Query:
SELECT p.picture_id as picture_id, b.b_picture_id as b_picture_id, p.location as t_location, b.location as b_location FROM picturetag pt LEFT JOIN picture p ON p.picture_id=pt.picture_id LEFT JOIN b_picture b ON b.b_picture_id=pt.b_picture_id WHERE pt.tag_id=6136 AND pt.picturetag_id < (SELECT picturetag_id FROM picturetag WHERE picture_id=985946 AND tag_id=6136) GROUP BY pt.b_picture_id,pt.picture_id ORDER BY pt.picturetag_id DESC LIMIT 1
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(148): Mysql->execute('\n SE...', 0)
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(4546): PictureTag->getPrevious('985946', '6136', 'picture_id')
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->t_picture()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main}Error No: 1242 - MySQL error Subquery returns more than 1 row
Query:
SELECT COUNT(*) FROM picturetag pt WHERE pt.tag_id=6136 AND pt.picturetag_id <= (SELECT picturetag_id FROM picturetag WHERE picture_id=985946 AND tag_id=6136)
#0 /var/www/tip4.boeren.nu/public_html/classes/class.picturetag.php(151): Mysql->execute('SELECT COUNT(*)...', 2)
#1 /var/www/tip4.boeren.nu/public_html/controllers/show.php(4548): PictureTag->getPosition('985946', '6136', 'picture_id')
#2 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5584): Show->t_picture()
#3 /var/www/tip4.boeren.nu/public_html/controllers/show.php(5597): Show->__construct(Object(mysqli))
#4 /var/www/tip4.boeren.nu/public_html/index.php(15): include_once('/var/www/tip4.b...')
#5 {main} Foto John Deere 8600i van Lohnunternehmen Heidkamp

John Deere 8600i van SiegerJD

John Deere 8600i

SiegerJD 9jr geleden

Lohnunternehmen Heidkamp uit Wesuwe met de 8600i

Reacties

tinus 9jr geleden

Mooi filmpje!

SiegerJD 9jr geleden

@Tinus Bedankt!

+1

tinus 9jr geleden

@SiegerJD Heb het bedrijf ook even aangemaakt voor toekomstige spots:
boeren.nu/bedrijf/1434-lohnunternehmen-heidkamp/

fendtvario 9jr geleden

@SiegerJD waren ze van heidkamp nog lang bezig met de mais?

SiegerJD 9jr geleden

@fendtvario Dit was 2 week geleden. Heb geen idee of ze nu nog bezig zijn.

fendtvario 9jr geleden

@SiegerJD oké zal wel is effe bij hun horen of ze nog bezig zijn

JD6930 9jr geleden

Kijk! Dat zijn de plaatjes!

Het beste van het beste uit Duitsland( Coesfeld-Flamsschen, Mannheim en Zweibrücken)!

MAIS HAKSELEN FOTO'S
FOTO 0 VAN 814

REACTIES 2	PUNTEN 7	WEERGAVES 253

MEER FOTO'S Lohnunternehmen Heidkamp materieelfoto's John Deere 8600i foto's SiegerJD's foto's mais hakselen foto's
MEER INFORMATIE Technische gegevens
GESPOT OP DEZE FOTO Lohnunternehmen Heidkamp Haren-Wesuwe