$sql = 'SELECT ' .
    'movierelease.releaseid,' .
    'movierelease.movieid,' .
    'movie.title,' .
    'movierelease.title as local_title,' .
    'movierelease.subtitle as sub_title,' .
    'movierelease.episodes as episodes,' .
    'movie.copyrightnotice,' .
    'movie.homepage,' .
    'movie.censor,' .
    'movie.productioncompany,' .
    'movie.prodnotes,' .
    'movie.prodyear,' .
    'movie.materialdirectory,' .

    'genre.name as genre,' .

    'censor.censortext,' .


    'dvd.dvdid,' .
    'dvd.screenratio as dvd_screenratio,' .
    'dvd.audioformat as dvd_audioformat,' .
    'dvd.spec2 as dvd_type_of_disc,' .
    'dvd.spec1 as dvd_other_information,' .
    'dvd.dubbed as dvd_spoken_languages,' .
    'dvd.subtitled as dvd_subtitles,' .
    'dvd.spec3 as dvd_replicating_company,' .
    'dvd.runtime as dvd_runtime,' .
    'dvd.notes as dvd_extramaterial,' .
    'dvd.deadlinepack as dvd_deadlinepack,' .
    'dvd.deadlineprint as dvd_deadlineprint,' .
    'dvd.firstproof as dvd_firstproof,' .
    'dvd.approvedaw as dvd_approvedaw,' .
    'dvd.pack as dvd_pack,' .
    'dvd.specialpack as dvd_specialpack,' .
    'dvd.multipack as dvd_multipack,' .
    'dvd.numberofdiscs as dvd_numberofdiscs,' .

    'bluray.dvdid as brid,' .
    'bluray.screenratio as br_screenratio,' .
    'bluray.audioformat as br_audioformat,' .
    'bluray.spec2 as br_type_of_disc,' .
    'bluray.spec1 as br_other_information,' .
    'bluray.dubbed as br_spoken_languages,' .
    'bluray.subtitled as br_subtitles,' .
    'bluray.spec3 as br_replicating_company,' .
    'bluray.runtime as br_runtime,' .
    'bluray.notes as br_extramaterial,' .
    'bluray.deadlinepack as br_deadlinepack,' .
    'bluray.deadlineprint as br_deadlineprint,' .
    'bluray.firstproof as br_firstproof,' .
    'bluray.approvedaw as br_approvedaw,' .
    'bluray.pack as br_pack,' .
    'bluray.specialpack as br_specialpack,' .
    'bluray.multipack as br_multipack,' .
    'bluray.numberofdiscs as br_numberofdiscs,' .

    'bluray.rentalid as br_rentalid, ' .
    'bluray.sellthid as br_sellthid, ' .

    'rental.releasedate as dvd_rental_releasedate,' .
    'rental.ean as dvd_rental_ean,' .

    'sellth.releasedate as dvd_sell_releasedate,' .
    'sellth.ean as dvd_sell_ean,' .

    'concept.name as concept_name,' .
    'concept.description as concept_description,' .

    'brand.name as brand_name,' .
    'brand.description as brand_description,' .

    'country.countrycode as countrycode' .

    ' FROM movierelease' .
    ' LEFT JOIN movie' .
    ' ON movie.movieid=movierelease.movieid' .
    ' LEFT JOIN genre' .
    ' ON movierelease.genreid=genre.genreid' .
    ' LEFT JOIN censor' .
    ' ON censor.censorid=movie.censor' .
    ' LEFT JOIN dvd' .
    ' ON movierelease.dvdid=dvd.dvdid' .
    ' LEFT JOIN bluray' .
    ' ON movierelease.blurayid=bluray.dvdid' .
    ' LEFT JOIN rental' .
    ' ON dvd.rentalid=rental.rentalid' .
    ' LEFT JOIN sellth' .
    ' ON dvd.sellthid=sellth.sellthid' .
    ' LEFT JOIN concept' .
    ' ON movierelease.conceptid=concept.conceptid' .
    ' LEFT JOIN brand' .
    ' ON movierelease.brandid=brand.brandid' .
    ' LEFT JOIN country' .
    ' ON movierelease.countryid=country.countryid' .

    ' WHERE country.countrycode = "' . $cc . '"' .

    ' LIMIT ' . $start . ', ' . $end;